Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 952
  • Last Modified:

listener configuration

I have two instances running on the same server. One instance is 10gR2 and one instance is 11G. I cannot get the listener.ora file to work properly to allow the listener to work for both.

Host: mcmichaelb-d630
Instances:
- WM10GR2
- WM11G

See code snippet.

Questions:
Can one listener work for two instances?
What is the format for the listener.ora file?
TNSNAMES
------------------------
TNSNAMES.ORA
WM11G.MCMICHAELB-D630 = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = 
        (PROTOCOL = TCP)
        (HOST = mcmichaelb-d630)
        (PORT = 1521)
      )
    )
    (CONNECT_DATA = 
      (SERVICE_NAME = WM11G)
      (SRVR = dedicated)
    )
  )
  
WM10GR2.MCMICHAELB-D630 = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = 
        (PROTOCOL = TCP)
        (HOST = mcmichaelb-d630)
        (PORT = 1521)
      )
    )
    (CONNECT_DATA = 
      (SERVICE_NAME = WM10GR2)
      (SRVR = dedicated)
    )
  )
 
 
------------------------
LISTENER.ORA
------------------------
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mcmichaelb-d630.AME.ad.sag)(PORT = 1521)(QUEUESIZE=8))
)
 
LISTENER_11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mcmichaelb-d630.AME.ad.sag)(PORT = 1522)(QUEUESIZE=8))
)
 
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mcmichaelb-d630.AME.ad.sag)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = WM10GR2)
)
)
SID_LIST_LISTENER_11G =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mcmichaelb-d630.AME.ad.sag)
(ORACLE_HOME = C:\oracle\product\11.1.0\db_1)
(SID_NAME = WM11G)
)
)
------------------------

Open in new window

0
mbevilacqua
Asked:
mbevilacqua
  • 2
1 Solution
 
Ritesh_GargCommented:
I don't think you can have a common listener file.  The listener service executable LSNRCTL are different versions for these database, and when you would try to start the service, LSNRCTL would try to start both for 10g and 11g.
Any specific reason why you are trying to keep a common listener.ora file?
0
 
Mark GeerlingsDatabase AdministratorCommented:
Your listener.ora file should have only one of each of the following sections:
LISTENER =
SID_LIST_LISTENER =
(SID_LIST =

with multiple
(SID_DESC =
sections in the one (SID_LIST = ...) section

Here is an example (from an Oracle9 server where one of the "databases" was a non-Oracle ODBC-based data source, but the same syntax rules apply):

# LISTENER.ORA Network Configuration File: H:\ora_920\network\admin\listener.ora
# Generated by Oracle configuration tools.
 
LOG_DIRECTORY_LISTENER = G:\Trace\system
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = zs51-oradb1)(PORT = 1521))
      )
    )
  )
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = H:\ora_920)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CONX)
      (ORACLE_HOME = H:\Ora_920)
      (PROGRAM = hsodbc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = PROD.GENTEX.COM)
      (ORACLE_HOME = H:\ora_920)
      (SID_NAME = PROD)
    )
  )

Open in new window

0
 
Mark GeerlingsDatabase AdministratorCommented:
Sure, the listener executables are different in each Oracle version, but the higher version listener can support an Oracle database of at least one version earlier.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now