6 Replies Latest reply: May 20, 2013 4:15 AM by alz2real RSS

    listener control utility issue

    alz2real
      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
          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
            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.
              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
                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
                  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
                    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.