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

I solved the problem.

When I installed Oracle 12c I specified a Windows account for the Oracle services to run under so I found a way to set environment variables for specifically for that account, overriding the values set at the system level:

1. In regedit expand HKEY_LOCAL_MACHINE\software\Microsoft\WindowsNT\CurrentVersion\ProfileList and find the SID for the Windows service account assigned to Oracle.
2. Expand HKEY_USERS\<the side you found in step 1>.
3. Select new and add a string value = ORACLE_HOME
4. Modify the ORACLE_HOME entry setting its value to the path to the 12c ORACLE_HOME.
5. Start the service.

HTH,
Peter

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter (ES & CSO) Sent: Thursday, October 27, 2016 9:48 AM To: Jure Bratina <jure.bratina_at_gmail.com>; elmaris_at_gmail.com Cc: oracle-l <oracle-l_at_freelists.org> Subject: RE: EXT :Re: TNS-01151: Missing listener name, listener12c, in LISTENER.ORA

I tried putting the LISTENER12C stuff in the listener.ora file in the other ORACLE_HOME but I still got the same error.

I have a ticket open with Oracle on this and their latest suggestion is for me to delete the ORACLE_HOME environment variables at the system level. (Remember this is Windows.) Since this is a production server I am waiting for a window when I can try this.

Thanks,
Peter

From: Jure Bratina [mailto:jure.bratina_at_gmail.com] Sent: Saturday, October 22, 2016 3:32 AM To: elmaris_at_gmail.com<mailto:elmaris_at_gmail.com> Cc: Schauss, Peter (ES & CSO) <peter.schauss_at_ngc.com<mailto:peter.schauss_at_ngc.com>>; oracle-l <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: EXT :Re: TNS-01151: Missing listener name, listener12c, in LISTENER.ORA

Hi,
> I am installing Oracle 12.1.0.2 in a second Oracle home Just a quick check - since you apparently have two Oracle homes, did you check that the listener is not reading the configuration from the listener.ora in the other home? Regards,
Jure Bratina

On Fri, Oct 21, 2016 at 10:03 PM, Maris Elsins <elmaris_at_gmail.com<mailto:elmaris_at_gmail.com>> wrote: 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