OraFAQ Forum: Server Administration » Listener do not work

Home » RDBMS Server » Server Administration » Listener do not work

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

Listener do not work [message #205636]

Sun, 26 November 2006 22:55

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

In Oracle 9i, the listener do not work.
In Windows services , the property of OracleListener show the execute file path is empty.
I try to add another listerer, but it still not work.
How to do?
Thanks!

Report message to a moderator

Re: Listener do not work [message #205637 is a reply to message #205636]

Sun, 26 November 2006 23:03

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

Senior Member

hi,

first set ur TNS_ADMIN enviorment variable ...
like

cmd>set tns_admin=oracle-home/network/admin

and
go registry set "TNSLSNR.EXE" path.

oracle-home/bin/tnslsnr.exe

and

start ur listener

cmd>lsnrctl start

then

try again ...

hope this helps
Taj

Report message to a moderator

Re: Listener do not work [message #205639 is a reply to message #205637]

Sun, 26 November 2006 23:13

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

After set admin, how to register tnslister path?
thanks!

Report message to a moderator

Re: Listener do not work [message #205640 is a reply to message #205639]

Sun, 26 November 2006 23:13

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

Senior Member

hi

sql>alter system register;

hope this helps
Taj

Report message to a moderator

Re: Listener do not work [message #205641 is a reply to message #205640]

Sun, 26 November 2006 23:22

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

how to alter system register?
thanks!

Report message to a moderator

Re: Listener do not work [message #205644 is a reply to message #205641]

Sun, 26 November 2006 23:28

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

Senior Member

hi

you want to register ur listener if yes then
used below cmd on ur sqlplus cmd line.

sql>alter system register;

how to register tnslister path?

where in registry give "location of tnslsnr.exe"
normally : oracle-home/bin/ directory.

hope this helps
Taj

Report message to a moderator

Re: Listener do not work [message #205661 is a reply to message #205644]

Mon, 27 November 2006 00:34

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

In cmd , after set admin ,the statement below is wrong:

alter system register;

In sqlplus, because the listener does not work, so could not login.

Sad

Report message to a moderator

Re: Listener do not work [message #205706 is a reply to message #205636]

Mon, 27 November 2006 03:26

bwetkstr
Messages: 114
Registered: August 2005

Senior Member

You don't register your listener, but your register your instance.

ps: You don't need a listener to logon to your database, use a local connection and you will by pass the listener.

[Updated on: Mon, 27 November 2006 03:30]

Report message to a moderator

Previous Topic:	High watermark identyfying
Next Topic:	Capacity planning and perfomance issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:32:37 CDT 2024