Oracle 数据库listener.ora模板

Oracle数据库10g

 

cat listener.ora

 

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

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

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/oracle/OraHome_1)

(PROGRAM = extproc)

)

(SID_DESC =

(ORACLE_HOME = /home/oracle/OraHome_1)

(SID_NAME = test)

)

)

 

Oracle数据库11g

 

cat listener.ora

# listener.ora Network Configuration File: /home/daizy/OraHome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.170)(PORT = 1522))

(ADDRESS = (PROTOCOL = IPC)(KEY = dzy))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/daizy/OraHome_1)

(PROGRAM = extproc)

)

(SID_DESC =

(ORACLE_HOME = /home/daizy/OraHome_1)

(SID_NAME = dzy)

)

)