问题描述

oracle12c 怎么直接连接到PDB数据库？

创建PDB数据库后无法使用PDB数据库的管理员账号直接连接至PDB数据库
SQLPLUS提示如下：

SQL> conn accp1sys/accpManage@ACCP1
ERROR:
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

已确定该PDB数据库ACCP1以及账号存在

listener.ora以及tnsmanes.ora配置如下：
tnsnames:

# tnsnames.ora Network Configuration File: D:OracleDBappGintokiOrcproduct12.1.0dbhome_2
etworkadmin	nsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
        (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
        (CONNECT_DATA =
            (SID = CLRExtProc)
            (PRESENTATION = RO)
        )
    )

ORCL =
    (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = orcl)
        )
    )

ACCP1 =
    (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = accp)
        )
    )

listener：

# listener.ora Network Configuration File: D:OracleDBappGintokiOrcproduct12.1.0dbhome_2
etworkadminlistener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
    (SID_LIST =
        (SID_DESC =
            (SID_NAME = CLRExtProc)
            (ORACLE_HOME = D:OracleDBappGintokiOrcproduct12.1.0dbhome_2)
            (PROGRAM = extproc)
            (ENVS = "EXTPROC_DLLS=ONLY:D:OracleDBappGintokiOrcproduct12.1.0dbhome_2inoraclr12.dll")
        )
        (SID_DESC =
            (SID_NAME = orcl)
            (GLOBAL_DBNAME = ORCL)
        )
        (SID_DESC =
            (SID_NAME = accp1)
            (GLOBAL_DBNAME = ACCP1)
        )
    )

LISTENER =
    (DESCRIPTION_LIST =
        (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
    )

经过多方搜索，始终无法连接上，希望各位高手帮忙解决一下，感激不尽

解决方案

Oracle 12c 如何连接到 CDB 和 PDB
远程连接ORACLE 12C中可插拔数据库PDB
Oracle12c中配置实例参数和修改容器数据库（CDB）及可插拔数据库（PDB）

解决方案二：

你看看你的服务开了么