Gintoki_T 2016-05-25 16:57 采纳率: 0%
浏览 5795
已结题

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:\OracleDB\app\GintokiOrc\product\12.1.0\dbhome_2\network\admin\tnsnames.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:\OracleDB\app\GintokiOrc\product\12.1.0\dbhome_2\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
    (SID_LIST =
        (SID_DESC =
            (SID_NAME = CLRExtProc)
            (ORACLE_HOME = D:\OracleDB\app\GintokiOrc\product\12.1.0\dbhome_2)
            (PROGRAM = extproc)
            (ENVS = "EXTPROC_DLLS=ONLY:D:\OracleDB\app\GintokiOrc\product\12.1.0\dbhome_2\bin\oraclr12.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))
        )
    )

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

  • 写回答

1条回答

  • herozhangbz 2016-05-26 02:36
    关注

    你看看你的服务开了么

    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB怎么通过柱坐标变换画开口是圆形的旋转抛物面?
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥30 用arduino开发esp32控制ps2手柄一直报错
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题