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

From: Jure Bratina <jure.bratina_at_gmail.com>
Date: Sat, 22 Oct 2016 09:32:17 +0200
Message-ID: <CAC08BHJ_mmwZgDhO_ONEFDfDmn5UO0nWZy-Kusf=MZLMY=9QQw_at_mail.gmail.com>



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> 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\ora
> clr12.dll")
> )
> )
>
>
> ---
> Maris Elsins
> _at_MarisElsins <https://twitter.com/MarisElsins>
> www.facebook.com/maris.elsins
>
>
>
> On Fri, Oct 21, 2016 at 9:30 PM, Schauss, Peter (ES & CSO) <
> 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_ho
>> me1\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\p
>> roduct\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
Received on Sat Oct 22 2016 - 09:32:17 CEST

Original text of this message