Home » RDBMS Server » Networking and Gateways » Listner Service gone missing (oracle 12c Windows 2012)
Listner Service gone missing [message #668871] Tue, 20 March 2018 05:37 Go to next message
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
Re: Listner Service gone missing [message #668874 is a reply to message #668871] Tue, 20 March 2018 07:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Be sure that ORACLE_HOME and PATH are correctly set.



Re: Listner Service gone missing [message #668875 is a reply to message #668874] Tue, 20 March 2018 07:30 Go to previous messageGo to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi Michel,

Thanks for the reply,

We have setup that properly, still facing problem.

Regards
M.Krish
Re: Listner Service gone missing [message #668876 is a reply to message #668871] Tue, 20 March 2018 07:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> (SERVICE_NAME = <sidname>)
above should be below instead
(SERVICE_NAME = <service_name>)
Re: Listner Service gone missing [message #668878 is a reply to message #668871] Tue, 20 March 2018 07:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
muthukrish104 wrote on Tue, 20 March 2018 03:37
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).
Why is a new listener service desired?

post results from OS commands below

lsnrctl status
lsnrctl service
Re: Listner Service gone missing [message #668984 is a reply to message #668878] Tue, 27 March 2018 07:24 Go to previous message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi All,

Thanks for the reply.

It was an unidentified error, even oracle support team couldn't find.
So we installed a new software for Listener.

Regards
M.krish
Previous Topic: setting of environment variables
Next Topic: Public or private database link.
Goto Forum:
  


Current Time: Thu Mar 28 07:41:27 CDT 2024