Home » RDBMS Server » Server Administration » Listener do not work
Listener do not work [message #205636] Sun, 26 November 2006 22:55 Go to next message
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!
Re: Listener do not work [message #205637 is a reply to message #205636] Sun, 26 November 2006 23:03 Go to previous messageGo to next message
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
Re: Listener do not work [message #205639 is a reply to message #205637] Sun, 26 November 2006 23:13 Go to previous messageGo to next message
rushing
Messages: 135
Registered: January 2004
Location: Beijing,China
Senior Member
After set admin, how to register tnslister path?
thanks!
Re: Listener do not work [message #205640 is a reply to message #205639] Sun, 26 November 2006 23:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

sql>alter system register;




hope this helps
Taj
Re: Listener do not work [message #205641 is a reply to message #205640] Sun, 26 November 2006 23:22 Go to previous messageGo to next message
rushing
Messages: 135
Registered: January 2004
Location: Beijing,China
Senior Member
how to alter system register?
thanks!
Re: Listener do not work [message #205644 is a reply to message #205641] Sun, 26 November 2006 23:28 Go to previous messageGo to next message
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
Re: Listener do not work [message #205661 is a reply to message #205644] Mon, 27 November 2006 00:34 Go to previous messageGo to next message
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

Re: Listener do not work [message #205706 is a reply to message #205636] Mon, 27 November 2006 03:26 Go to previous message
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:
  


Current Time: Sat Dec 10 20:34:18 CST 2016

Total time taken to generate the page: 0.08105 seconds