RE: EXT :Re: TNS-01151: Missing listener name, listener12c, in LISTENER.ORA

Tried that – no luck.

From: Maris Elsins [mailto:elmaris_at_gmail.com] Sent: Friday, October 21, 2016 4:03 PM
To: Schauss, Peter (ES & CSO) <peter.schauss_at_ngc.com> Cc: oracle-l <oracle-l_at_freelists.org> Subject: EXT :Re: TNS-01151: Missing listener name, listener12c, in LISTENER.ORA

Hey,

Just a crazy guess, but can you swap places for SID_LIST_LISTENER12C and LISTENER12C like this:

LISTENER12C =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
    )
  )

SID_LIST_LISTENER12C =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\Oracle\product\12.1.0\db_home1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\Oracle\product\12.1.0\db_home1\bin\oraclr12.dll")
    )
  )

---
Maris Elsins
_at_MarisElsins<https://twitter.com/MarisElsins> www.facebook.com/maris.elsins<https://www.facebook.com/maris.elsins>

On Fri, Oct 21, 2016 at 9:30 PM, Schauss, Peter (ES & CSO) <peter.schauss_at_ngc.com<mailto:peter.schauss_at_ngc.com>> wrote: I am installing Oracle 12.1.0.2 in a second Oracle home on a Windows 2008 R2 (standard) server and trying to start a non-default listener (listener12c) on port 1522. When I try to start the listener from the Windows services screen I get the above error in the listener12c.log.

My listener.ora file is located in %ORACLE_HOME%\network\admin and is shown below with site specific portions redacted. The alternate name of the listener is clearly specified.

Any suggestions?

Thanks,
Peter Schauss

# listener.ora Network Configuration File: E:\Oracle\product\12.1.0\db_home1\network\admin\listener.ora # Generated by Oracle configuration tools.

SID_LIST_LISTENER12C =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\Oracle\product\12.1.0\db_home1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\Oracle\product\12.1.0\db_home1\bin\oraclr12.dll")
    )
  )

LISTENER12C =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
    )
  )
--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l