Shulou(Shulou.com)06/01 Report--

Two ways to connect to a pluggable database $sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 20 17:59:56 2018Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning, OLAP Advanced Analytics and Real Application Testing optionsSQL > 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 5 PDB3 READ WRITE NO 6 PDB4 READ WRITE NO-method 1SQL > alter session set container=pdb1 Session altered.SQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 3 PDB1 READ WRITE NOSQL > exitDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning OLAP, Advanced Analytics and Real Application Testing options-- method II $sqlplus sys/oracle@roidb01:1521/pdb1 as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 2018: 02:02 2018Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning, OLAP Advanced Analytics and Real Application Testing optionsSQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 3 PDB1 READ WRITE NOSQL > show user USER is "SYS" SQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.