TWO_TASK类似ORACLE_SID,该值只能为pdb库的值,不能为cdb库的值
以下是测试,当TWO_TASK值设为cdb值之后,
-
[oracle@test ~]$ export TWO_TASK=cdb
-
[oracle@test ~]$ sqlplus system/oracle
-
-
SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 9 04:04:30 2015
-
-
Copyright (c) 1982, 2014, Oracle. All rights reserved.
-
-
-
Killed
-
该连接会话是一直hang状态 使用Ctrl+c状态也无法终止,必须使用kill命令才能结束
查看当前数据库环境,有3个pdb库,实例名分别为 pdb1和pdb2和pdb$seed种子库
-
[oracle@test ~]$ export ORACLE_SID=cdb
-
[oracle@test ~]$ sqlplus / as sysdba
-
-
SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 9 04:08:23 2015
-
-
Copyright (c) 1982, 2014, Oracle. All rights reserved.
-
-
-
Connected to:
-
Oracle Database 12c Enterprise Edition Release 12.1.0.2.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 PDB1 READ WRITE NO
-
4 PDB2 READ WRITE NO
TWO_TASK不支持操作系统验证,即 sqlplus / as sysdba
-
[oracle@test ~]$ export TWO_TASK=pdb1
-
[oracle@test ~]$ sqlplus / as sysdba
-
-
SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 9 04:10:19 2015
-
-
Copyright (c) 1982, 2014, Oracle. All rights reserved.
-
-
ERROR:
-
ORA-01017: invalid username/password; logon denied
-
-
-
Enter user-name:
-
[oracle@test ~]$ export TWO_TASK=pdb1
-
[oracle@test ~]$ sqlplus sys/oracle as sysdba
-
-
SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 9 04:11:17 2015
-
-
Copyright (c) 1982, 2014, Oracle. All rights reserved.
-
-
-
Connected to:
-
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
-
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
-
-
SQL> show con_name
-
-
CON_NAME
-
------------------------------
-
PDB1
-
SQL> exit
-
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
-
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
-
[oracle@test ~]$ sqlplus system/oracle
-
-
SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 9 04:11:48 2015
-
-
Copyright (c) 1982, 2014, Oracle. All rights reserved.
-
-
Last Successful login time: Mon Nov 09 2015 04:00:10 +08:00
-
-
Connected to:
-
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
-
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
-
-
SQL> show con_name
-
-
CON_NAME
-
------------------------------
-
PDB1
阅读(584) | 评论(0) | 转发(0) |