Home » RDBMS Server » Server Administration » Listener error
Listener error [message #265452] Thu, 06 September 2007 06:07 Go to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
i had connect to rman but when i try to check the status of listener it is saying command not found.
i cant able ping the newdb?




[oracle@infra ~]$ /vm/product/database/bin/rman target/

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Sep 6 22:40:26 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: NEWDB (DBID=2873006420, not open)

RMAN> host;

[oracle@infra ~]$ tnping newdb
bash: tnping: command not found
[oracle@infra ~]$
[oracle@infra ~]$
[oracle@infra ~]$ lsnrctl status
bash: lsnrctl: command not found
[oracle@infra ~]$
[oracle@infra ~]$
Re: Listener error [message #265456 is a reply to message #265452] Thu, 06 September 2007 06:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

which lsnrctl
/oracle/app/oracle/product/10.2.0/db_1/bin/lsnrctl


Go to thew bin directory and start it.

Your path settings is not ok.
Re: Listener error [message #265468 is a reply to message #265452] Thu, 06 September 2007 06:59 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
I tried that but its again showing the same error.
but here the port is 1522 and the uptime is 0 will that creates any problem?



[oracle@infra bin]$ ./lsnrctl start LISTENER

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-SEP-2007 23:31:40

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /vm/product/database/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /vm/product/database/network/admin/listener.ora
Log messages written to /vm/product/database/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=infra.isc.hom)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 06-SEP-2007 23:31:40
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /vm/product/database/network/admin/listener.ora
Listener Log File /vm/product/database/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=infra.isc.hom)(PORT=1522)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@infra bin]$ lsnrctl status
bash: lsnrctl: command not found
[oracle@infra bin]$
Re: Listener error [message #265478 is a reply to message #265468] Thu, 06 September 2007 07:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
./lsnrctl start LISTENER

Quote:
lsnrctl status

Don't you see the difference?
Once again you badly set your environment.
See your other posts, this is the same error again and again.

Regards
Michel
Re: Listener error [message #265489 is a reply to message #265452] Thu, 06 September 2007 07:27 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
still i cant understand what mistake am doing
please can you say briefly what error am doing?
Re: Listener error [message #265491 is a reply to message #265489] Thu, 06 September 2007 07:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

http://www.orafaq.com/forum/m/265417/102589/#msg_265417

Maybe you should envisage to change your professional career?

Regards
Michel
Re: Listener error [message #265504 is a reply to message #265452] Thu, 06 September 2007 08:17 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
ara.oracle wrote on Thu, 06 September 2007 07:07


[oracle@infra ~]$ tnping newdb
bash: tnping: command not found



The proper command is tnsping
Re: Listener error [message #265939 is a reply to message #265452] Sat, 08 September 2007 00:52 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

listener opst 1522 but default it is 1521. You changed it. So , take action.
Re: Listener error [message #265989 is a reply to message #265939] Sat, 08 September 2007 09:17 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ara.oracle,

An overview of your scenario:

1) regarding command name:
tnping does not exist;
==> should be "tnsping"

2) as below:
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

there is no "newdb" running... as of your desired command:
  • tnsping newdb


3) you have problem with environment variable also.
http://www.orafaq.com/forum/t/88785/110238/#msg_num_24

It is easy to solve it.
Just define $ORACLE_HOME before using it.

4) You have also to post here what changes you have done to us. This feedback would help us to help you better instead of just guessing.

5) Looks like your problem is not with Oracle. But with organization itself. Try to consider it for you benefit.

Regards,


mson77
Re: Listener error [message #266005 is a reply to message #265452] Sat, 08 September 2007 21:58 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

mson77 can you change your font?
Re: Listener error [message #266007 is a reply to message #266005] Sat, 08 September 2007 22:31 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello Arju,

for sure... I can change the font.
Usually I use "Courier New" because it is mono spaced and I guess it is easier to read.
When you say "font" you mean font face or font size or both?

Any suggestion for me?
My goal is to make the text easier to read for everybody.
My system is Fedora7, my browser is FF and I open this forum with default settings. When I reply a topic I just append font face as "Courier New". If font-size is small... please let me know and I will change on the further posts.

Regards,

mson77
Re: Listener error [message #266008 is a reply to message #265452] Sat, 08 September 2007 22:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I like Courier New. It reminds me of the old VT-52 days.
Re: Listener error [message #266009 is a reply to message #265452] Sat, 08 September 2007 22:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

The latest you posted is ok and readable nicely.

Thanks.
Re: Listener error [message #266011 is a reply to message #266009] Sat, 08 September 2007 23:15 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hummmm.... got lost now....

Courier New... or default font...? (talking about font face)

Arju... maybe your initial comment refers to font size? If I use font size 3... like this... the text would be good to be read?

All the documents I provide... emails, texts,... since N-years... I always have used "Courier New"... mainly for being a traditional font and it is mono spaced... no mistake between "1" and "l"...

But I guess I am resilient.

I accept suggestions... always to improve.

Regards,


mson77
Re: Listener error [message #266021 is a reply to message #266011] Sun, 09 September 2007 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you want the opinion who has no more young eyes.
Courier New size 2 is harder to read than Arial same size. It is too small.
Size 3 is too big.
Fixed width leads to a ratio between height and width that streches small letters.
This is the reason why variable width font were created.

Compare:
Courier New 2: the brown quick fox jumps over the lazy dog / THE BROWN QUICK FOX JUMPS OVER THE LAZY DOG
Arial 2: the brown quick fox jumps over the lazy dog / THE BROWN QUICK FOX JUMPS OVER THE LAZY DOG
Courier New 3: the brown quick fox jumps over the lazy dog / THE BROWN QUICK FOX JUMPS OVER THE LAZY DOG

Courier New is easier to read only for upper case letters.
Just my opinion.

Regards
Michel
Re: Listener error [message #266025 is a reply to message #266021] Sun, 09 September 2007 01:05 Go to previous message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

This is a sample using the default configuration.

I understood that the Arial font face will be easier to read.
I will follow the suggestion.

Thank you ALL for the feedback!
Regards,


mson77
==============================================
by the way: How about the original thread "Listener error"

I hope ara.oracle be just ara.oracle with no extra alias... setup his environment and have his problems solved.
Previous Topic: segmentation fault
Next Topic: tool to extract scn from datafile header
Goto Forum:
  


Current Time: Mon Feb 24 23:59:54 CST 2025