Home » RDBMS Server » Networking and Gateways » What does status UNKNOWN mean for a service? (Oracle 10.2.0.4 AIX 5.3)
What does status UNKNOWN mean for a service? [message #457861] Wed, 26 May 2010 04:04 Go to next message
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 #457866 is a reply to message #457861] Wed, 26 May 2010 04:15 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It means that you describe this instance in listener.ora but no contact with this instance has been done.
With the current versions you should not give any instance in listener.ora but ask the instance to register when it starts using LOCAL_LISTENER parameter (or nothing as you use the default setting, prot 1521..., the database will automatically find the listener and register).

Regards
Michel
Re: What does status UNKNOWN mean for a service? [message #457932 is a reply to message #457866] Wed, 26 May 2010 08:14 Go to previous messageGo to next message
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 #457948 is a reply to message #457932] Wed, 26 May 2010 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can I configure the databases to use only the Oracle 10g listener.

Do not tell your 9i listener to listen for the 10g database.

Quote:
which is part of the reason why I am having problems with the 10g database.

Which ones?

Regards
Michel
Re: What does status UNKNOWN mean for a service? [message #457994 is a reply to message #457948] Wed, 26 May 2010 10:51 Go to previous messageGo to next message
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 #457996 is a reply to message #457994] Wed, 26 May 2010 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And 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 #458003 is a reply to message #457996] Wed, 26 May 2010 11:48 Go to previous messageGo to next message
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:55
And 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 #458005 is a reply to message #458003] Wed, 26 May 2010 11:53 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So start the 10g listener.
I actually don't understand your problem.
If you want to start 10g listener then start 10g listener.

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 Go to previous message
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:53
So 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

Previous Topic: Client to server connection
Next Topic: listener query
Goto Forum:
  


Current Time: Sat Sep 20 13:59:05 CDT 2014

Total time taken to generate the page: 0.07748 seconds