oracle status unknown,Instance status UNKNOWN, has 1 handler(s) for this service in LISTNER.ora

786543 wrote:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=***************)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for 64-bit abcows: Version 11.2.0.3.0 - Produ

ction

Start Date 15-FEB-2012 13:42:37

Uptime 1 days 0 hr. 40 min. 22 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File E:\app\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora

Listener Log File E:\app\oracle\diag\tnslsnr\*****\listener\alert\log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=****************)(PORT=1521)))

Services Summary...

Service "xyz" has 1 instance(s).

Instance "xyz", status READY, has 1 handler(s) for this service...

Service "xyzXDB" has 1 instance(s).

Instance "xyz", status READY, has 1 handler(s) for this service...

Service "123" has 1 instance(s).

Instance "123", status READY, has 1 handler(s) for this service...

Service "123XDB" has 1 instance(s).

Instance "123", status READY, has 1 handler(s) for this service...

Service "abc" has 2 instance(s).

Instance "abc", status UNKNOWN, has 1 handler(s) for this service...

Instance "abc", status READY, has 1 handler(s) for this service...

Service "abcXDB" has 1 instance(s).

Instance "abc", status READY, has 1 handler(s) for this service...

The command completed successfully

---------------------------

LISTNER.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = abc)

(SID_NAME = 123)

(SID_NAME = xyz)

(ORACLE_HOME = E:\app\oracle\product\11.2.0\dbhome_1)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = ******************)(PORT = 1521))

)

)

Here is the information of lsnrctl status and listner.ora file

Thanks...MVYour SID_LIST is mis-configured. I'm surprised it works at all. It should be

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = abc)

(ORACLE_HOME = E:\app\oracle\product\11.2.0\dbhome_1)

)

(SID_NAME = 123)

(ORACLE_HOME = E:\app\oracle\product\11.2.0\dbhome_1)

)

(SID_NAME = xyz)

(ORACLE_HOME = E:\app\oracle\product\11.2.0\dbhome_1)

)

)Each SID_DESC describes only one SID.

Edited by: EdStevens on Feb 16, 2012 7:55 PM

[[email protected] admin]$ cat listener.ora

# listener.ora Network Configuration File: /ora00/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /ora00/app/oracle/product/11.2.0/db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = ORCL)

(ORACLE_HOME = /ora00/app/oracle/product/11.2.0/db_1)

(SID_NAME = ORCL)

(SID_NAME = OKARCHE)

(SID_NAME = GUTHRIE)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = vmlnxsrv01.vmdomain)(PORT = 1521))

)

)

[[email protected] admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-FEB-2012 19:58:01

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vmlnxsrv01.vmdomain)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 16-FEB-2012 19:49:32

Uptime 0 days 0 hr. 8 min. 29 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /ora00/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File /ora00/app/oracle/diag/tnslsnr/vmlnxsrv01/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmlnxsrv01.vmdomain)(PORT=1521)))

Services Summary...

Service "ORCL" has 2 instance(s).

Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "ORCLXDB" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[[email protected] admin]$vs

[[email protected] admin]$ cat listener.ora

# listener.ora Network Configuration File: /ora00/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /ora00/app/oracle/product/11.2.0/db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = ORCL)

(ORACLE_HOME = /ora00/app/oracle/product/11.2.0/db_1)

(SID_NAME = ORCL)

)

(SID_DESC =

(GLOBAL_DBNAME = OKARCHE)

(ORACLE_HOME = /ora00/app/oracle/product/11.2.0/db_1)

(SID_NAME = OKARCHE)

)

(SID_DESC =

(GLOBAL_DBNAME = GUTHRIE)

(ORACLE_HOME = /ora00/app/oracle/product/11.2.0/db_1)

(SID_NAME = GUTHRIE)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = vmlnxsrv01.vmdomain)(PORT = 1521))

)

)

[[email protected] admin]$ lsnrctl reload

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-FEB-2012 20:00:08

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vmlnxsrv01.vmdomain)(PORT=1521)))

The command completed successfully

[[email protected] admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-FEB-2012 20:00:15

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vmlnxsrv01.vmdomain)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 16-FEB-2012 19:49:32

Uptime 0 days 0 hr. 10 min. 43 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /ora00/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File /ora00/app/oracle/diag/tnslsnr/vmlnxsrv01/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmlnxsrv01.vmdomain)(PORT=1521)))

Services Summary...

Service "GUTHRIE" has 1 instance(s).

Instance "GUTHRIE", status UNKNOWN, has 1 handler(s) for this service...

Service "OKARCHE" has 1 instance(s).

Instance "OKARCHE", status UNKNOWN, has 1 handler(s) for this service...

Service "ORCL" has 2 instance(s).

Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "ORCLXDB" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[[email protected] admin]$Edited by: EdStevens on Feb 16, 2012 7:58 PM