博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
Oracle 12C 创建用户连接pdb
阅读量:6140 次
发布时间:2019-06-21

本文共 1821 字,大约阅读时间需要 6 分钟。

测试环境: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

 

转载地址:http://fbuya.baihongyu.com/

你可能感兴趣的文章
c#如何将子窗体显示到父窗体的容器(panel)控件中
查看>>
linux运维之docker交付篇
查看>>
find命令
查看>>
自己写的Dijkstra模板
查看>>
socket 网络连接基础
查看>>
stm32下载程序,拔了调试器不能运行程序解决方案
查看>>
python enumerate内置函数
查看>>
快速理解_.debounce方法
查看>>
HTML基础
查看>>
jvm参数调优
查看>>
IOS之网络数据下载和JSON解析
查看>>
Centos 7 yum安装配置SVN 1.97
查看>>
把mongodb服务添加到系统服务中,报错:[sc] openscmanager 失败 5
查看>>
JS中undefined与null的区别,附带产生undefined的历史
查看>>
求斐波那契数的python语言实现---递归和迭代
查看>>
[Ubuntu]Eclipse代码自动补全的颜色修改
查看>>
Eclipse+ADT+Android SDK 搭建安卓开发环境
查看>>
poj1743 Musical Theme
查看>>
常用的key和oid
查看>>
数据库优化
查看>>