oracle两数据库怎么配置监听,Linux下Oracle安装两个实例一个监听的配置

Linux下Oracle安装两个实例一个监听的配置：

listener.ora文件，

# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /opt/oracle/product/9.2)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = ora9)

(ORACLE_HOME = /opt/oracle/product/9.2)

(SID_NAME = ora9)

)

(SID_DESC =

(GLOBAL_DBNAME = B3)

(ORACLE_HOME = /opt/oracle/product/9.2)

(SID_NAME = B3)

)

)

tnsnames.ora文件，

# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ora9 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = ora9)

)

)

B3 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = B3)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

  )