This discussion is archived
6 Replies Latest reply: May 20, 2013 2:15 AM by alz2real RSS

listener control utility issue

alz2real Newbie
Currently Being Moderated
Hello there. I'm running an Oracle Database 11g enterprise edition on a windows 7 64bit system. I also have, running on the same platform, Oracle Database 10g Express edition which handles my Oracle Primavera P6 database. The installation of the express edition was done after the enterprise edition. My problem is this; whenever I issue the command "*lsnrctl services*" or "*lsnrctl status*", I get a report on the services or status, as the case may be, for the listener belonging to the express database. How can I run the same command against the listener for my enterprise database?
Provided below are some more details:

Enterprise database ORACLE_HOME: C:\app\DELL\product\11.2.0\dbhome_1\
Express database ORACLE_HOME: C:\oraclexe\app\oracle\product\10.2.0\server\

Provided below are the commands I issued and the results:


C:\Windows\system32>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 18-MAY-2013 15:30
:09

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 16-MAY-2013 20:51:30
Uptime 1 days 18 hr. 38 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DELL-PC)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=
HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Windows\system32>lsnrctl services

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 18-MAY-2013 16:32
:05

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: DELL-PC, pid: 6164>
(ADDRESS=(PROTOCOL=tcp)(HOST=DELL-PC)(PORT=49450))
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:4 refused:0 state:ready
LOCAL SERVER
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:4 refused:0 state:ready
LOCAL SERVER
The command completed successfully

NOTE: XE is my Express database SID. My Enterprise database SID is SOLID . Also, when I log in through sqlplus from a command prompt, using "*sqlplus / as sysdba*" or "*sqlplus hr/passsword*" , I get logged into the express database. I tried using "sqlplus hr/password@solid" but got the following error : ORA-12154: TNS:could not resolve the connect identifier specified

Edited by: alz2real on May 18, 2013 9:30 AM
  • 1. Re: listener control utility issue
    EdStevens Guru
    Currently Being Moderated
    alz2real wrote:
    Hello there. I'm running an Oracle Database 11g enterprise edition on a windows 7 64bit system. I also have, running on the same platform, Oracle Database 10g Express edition which handles my Oracle Primavera P6 database. The installation of the express edition was done after the enterprise edition. My problem is this; whenever I issue the command "*lsnrctl services*" or "*lsnrctl status*", I get a report on the services or status, as the case may be, for the listener belonging to the express database. How can I run the same command against the listener for my enterprise database?
    You shouldn't need but one listener. One single listener, using the default name of LISTENER, running on the default port of 1521, is quite capable of -- indeed, WAS DESIGNED TO -- service multiple databases of multiple versions running from multiple ORALCE_HOMEs.

    Provided below are some more details:

    Enterprise database ORACLE_HOME: C:\app\DELL\product\11.2.0\dbhome_1\
    Express database ORACLE_HOME: C:\oraclexe\app\oracle\product\10.2.0\server\

    Provided below are the commands I issued and the results:


    C:\Windows\system32>lsnrctl status

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 18-MAY-2013 15:30
    :09

    Copyright (c) 1991, 2005, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
    ction
    Start Date 16-MAY-2013 20:51:30
    Uptime 1 days 18 hr. 38 min. 40 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Default Service XE
    Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
    dmin\listener.ora
    Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
    og\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DELL-PC)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=
    HTTP)(Session=RAW))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "XEXDB" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Service "XE_XPT" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    The command completed successfully

    C:\Windows\system32>lsnrctl services

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 18-MAY-2013 16:32
    :05

    Copyright (c) 1991, 2005, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "XEXDB" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1002 state:ready
    DISPATCHER <machine: DELL-PC, pid: 6164>
    (ADDRESS=(PROTOCOL=tcp)(HOST=DELL-PC)(PORT=49450))
    Service "XE_XPT" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:4 refused:0 state:ready
    LOCAL SERVER
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:4 refused:0 state:ready
    LOCAL SERVER
    The command completed successfully

    NOTE: XE is my Express database SID. My Enterprise database SID is SOLID . Also, when I log in through sqlplus from a command prompt, using "*sqlplus / as sysdba*" or "*sqlplus hr/passsword*" , I get logged into the express database. I tried using "sqlplus hr/password@solid" but got the following error : ORA-12154: TNS:could not resolve the connect identifier specified
    That's because 'solid' is not in the tnsnames. ora associate with your current ORACLE_HOME, which appears to be the one for XE.
    read: [url http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/] ora-12154tns-03505

    >
    Edited by: alz2real on May 18, 2013 9:30 AM
    Aside from all that, why are you asking about an issue about your oracle database on windows in a forum about linux?


    Edited by: EdStevens on May 18, 2013 12:32 PM

    Edited by: EdStevens on May 18, 2013 3:42 PM
  • 2. Re: listener control utility issue
    alz2real Newbie
    Currently Being Moderated
    Thanks for your ever prompt response Edstevens. The things is this; when I installed Oracle Primavera on my system, the Oracle database express edition installed along created it's own oracle_home with a separate listener, though the same default name of LISTENER, on the default port 1521. I think this somehow creates a minor conflict. I know there's definitely a way around this, I just can't figure it out. Provided below are the listener definitions of the two separate listeners running on my system. Maybe that could help.

    FOR MY EXPRESS DATABASE:

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = DELL-PC)(PORT = 1521))
    )
    )

    DEFAULT_SERVICE_LISTENER = (XE)


    FOR MY ENTERPRISE DATABASE:

    # listener.ora Network Configuration File: C:\app\DELL\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER2 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DELL-PC)(PORT = 1522))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\app\DELL\product\11.2.0\dbhome_1)
    (PROGRAM = extproc)
    (ENVS = "EXTPROC_DLLS=ONLY:C:\app\DELL\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    )

    SID_LIST_LISTENER2 =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = solid.snake)
    (ORACLE_HOME = C:\app\DELL\product\11.2.0\dbhome_1)
    (SID_NAME = solid)
    )
    )

    ADR_BASE_LISTENER2 = C:\app\DELL\product\11.2.0\dbhome_1\log

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )

    ADR_BASE_LISTENER = C:\app\DELL
  • 3. Re: listener control utility issue
    Paul M. Oracle ACE
    Currently Being Moderated
    I know there's definitely a way around this, I just can't figure it out.
    Did you try just stopping XE listener ?
    whenever I issue the command "lsnrctl services" or "lsnrctl status", I get a report on the services or status, as the case may be, for the listener belonging to the express database. How can I run the same command against the listener for my enterprise database?
    Set the correct environment for enterprise database (ORACLE_HOME, PATH,). Also set ORACLE_SID if you want to access the database locally. For example :
    C:\>set ORACLE_HOME=C:\app\DELL\product\11.2.0\dbhome_1
    C:\>set PATH=%ORACLE_HOME%\bin;%PATH%
    C:\>set ORACLE_SID=SOLID
  • 4. Re: listener control utility issue
    rukbat Guru Moderator
    Currently Being Moderated
    Mod: +...thread moved from the Generic Linux forum to the Database General Questions forum...+
    +... where you should have placed it to start with...+
  • 5. Re: listener control utility issue
    EdStevens Guru
    Currently Being Moderated
    alz2real wrote:
    Thanks for your ever prompt response Edstevens. The things is this; when I installed Oracle Primavera on my system, the Oracle database express edition installed along created it's own oracle_home with a separate listener, though the same default name of LISTENER, on the default port 1521. I think this somehow creates a minor conflict. I know there's definitely a way around this, I just can't figure it out. Provided below are the listener definitions of the two separate listeners running on my system. Maybe that could help.

    FOR MY EXPRESS DATABASE:

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = DELL-PC)(PORT = 1521))
    )
    )

    DEFAULT_SERVICE_LISTENER = (XE)


    FOR MY ENTERPRISE DATABASE:

    # listener.ora Network Configuration File: C:\app\DELL\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER2 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DELL-PC)(PORT = 1522))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\app\DELL\product\11.2.0\dbhome_1)
    (PROGRAM = extproc)
    (ENVS = "EXTPROC_DLLS=ONLY:C:\app\DELL\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    )

    SID_LIST_LISTENER2 =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = solid.snake)
    (ORACLE_HOME = C:\app\DELL\product\11.2.0\dbhome_1)
    (SID_NAME = solid)
    )
    )

    ADR_BASE_LISTENER2 = C:\app\DELL\product\11.2.0\dbhome_1\log

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )

    ADR_BASE_LISTENER = C:\app\DELL
    Two listeners on the same port is more than a "minor conflict". I see you have two listeners defined in your listener.ora file for the EE installation. Show us the result of
    lsnrctl status
    lsnrctl status LISTENER2
    Edited by: EdStevens on May 19, 2013 6:32 AM
  • 6. Re: listener control utility issue
    alz2real Newbie
    Currently Being Moderated
    Thanks Edsteven. I resolved the issue over the weekend. I had to slightly edit my PATH variable. The Express edition ORACLE_HOME\BIN directory appeared before the Enterprise edition ORACLE_HOME\BIN directory. I only had to interchange this. About having two listeners running on the same port, I'll definitely look into that. Thanks for you professional advice and support. It's always very much appreciated.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points