OraFAQ Forum: Server Administration » What was the Problem Listener not functing Porperly

Home » RDBMS Server » Server Administration » What was the Problem Listener not functing Porperly

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What was the Problem Listener not functing Porperly [message #204782]

Wed, 22 November 2006 02:07

sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore

Member

Hi while aim starting listener iam getting this problem,can some body help regarding this issue

But Services in windows services showing listerner status as "started"

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.NTS.rethi.com)(P
ORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory

LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.NTS.rethi.com)(P
ORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory

Thnaks in Advance
Sreenivas

[Updated on: Wed, 22 November 2006 02:09]

Report message to a moderator

Re: What was the Problem Listener not functing Porperly [message #204793 is a reply to message #204782]

Wed, 22 November 2006 02:25

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi

check

go through below procedure


start>run>cmd

cmd>set oracle_sid="put_ur_db_name"

cmd>set TNS_ADMIN=Oracle-home/network/admin 

( where ur listener.ora file exists).

start>run>regedit 
-- go registry set [B]tnslnsr.exe[/B] path where exists.

IN registry set 
Field Value 
Name [B]OracleOraHomeTNSListener [/B]
Command TNSLSNR.exe 
Status L 
Description Related to Oracle products

hope this helps
Taj.

Report message to a moderator

Re: What was the Problem Listener not functing Porperly [message #204876 is a reply to message #204793]

Wed, 22 November 2006 08:02

sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore

Member

Thanks Taj

I will Try,i hope this may help

Report message to a moderator

Re: What was the Problem Listener not functing Porperly [message #403553 is a reply to message #204876]

Sat, 16 May 2009 17:46

ashutoshsharma
Messages: 7
Registered: May 2009

Junior Member

Taj where is this setting in registry for ORacle 11g DB?

Report message to a moderator

Re: What was the Problem Listener not functing Porperly [message #444732 is a reply to message #204782]

Tue, 23 February 2010 16:46

globalization_ahmed
Messages: 2
Registered: February 2010
Location: Geneva,IL

Junior Member

Dear,

Configuring Environmental variable:
5) We have to configure few things before we proceed further. Let us start with environment variable, vista users will find the environmental variable under system properties->Advance system settings->Environmental variable. Check the path; edit the user variable name and variable value under variable value past the path of 'bin' directory. In my case the path was " C:\oracle\product\10.2.0\db_3\bin;". In addition to that edit system variable by creating 'ORACLE_HOME' and variable value if not exist. In my case I used value as 'C:\oracle\product\10.2.0\db_3'.
Listener troubleshooting:
6) If your listener is not running then follow the steps given below
a) Go to command prompt and type <lsnrctl status> followed by enter keyword. This will give the status on listener issues or problems.
b) Try to start listener by typing < lsnrctl start> and wait for the system to respond. Try to follow the message you get. Trouble shoot based on the message you get and in case if you get the message as TNS adaptor error, TNS missing, No listener or missing host or object then please continue reading...
c) Oracle Net Manager will be useful to troubleshoot the above issue see the image below fig1.0 (ONM will be typically located somewhere in oracle/network/admin). Click on listener and on the right side click on the 'listener location' and choose 'database services' and check out the contents for the following values starting from 'Global Database Name', 'Oracle Home Directory', 'SID'. In my case Global Database name: mohammed.AhmedMohamme-PC(mohammed is database name and AhmedMohamme-PC is the system name); Home Directory is that path that you have given in the environmental variable and in my case it was 'C:\oracle\product\10.2.0\db_3' and SID in my case was 'mohammed' but it again it depends what you gave your SID when you install the oracle. Try looking in TNS.ORA file.
d) If one want to ensure that the host address that is define in ONM is working then consider using ping command against that host address that is defined in ONM. For vista user go to command prompt-> cd window; type dir followed by enter to check whether it contains ping directory. Then type cd system32 then under the system32 directory type ping against the hostname to ensure it is working or not. If it is not working then consider changing the host name.

Report message to a moderator

Re: What was the Problem Listener not functing Porperly [message #444934 is a reply to message #204782]

Wed, 24 February 2010 21:24

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

>64-bit Windows Error: 2: No such file or directory

Print the contents of your LISTENER.ORA file.
Also, check to see if you have more than one LISTENER.ORA file on the server.

Hemant K Chitale

Report message to a moderator