Home » RDBMS Server » Networking and Gateways » No Listener
No Listener [message #266893] Tue, 11 September 2007 23:36 Go to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Dear Experts,

quite often when i start my database Server i found the message "no Listener" Error.

in the listener.ora file i dont find any changes that caused this error. i also type this commdnd in the command prompt.

C:\>lsnrctl

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 12-SEP-2007 10:30
:32

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> set current_listener
Current Listener is LISTENER
LSNRCTL> status warehouse
Connecting to (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=warehouse))(ADDRESS=(PROT
OCOL=TCP)(HOST=172.100.50.103)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 12-SEP-2007 09:27:38
Uptime 0 days 1 hr. 3 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.1.0\db_1\network\admin\listener.o
ra
Listener Log File E:\oracle\product\10.1.0\db_1\network\log\listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=warehouse)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=warehouse)(PORT=8080))(Presentation=
HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=warehouse)(PORT=2100))(Presentation=
FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "SDWH.SML" has 1 instance(s).
Instance "sdwh", status READY, has 1 handler(s) for this service...
Service "SDWHXDB.SML" has 1 instance(s).
Instance "sdwh", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>


----------------------------------------------
i found the status....listenere is up and running..... i check also form control panel>services> .....listener running automatically there.

but If i restart my database server............then listener running and working.

i want to know pls, what is the exact reason causing this and what is the soulution to run and active listener without restarting database server?

Note: MY Database Server name is : Warehosue
Listener Name is : Listener
OS : 2003 Server (32 bit)
Database : Oracle 10g (32 bit)


Re: No Listener [message #266898 is a reply to message #266893] Tue, 11 September 2007 23:46 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Make the listener service automatic or in startup set the listener service.

According to your question it is not clear what you wanted to mean.
Re: No Listener [message #266899 is a reply to message #266893] Tue, 11 September 2007 23:47 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>quite often when i start my database Server i found the message "no Listener" Error.
>but If i restart my database server............then listener running and working.

To me, the 2 statements above directly contradict each other.

Based upon both above statements, you should only "restart", which works & avoid "start" which does not work.

Re: No Listener [message #266900 is a reply to message #266893] Tue, 11 September 2007 23:48 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
what is the soulution to run and active listener


What does it mean?

To start,
lsnrctl start LISTENER

Re: No Listener [message #266915 is a reply to message #266900] Wed, 12 September 2007 00:14 Go to previous messageGo to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

My problem is as follows:

my computer name is warehouse: i shoutdown my computer before leaving my office. Next day when i start my computer i found the error "No Listner" but this error not everyday..... someday i found this error when i start my computer. if i check the status of Listener (when i face this error)from command prompt its running and up but if i want to connect to the database it return the error "No Listner" in that situation i restart my computer and later on i can easily conntect to the database.

My question why listner caused that problem although its status is up and running..............and why i need to restart my computer to get connect to the database?

is there any exact solution if listner caused this error, without restarting the computer ?

Thank you.

Kamal Hossain.

Re: No Listener [message #266922 is a reply to message #266893] Wed, 12 September 2007 00:30 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
OK, I admit I am totally confused.
What is the name of the host/system which is the database server?
What is the name of the host/system running the Oracle listener?

Under what conditions can other client continue to connect to DB?

I suggest that your manager hires somebody who actually knows how Oracle DB & networking actually works.
Re: No Listener [message #266927 is a reply to message #266915] Wed, 12 September 2007 00:51 Go to previous message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello dbhossain,

Your environment:
Windows 2003R2 SP2 32bit;
Oracle 10g v10.2.0.1

Are you sure that the problem is with your listener?
I faced with a problem quite similar as yours: networking.

Independently of listener... are you able to connect to the databases via sqlplus on the server? (because in this case you don't use listener)

I mean... connect and do some 'select' to prove it is up and running.

My experience was... after reboot... my databases did not open. I had to connect via sqlplus... shutdown/startup. Then the database goes up and running.

I tried hard many tests... but I solved... formatting/reinstalling W2003.

Regards,


mson77



Previous Topic: where can I find the protocol.ora file
Next Topic: problems with listeners
Goto Forum:
  


Current Time: Wed Dec 07 20:13:34 CST 2016

Total time taken to generate the page: 0.15312 seconds