首页 > 代码库 > Oracle 12C 创建用户连接pdb
Oracle 12C 创建用户连接pdb
测试环境:C:\ora12c\product\12.1.0\dbhome_1\BIN>sqlplus.exe /nologSQL*Plus: Release 12.1.0.1.0 Production on 星期二 9月 20 03:50:23 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.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) ))用创建用户连接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
Oracle 12C 创建用户连接pdb
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。