Listner Service gone missing [message #668871] |
Tue, 20 March 2018 05:37 |
|
muthukrish104
Messages: 82 Registered: November 2017
|
Member |
|
|
Hi,
From yesterday, we are facing a typical problem of Listener service missing in the service.msc
When we are trying to create a new listener service, it is failed (Screenshot attached).
I have given the Tnsname.ora, Listener.ora and sqlnet.ora.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <ip address>)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = <sid name>)
(ORACLE_HOME = C:\Oracle\ORA12C\....\HOME\product\12.1.0\dbhome_1)
)
)
SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
DIAG_ADR_ENABLED = OFF
# tnsnames.ora Network Configuration File: C:\Oracle\ORA12C\12CTEST\HOME\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
<alias> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <ip>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <sidname>)
)
)
dg4odbc =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST= 10.80.41.84)(PORT=1521))
(CONNECT_DATA=(SID=dg4odbc))
(HS=OK)
)
Thanks and regards
Binoj
|
|
|
|
|
|
|
|