记一次,oracle pdb数据库配置

listener.ora 配置

#   address value as shown below.
DIRECT_HANDOFF_TTC_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = bi)
      (ORACLE_HOME = D:\oracle\product\12.2.0\dbhome_1)
      (SID_NAME = bi)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = D:\oracle\product\12.2.0\dbhome_1)
      (SID_NAME = orcl)
    )

## 这里是pdb数据库的配置

## 参数说明

##BIPDB :PDB数据库的实例名

##BI:CDB数据库的实例名
   (SID_DESC =
      (GLOBAL_DBNAME = BIPDB)
      (SID_NAME = BI)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )

ADR_BASE_LISTENER = D:\oracle\product\12.2.0\dbhome_1

 

tnsnames.ora 配置

# tnsnames.ora Network Configuration File: \oracle\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

BI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bi)
    )
  )

BIPDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = BIPDB)
    )
  )