当前位置：首页 -> AI编程基础 -> 数据库编程

两个版本的oracle，装在一台主机上(一)

2014-11-23 21:38:45 · 作者: · 浏览: 19
标签: 两个 版本 oracle 台主 机上
将BW 与 ERP装在一台server上，BW运用oracle9环境，而ERP运用oracle10环境，需要安装2个版本的oracle，则需要做一些小改动，否侧2个服务不能同时启动的。具体步骤如下： 
 
 
 
  

   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: