oracle tns 代理配置_oracle 11g tns和监听配置

11g的监听配置

[oracle@node3 admin]$ more listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

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

)

)

ADR_BASE_LISTENER = /u01/app/oracle

11g的tns配置

[oracle@node3 admin]$ more tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

PROD =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = prod)

)

)

test=

(DESCRIPTION=

(ADDRESS= (PROTOCOL=tcp)(HOST=192.168.10.101)(PORT=1521))

(CONNECT_DATA=

(SERVICE_NAME=test)

(SERVER=dedicated)

)

)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29108064/viewspace-777371/，如需转载，请注明出处，否则将追究法律责任。