Oracle Database 12c Release 1 Installation On Oracle Linux 6.4 x86_64(五)
on
Create Database
[oracle@vmdb12c admin]$ sqlplus system/oracle@192.168.1.14:1527/zwc
SQL*Plus: Release 12.1.0.1.0 Production on Sun Sep 1 14:59:14 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Last Successful login time: Sun Sep 01 2013 14:58:52 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ZHONGWC1 READ WRITE NO
4 ZHONGWC2 READ WRITE NO
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@vmdb12c admin]$ sqlplus system/oracle@192.168.1.14:1527/zhongwc1
SQL*Plus: Release 12.1.0.1.0 Production on Sun Sep 1 14:59:20 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Last Successful login time: Sun Sep 01 2013 14:58:58 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 ZHONGWC1 READ WRITE NO
SQL> alter session set container=zhongwc2;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
4 ZHONGWC2 READ WRITE NO
SQL> create user zwc identified by zwcpwd;
User created.
SQL> grant dba to zwc;
Grant succeeded.
SQL> conn zwc/zwcpwd@192.168.1.14:1527/zhongwc1
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> conn zwc/zwcpwd@192.168.1.14:1527/zhongwc2
Connected.
SQL>
C:\>sqlplus zwc/zwcpwd@192.168.1.14:1527/zhongwc2
SQL*Plus: Release 11.2.0.3.0 Production on 星期日 9月 1 15:03:48 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
连接到:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show user
USER 为 "ZWC"
SQL>