RE: EXT :Re: TNS-01151: Missing listener name, listener12c, in LISTENER.ORA
- From: "Schauss, Peter (ES & CSO)" <peter.schauss@xxxxxxx>
- To: Jure Bratina <jure.bratina@xxxxxxxxx>, "elmaris@xxxxxxxxx" <elmaris@xxxxxxxxx>
- Date: Thu, 27 Oct 2016 13:47:31 +0000
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@xxxxxxxxx]
Sent: Saturday, October 22, 2016 3:32 AM
To: elmaris@xxxxxxxxx
Cc: Schauss, Peter (ES & CSO) <peter.schauss@xxxxxxx>; oracle-l
<oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx<
mailto:elmaris@xxxxxxxxx>> 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
@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@xxxxxxx<
mailto:peter.schauss@xxxxxxx>> 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))
)
)
--
//www.freelists.org/webpage/oracle-l
Other related posts: