cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding Installation of 2 database instance on the same host

Former Member
0 Kudos

I Have Installed Two Instances on the same host one is solution Manager and another is ECC 6.0 EHP5

After the Installation Finished successfully of ECC 6.0 EHP5 and the Instance start the Previous Instance of solution manager Doesn’t  Start Shows Error No database connectivity no Listener .

I have Installed Solution Manager Instance on Oracle 11.2 and ECC 6.0 EHP5 Instance on Oracle 10.2

How can I Adjust The Listener and Tnsnames.ora to start both the instance properly  on OS Windows 2008.

  1. Listener.ora

# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_2\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_2)

(PROGRAM = extproc)

(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_2\bin\oraclr11.dll")

    )

(SID_DESC =

(SID_NAME = STL)

(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_2)

    )

  )

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    )

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = STL.WORLD)

      )

    )

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = STL)

      )

    )

(DESCRIPTION =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = ITCOL)

(PORT = 1521)

      )

    )

  )

ADR_BASE_LISTENER = D://oracle/STL/saptrace

ADMIN_RESTRICTIONS_LISTENER = on

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

  1. Listener.ora for other instance

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_5\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = D:\oracle\product\10.2.0\db_5)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (SID_NAME = DEV)

      (ORACLE_HOME = D:\oracle\product\10.2.0\db_5)

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))

      (ADDRESS = (PROTOCOL = TCP)(HOST = ITCOL)(PORT = 1523))

    )

    (DESCRIPTION =

      (ADDRESS =

        (PROTOCOL = IPC)

        (KEY = DEV.WORLD)

      )

    )

    (DESCRIPTION =

      (ADDRESS =

        (PROTOCOL = IPC)

        (KEY = DEV)

      )

    )

    (DESCRIPTION =

      (ADDRESS =

        (COMMUNITY = SAP.WORLD)

        (PROTOCOL = TCP)

        (HOST = ITCOL)

        (PORT = 1527)

      )

    )

  )

ADMIN_RESTRICTIONS_LISTENER = on

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

SAP Note 153835 posted by Vishal Basis contains the steps to setup multiple Oracle listener in the same OS.

None of the SAP installation will automatically setup up the listener.ora correctly when you install 2 Oracle listener into it. SAP always assume there is only 1 Oracle database installation with 1 listener.

There are some options beside the steps indicated in the note

1. Use Oracle 11.2.0's listener only to handle both database TNS configuration. NetWeaver does not shutdown Oracle listener anyway, so will simplify administration of Oracle listener. Don't use Oracle 10g listener at all, and only maintain 1 listener.ora file. The negative is that when shutdown the listener, both SAP ECC6 and Solution Manager will not able to connect. This is very rare for SAP

2. Continue to setup both as you do with 2 listener. Then follow the note. I recommend to set the listener name (default value is LISTENER) to LISTENER_10_2 and LISTENER_11_2 with different community name

The section that is wrong are

1. LISTENER name conflict. Configure line "LISTENER =" to a unique name like "LISTENER_10_2 ="

2. SID_LIST_LISTENER name conflict. Configure line "SID_LIST_LISTENER =" to a unique name matching the listener name, like "SID_LIST_LISTENER_10_2 ="

3. Community name conflict. Make "COMMUNITY =" to have unique value

4. In Oracle 10g's listener, port 1527 should change to 1523 to match the listener port value

Former Member
0 Kudos

Please go through

Note 153835 - Starting Multiple tnslsnr on same server

It might help your cause..

Regards,

Vishal

Former Member
0 Kudos

Hi,

from my point of view it should be fine if you ensure that tnsnames.ora contains for STL port 1523 and for DEV port 1521.

In UNIX there are several commands to check listener state, e.g. "tnsping <SID>" (on client side) or "lsnrctl status" (on server side). Maybe there is something similar in Windows too?

BTW Your post may suit better into SAP on Oracle space.

Regards,

Peter