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

################
# 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)
    )
  )

################
# 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)
    )
  )