1. Changes in listener.ora
In order that both ORACLE users (orac11 and orac12) can start the listener process, the two databases must be entered in both listener.ora files. Edit the following file as shown below:
Oracle 8.0.x: /oracle/C11/network/admin/listener.ora
Oracle 8.1.x or higher: /oracle/C11/_/network/admin/listener.ora (
Replace these placeholders with the actual values: C11, C12, DBHOSTNAME, ORACLE_HOME_C11, ORACLE_HOME_C12.
Ensure that lines which begin with a keyword and not a bracket do not contain any leading blank characters.
Make sure that the file belongs to the user orac11 and has at least permissions 0644.
################
# Filename......: listener.ora for more than one database
# Created.......: created by SAP AG, R/3 Rel. >= 4.0A
# Name..........:
# Date..........:
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= C11.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= C11)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= C12.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= C12)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = DBHOSTNAME)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = C11)
(ORACLE_HOME = ORACLE_HOME_C11)
(PRESPAWN_MAX = 10)
)
(SID_DESC =
(SDU = 32768)
(SID_NAME = C12)
(ORACLE_HOME = ORACLE_HOME_C12)
(PRESPAWN_MAX = 10)
)
)
Copy this file to
If C12 has Release 3.0/3.1: /etc/listener.ora
If C12 has Release 4.x or higher with Oracle 8.0.x: /oracle/C12/network/admin/listener.ora
If C12 has Release 4.x or higher with Oracle 8.1.x or higher: /oracle/C12/_/network/admin/listener.ora
Make sure that the file there belonges to the user orac12 and has at least permissions 0644.
2. Changes in tnsnames.ora
Edit the following file as shown below:
Oracle 8.0.x: /oracle/C11/network/admin/tnsnames.ora
Oracle 8.1.x or higher: /oracle/C11/_/network/admin/tnsnames.ora
Replace the placeholders with the actual values: C11, C12, DBHOSTNAME.
Ensure that lines which begin with a keyword and not a bracket do not contain any leading blank characters.
Make sure that the file belongs to the user orac11 and has at least permissions 0644.
################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........:
################
C11.world =
(DESCRIPTION =
(SDU = 4096)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(HOST = DBHOSTNAME)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = C11)
(GLOBAL_NAME = C11.world)
)
)
C12.world =
(DESCRIPTION =
(SDU = 4096)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(HOST = DBHOSTNAME)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = C12)
(GLOBAL_NAME = C12.world)
)
)
Copy the file to
If C12 has Release 3.0/3.1: /usr/sap/trans/tnsnames.ora
If C12 has Release 4.x or higher with Oracle 8.0.x: