| What does status UNKNOWN mean for a service? [message #457861] |
Wed, 26 May 2010 04:04  |
efachim
Messages: 42
Registered: July 2008
|
Member |
|
|
Hi Guys,
I get this error when I try to connect to this database service as another user. I can connect to it as sys without any problem and the database is up.
And when I check to see whether the listener is running for that service, using lsnrctl status command, it shows that the service is UNKNOWN. What does this status mean?
Thanks.
> sqlplus usera/password@prod
SQL*Plus: Release 9.2.0.5.0 - Production on Tue May 25 14:50:35 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
/home/oracle> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 25-MAY-2010 22:56:22
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xxx)(Port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production
Start Date 12-JAN-2010 05:40:15
Uptime 133 days 16 hr. 16 min. 8 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /etc/listener.ora
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=1521)))
Services Summary...
Service "prod" has 1 instance(s).
Instance "prod", status UNKNOWN, has 1 handler(s) for this service...
[Updated on: Wed, 26 May 2010 04:07] Report message to a moderator |
|
|
|
|
|
| Re: What does status UNKNOWN mean for a service? [message #457932 is a reply to message #457866] |
Wed, 26 May 2010 08:14  |
efachim
Messages: 42
Registered: July 2008
|
Member |
|
|
Thanks Michel.
Actually, the prod database is a 10gR2 database while there are other Oracle 9.2.0.5 databases on this server. The server has both Oracle versions.
How can I configure the databases to use only the Oracle 10g listener. Currently, they are using the 9i listener, which is part of the reason why I am having problems with the 10g database.
|
|
|
|
|
|
| Re: What does status UNKNOWN mean for a service? [message #457994 is a reply to message #457948] |
Wed, 26 May 2010 10:51 |
efachim
Messages: 42
Registered: July 2008
|
Member |
|
|
Michel,
Unfortunately, I am not sure how I am telling the 9i listener to listen for the 10g database. I hasten to add that I have inherited this work and setting up listeners is new to me.
I would only like to use the 10g listener at this point.
This is a copy of my listener.ora file, so you can see how it is currently set up.
vi /etc/listener.ora
################
# Filename......: listener.ora
# Name..........: LOCAL_REGION.world
# Date..........: 21-JAN-05
################
LISTENER =
(ADDRESS = (PROTOCOL = TCP) (Host = host) (Port = 1521))
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = proddm)
(SERVICE_NAME = proddm.world)
(ORACLE_HOME = /oracle/product/9.2.0.5))
# (SID_DESC =
# (SID_NAME = prod)
# (SERVICE_NAME = prod.world)
# (ORACLE_HOME = /oracle/product/9.2.0.5))
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 300
TRACE_LEVEL_LISTENER = OFF
LOGGING_LISTENER = OFF
#
LSNR_QA =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = host)
(Port = 1525)
)
)
STARTUP_WAIT_TIME_LSNR_QA = 0
CONNECT_TIMEOUT_LSNR_QA = 300
TRACE_LEVEL_LSNR_QA = OFF
LOGGING_LSNR_QA=OFF
SID_LIST_LSNR_QA=
(SID_LIST=
(SID_DESC =
(SID_NAME= enqa)
(SERVICE_NAME = enqa.world)
(ORACLE_HOME = /oracle/product/9.2.0.5)
)
)
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LSNR_QA=OFF
(SID_LIST=
(SID_DESC =
(SERVICE_NAME = r7.world)
(SID_NAME= r7))
(SID_DESC =
(SERVICE_NAME = c7.world)
(SID_NAME= c7))
(SID_DESC =
(SERVICE_NAME = hr7.world)
(SID_NAME= hr7))
(SID_DESC =
(SERVICE_NAME = proddm10.world)
(SID_NAME= proddm10))
)
|
|
|
|
|
|
| Re: What does status UNKNOWN mean for a service? [message #458003 is a reply to message #457996] |
Wed, 26 May 2010 11:48 |
efachim
Messages: 42
Registered: July 2008
|
Member |
|
|
Sorry... prod is the Oracle 10g database which has actually been commented out.
This is what I get when I check the lsnrctl status. The "STATUS of the LISTENER version" seems to show that it is the 9.2.0.5 version that is running. That is what I would like to change to the 10g version.
(prod):/home/oracle> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 26-MAY-2010 12:42:27
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=host)(Port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production
Start Date 12-JAN-2010 05:40:15
Uptime 134 days 6 hr. 2 min. 12 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /etc/listener.ora
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host.bdcx.corp)(PORT=1521)))
Services Summary...
Service "proddm7.world" has 1 instance(s).
Instance "proddm7", status READY, has 1 handler(s) for this service...
Service "enqa.world" has 1 instance(s).
Instance "enqa", status READY, has 1 handler(s) for this service...
Service "prod7.world" has 1 instance(s).
Instance "prod7", status READY, has 1 handler(s) for this service...
The command completed successfully
Michel Cadot wrote on Wed, 26 May 2010 09:55And what is the SID of your 10g database there? Or should I have to guess?
Regards
Michel
|
|
|
|
|
|
| Re: What does status UNKNOWN mean for a service? [message #458013 is a reply to message #458005] |
Wed, 26 May 2010 12:44 |
efachim
Messages: 42
Registered: July 2008
|
Member |
|
|
Thanks Michel.
Got the 10g listener started - From a 9i "environment" I stopped the listener (default 9i). Then changed to a 10g "environment". And then started the listener (default 10g). And then I removed the listing of services for the listener (sid_list_listener entry). So it's working now!!
Michel Cadot wrote on Wed, 26 May 2010 10:53So start the 10g listener.
I actually don't understand your problem.
If you want to start 10g listener then start 10g listener.
Regards
Michel
[Updated on: Wed, 26 May 2010 12:49] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
