首页 / ORACLE / oracle 12c连接pdb
oracle 12c连接pdb
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了oracle 12c连接pdb,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4437字,纯文字阅读大概需要7分钟。
内容图文
![oracle 12c连接pdb](/upload/InfoBanner/zyjiaocheng/482/10ba8a0a5b6c4d3faec893e4a4d1e78e.jpg)
这里修改tnsname.ora这个文件,添加一个pdb的记录,就可以连接pdb:
[oracle@ora12c admin]$ vi tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_DB12G = (ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521)) DB12G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = db12g) ) ) pdb01 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb01) ) )
使用该service进行连接:
[oracle@ora12c admin]$ sqlplus scott/tiger@pdb01 SQL*Plus: Release 12.2.0.1.0 Production on Fri May 12 15:47:26 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> show con_name CON_NAME ------------------------------ PDB01
2. 使用srvctl命令在群集中添加服务连接pdb(这种方式应用于RAC环境):
创建service,其中cdb名称为cpdb,pdb名称为pdb01,service为das,首选节点实例名称为cpdb1,次选节点实例名称为cpdb2:
[oracle@node1 bin]$ srvctl add service -d cpdb -s das -pdb pdb01 -preferred cpdb1 -available cpdb2
查看创建的service:
[oracle@node1 bin]$ srvctl config service –d <databasename> -s <servicename>
同样添加tnsname.ora记录:
das = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = scan-ip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = das) ) )
启动service:
[oracle@nsnode1 bin]$ srvctl start service -d cpdb -service das
测试连接:
SQL> connect sys/oracle@das AS SYSDBA Connected. SQL> SHOW CON_ID; CON_ID 3 SQL> SHOW CON_NAME; CON_NAME PDB01
3. 使用命令进行切换:
[oracle@node1 bin]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Wed May 12 14:56:27 2017 Copyright (c) 1982, 2017, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options SQL> show con_name; CON_NAME CDB$ROOT SQL> ALTER SESSION SET CONTAINER = PDB01; Session altered. SQL> SHOW CON_NAME; CON_NAME PDB01
4.使用Enterprise Manager Express进行连接:
在使用之前检查是否为EM配置了端口,需要为EM配置端口:
SQL> select dbms_xdb_config.gethttpsport from dual; GETHTTPSPORT ------------ 0 SQL> exec dbms_xdb_config.sethttpsport(5500); PL/SQL procedure successfully completed. SQL> select dbms_xdb_config.gethttpsport from dual; GETHTTPSPORT ------------ 5500
切换到pdb,为pdb配置EM端口:
SQL> alter session set container = pdb01; Session altered. SQL> select dbms_xdb_config.gethttpport from dual; GETHTTPPORT 5051
然后使用EM和配置的端口连接pdb。
oracle 12c连接pdb
标签:err lap 自动 server nmp ptime copyright version ons
本文系统来源:http://www.cnblogs.com/zx3212/p/6846363.html
内容总结
以上是互联网集市为您收集整理的oracle 12c连接pdb全部内容,希望文章能够帮你解决oracle 12c连接pdb所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。