Oracle12c默认密码
用户名 | 密码 |
---|---|
sys | change_on_install |
system | manager |
创建表空间
cdb表空间
create tablespace yygl_data logging datafile 'D:\app\Oracle\admin\orcl\[tablespace].ora' size 1000M extent management local segment space management auto;
创建用户
create user c##username identified by password default tablespace yygl_data;
授权
给cdb表空间创建用户必须加前缀C##
grant connect,resource,dba to c##username;
GRANT all privileges to c##username;
imp导入
- 不需要退出登陆
$imp c##username/password@localhost/orcl file=D:\xxx.DMP full=y ignore=y;
- exit退出sqlplus登陆
imp c##username/password@localhost/orcl file=D:\xxx.DMP full=y ignore=y;
------------------
--pdb imp导入语句
------------------
imp username/password@localhost:1521/pdborcl file=D:\xxx.DMP full=y ignore=y;
sqlplus username/password@localhost:1521/pdborcl as sysdba
直接登陆pdborcl
pdb表空间的创建和cdb步骤一样
首先,切换到pdb容器,然后其他步骤和在cdb创建导入的步骤一样.
SQL> show pdbs//查看pdb容器,
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBORCL READ WRITE NO
SQL> alter session set container=pdborcl;//切换到pdborcl
会话已更改。
SQL> show con_name
CON_NAME
------------------------------
PDBORCL
SQL> alter session set container=CDB$ROOT;//切换回cdb容器
会话已更改。
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
pdb的启动与关闭
----------------------
--打开
----------------------
alter pluggable database open;
---------------------------------------------------------------
----------------------
--关闭
----------------------
alter pluggable database close;
Java连接oracle 12c失败解决措施
正常连接11g可以,连接12c失败问题解决方式。
首先登陆数据库服务器找到安装目录,
例如:D:\app\zyf\product\12.1.0\dbhome_1\NETWORK\ADMIN
找到sqlnet.ora文件,打开在最后添加 :
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
即可。