| No Listener [message #266893] |
Tue, 11 September 2007 23:36  |
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 #266927 is a reply to message #266915] |
Wed, 12 September 2007 00:51  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
