The listener supports no services
LISTENER.ORA
----------------------
otm =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
(ADDRESS = (PROTOCOL = TCP)(HOST = server.xxxx.com)(PORT = 1523))
)
)
SID_LIST_otm =
(SID_LIST =
(SID_DESC =
(SID_NAME = otm)
(GLOBAL_DBNAME=otm.xxxx.com)
(ORACLE_HOME = /otm/oracle/app/oracle/product/11.2.0)
)
)
ADR_BASE_LISTENER = /otm/oracle/app/oracle
TNSNAMES.ORA
------------
otm =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server.xxxx.com)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = otm.xxxx.com)
(GLOBAL_DBNAME=otm.xxxx.com)
(SID_NAME=otm)
)
)
Now restart listener successfully with services.........
No comments:
Post a Comment