12c的网络设置

Post author:admin
Post published:2014年6月6日
Post category:IT
Post comments:0评论

12c开始，对于pdb一般都是需要tnsname登录了，在这里记录一下主要的3个网络文件配置。

listener.ora

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

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

   (SID_DESC =

   (GLOBAL_DBNAME = ora12c)

   (ORACLE_HOME = /u01/ora12c/app/oracle/product/12.1.0/db_1)

   (SID_NAME = ora12c)

   )

   (SID_DESC =

   (GLOBAL_DBNAME = pdb1)

   (ORACLE_HOME = /u01/ora12c/app/oracle/product/12.1.0/db_1)

   (SID_NAME = ora12c)

   )

)

LISTENER =

(DESCRIPTION =

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

)

ADR_BASE_LISTENER = /u01/ora12c/app/oracle

tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/ora12c/app/oracle/product/12.1.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORA12C =

(DESCRIPTION =

   (ADDRESS_LIST =

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

   )

   (CONNECT_DATA =

   (SERVICE_NAME = ora12c)

   )

)

PDB1 =

(DESCRIPTION =

   (ADDRESS_LIST =

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

   )

   (CONNECT_DATA =

   (SERVICE_NAME = pdb1)

   )

)

sqlnet.ora

# sqlnet.ora Network Configuration File: /u01/ora12c/app/oracle/product/12.1.0/db_1/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

ADR_BASE = /u01/ora12c/app/oracle