Oracle 12C 创建用户连接pdb
来源:互联网 发布:gps航迹编辑软件 编辑:程序博客网 时间:2024/06/05 07:08
SQL> conn /as sysdba已连接。SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 POLESTAR1 READ WRITE NO 4 POLESTAR2 READ WRITE NOSQL>SQL> alter session set container=polestar1;会话已更改。SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 3 POLESTAR1 READ WRITE NOSQL> SQL> create user polestar identified by polestar;User created.SQL> grant dba to polestar;配置监听listener文件:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1523)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523)) ) )SID_LIST_LISTENER=(SID_LIST= (SID_DESC = (GLOBAL_DBNAME = orcl12c) #CDB信息 (SID_NAME = orcl12c) ) (SID_DESC = (GLOBAL_DBNAME = polestar1) #PDB信息 (SID_NAME = orcl12c) ))
重启监听:
lsnrctl reload
用创建用户连接pdb数据库C:\ora12c\product\12.1.0\dbhome_1\BIN>sqlplus polestar/polestar@192.168.0.100:1523/POLESTAR1SQL*Plus: Release 12.1.0.1.0 Production on 星期二 9月 20 02:48:14 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.连接到:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 3 POLESTAR1 READ WRITE NOSQL> exit
JDBC连接:
String url = "jdbc:oracle:thin:@//localhost:1521/pdborcl";来源:http://www.cnblogs.com/polestar/p/5892410.html
0 0
- Oracle 12C 创建用户连接pdb
- oracle 12c创建pdb用户
- oracle 12c 创建PDB用户即Local User
- Oracle Database 12c cdb/pdb用户的创建
- Oracle 12c创建用户和切换CDB、PDB
- Oracle 12c创建pdb
- oracle 12c pdb用户登录
- Oracle 12c 基于PDB种子数据库创建PDB
- Oracle 12C -- 使用seed PDB创建新的pdb
- hibernate连接oracle 12c pdb
- oracle 12c连接cdb&pdb
- oracle 12c 创建 pdb user
- 关于Oracle 12C pdb用户无法登录的问题
- Oracle 12c中PDB、CDB、用户之间的关系
- Oracle 12c 如何连接到 CDB 和 PDB
- 远程连接ORACLE 12C中可插拔数据库PDB
- Oracle 12c 多租户 手工创建 pdb 与 手工删除 pdb
- oracle 12c卸载pdb
- spring <context:property-placeholder/> 配置详解
- 用Xshell部署javaweb项目
- Delphi启动/停止Windows服务,启动类型修改为"自动"
- Ionic2系列——Ionic 2 Guide 官方文档中文版
- SiteMesh简介
- Oracle 12C 创建用户连接pdb
- 字符串全排列算法
- 大数据量下MySQL插入方法的性能比较
- java内部类详解
- 表索引的操作
- SiteMesh
- ionic2+angular2中踩的那些坑
- java调c
- Set和List的区别