12c的网络设置

  • Post author:
  • 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

发表评论