Two versions of oracle are installed on one host.

Source: Internet
Author: User

   Install BW and ERP on a server, while BW uses the oracle9 environment, while ERP uses the oracle10 environment. to install two versions of oracle, you need to make some minor changes, two services on the other side cannot be started at the same time. The procedure is as follows:

1. Changes in listener. ora 

In order that both ORACLE users (Limit 11 and limit 12) 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. oraOracle 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)                           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 limit 11 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 = 0CONNECT_TIMEOUT_LISTENER = 10TRACE_LEVEL_LISTENER = OFFSID_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 toIf C12 has Release 3.0/3.1:/etc/listener. oraIf C12 has Release 4.x or higher with Oracle 8.0.x:/oracle/C12/network/admin/listener. oraIf C12 has Release 4.x or higher with Oracle 8.1.x or higher:/oracle/C12/<ORACLE_VERSION >_< BIT>/network/admin/listener. ora                           Make sure that the file there belonges to the user created 12 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. oraOracle 8.1.x or higher:/oracle/C11/<ORACLE_VERSION >_< BIT>/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 limit 11 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 toIf C12 has Release 3.0/3.1:/usr/sap/trans/tnsnames. oraIf C12 has Release 4.x or higher with Oracle 8.0.x:/oracle/C12/network/admin/tnsnames. oraIf C12 has Release 4.x or higher with Oracle 8.1.x or higher:/oracle/C12/<ORACLE_VERSION >_< BIT>/network/admin/tnsnames. ora                           Make sure that the file there belongs to the user created 12 and has at least permissions 0644.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 valid tive.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.