两个版本的oracle,装在一台主机上
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:
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/<ORACLE_VERSION>_<BIT>/network/admin/listener.ora (<ORACLE_VERSION is the 3-digit version and '64' for a 64-bit database, e.g. /oracle/C11/920_64/network/admin/listener.ora for 64-bit Oracle 9.2.0)
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/<ORACLE_VERSION>_<BIT>/network/admin/listener.ora
2. Changes in tnsnames.ora
Edit the following file as shown below:
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/<ORACLE_VERSION>_<BIT>/network/admin/tnsnames.ora
################ # 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) ) )
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: /oracle/C12/network/admin/tnsnames.ora
If C12 has Release 4.x or higher with Oracle 8.1.x or higher: /oracle/C12/<ORACLE_VERSION>_<BIT>/network/admin/tnsnames.ora
3. Changes in sqlnet.ora
No changes are necessary in sqlnet.ora.
4. Restart the Listener
After editing the files, restart the listener to make the changes effective.
No changes are necessary in sqlnet.ora.
4. Restart the Listener
After editing the files, restart the listener to make the changes effective.