Static Service registration for Listener [message #306557] |
Fri, 14 March 2008 12:29  |
OraKaran
Messages: 183 Registered: March 2008 Location: United Kingdom
|
Senior Member |
|
|
Hi,
In which case we need to do Static Service registration for Listener?
I assume initially the Listener file looks like following
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/rdb01)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db01_host.hsa.co.uk)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
Which after Static Service Registration looks like
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/rdb01)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = DB01)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/rdb01)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db01_host.hsa.co.uk)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
Please Suggest
Thanks and Regards,
OraKaran
|
|
|
|
|
|
Re: Static Service registration for Listener [message #308169 is a reply to message #307976] |
Fri, 21 March 2008 13:12  |
 |
ebrian
Messages: 2794 Registered: April 2006
|
Senior Member |
|
|
You'll still be able to connect thru OEM without a static entry. However, without a static entry in the listener, you'll still receive errors with OEM when the database isn't at least mounted.
Listener refused the connection with the following error: ORA-12514
You can still start the listener and database using OEM without the static entry.
|
|
|