linux添加实例监听,双实例监听设置

/u01/oracle/app/product/network/admin/

listener.ora 文件

============================================================

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /u01/oracle/app/product)

(PROGRAM = extproc)

)

-----------------------添加部分-----------------------

(SID_DESC =

(GLOBAL_DBNAME = ora10)

(ORACLE_HOME = /u01/oracle/app/product)

(SID_NAME = ora10)

)

(SID_DESC =

(GLOBAL_DBNAME = oratest)

(ORACLE_HOME = /u01/oracle/app/product)

(SID_NAME = oratest)

)

)

------------------------------------------------------

LISTENER =

(DESCRIPTION =

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

)

============================================================

tnsnames.ora 文件

===============================================================

ora10 =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ora10)

)

)

test =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = test)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

===============================================================

----初始文件

#########################################################################################

# listener.ora Network Configuration File: /u01/oracle/app/product/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /u01/oracle/app/product)

(PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

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

)

)

##########################################################################################

## tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

ORA10 =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ora10)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

##########################################################################################

-----oracle form. & reports 6i的 tnsnames.ora 监听文件配置

# C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\orant\net80\admin\tnsnames.ora

# Generated by Oracle Net8 Assistant

ORA10 =

(DESCRIPTION =

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

(CONNECT_DATA = (SID = ORA10))

)

--连接字符串的名字

--使用TCP协议

--服务器机器名和端口号

--数据库名ora10

#########################################################################################

# tnsnames.ora Network Configuration File: D:\OracleDeveloper\DevSuiteHome_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = PLSExtProc)

)

)

-----------------------------------------------------------------------------

ASM =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = +ASM)

)

)

-----------------------------------------------------------------------------