| stephdba |
Posted: Apr 23, 2008 06:35:03 AM |
Total Post: 4
Joined: Apr, 2008
|
I am having problems with my listener. It is unable to connect to a service. When I issue the command "lsnrctl start" it starts up an idle instance and listing all the services defined in my tnsnames file with an unknown status
Below is the error when I issued the above code:
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 21-APR-2008 17:53:54
Copyright (c) 1991, 2007, Oracle. All rights reserved
Starting /u01/app/oracle//product/11.1.0/db_2/bin/tnslsnr: please wait....
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle//product/11.1.0/db_2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (Description=(ADDRESS=(PROTOCOL=tcp) (HOST=localhost.localdomain)(PORT=1521)))
Connecting to (Description=(ADDRESS=(PROTOCOL=tcp) (HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
--------------------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 21-APR-2008 17:53:54
Uptime 0 days 0hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parmeter File (Description=(ADDRESS=(PROTOCOL=tcp) (HOST=localhost.localdomain)(PORT=1521)))
Listener Log (Description=(ADDRESS=(PROTOCOL=tcp) (HOST=localhost.localdomain)(PORT=1521)))
Listening Endpoints Summary....
(Description=(ADDRESS=(PROTOCOL=tcp) (HOST=localhost.localdomain)(PORT=1521)))
Services Summary....
Service "PLSExtproc" has 1 instance(s)
Instance "PLSExtproc", status UNKNOWN, has 1 handler(s) for this service.....
Service "insurview" has 1 instance(s)
Instance "insurview", status UNKNOWN, has 1 handler(s) for this service.....
The command completed successfully
|
|
|
 GOPU |
| Posted: Apr 23, 2008 06:56:50 AM |  |
|
Total Post: 350
Joined: Apr, 2008
|
hi,
When you are trying to connect to a service what error you are facing ?
post that error.
Regards
Gopu
|
|
|
|
|
| stephdba |
| Posted: Apr 23, 2008 07:33:18 AM | |
|
Total Post: 4
Joined: Apr, 2008
|
when I try to connect to the service I got ora-01219 database not open error. this is after issuing the "startup mount" command.
I later tried to force the listener by issuing this command.
lsnrctl services insurview and I got below error:
Connecting to ............
DESCRIPTION = ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)))(CONNECT_DATA = ( SERVICE_NAME = insurview)))
tns-12541:tns:no listener
tns-12560:tns:protocol adapter error
tns-00511: no listener
linux error: 111 connection refused
|
|
|
|
|
| GOPU |
| Posted: Apr 23, 2008 07:45:12 AM | |
|
Total Post: 350
Joined: Apr, 2008
|
you mounted the database only, that's why you got the error ora-01219 database not open .
you open the database....
|
|
|
|
|
| stephdba |
| Posted: Apr 23, 2008 12:16:24 PM | |
|
Total Post: 4
Joined: Apr, 2008
|
yes, but when I issue the lsnrctl status the service name I wanted was not listed. Instead I got TNS-12541: TNS:no listener
|
|
|
|
|
| GOPU |
| Posted: Apr 23, 2008 11:41:01 PM | |
|
Total Post: 350
Joined: Apr, 2008
|
Hi,
no listner means, the listner is not up.
Regards
Gopu
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 24, 2008 01:15:27 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
1. first stop lisnter services
2. throught netca delete listener.ora file
3. open your database
4. recreate new listner.ora file through NETCA.
|
|
|
|
|
| stephdba |
| Posted: Apr 28, 2008 12:26:37 PM | |
|
Total Post: 4
Joined: Apr, 2008
|
I finally figured out what was wrong. I uninstalled Oracle to re-install it again. I later discovered that Oracle had problems with my network card. I am in the process of installing the driver for my network card. Hopefully it should resolve the problem.
Thanks
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
