Managing Oracle Multitenant Databases - OCP: Oracle Database 12c Administrator Certified Professional - page 561

exeRCiSe 12.2 (continued)
OK (0 msec)
C:\>
4. At the prompt, specify the service name of the PDB you wish to connect to: the
instance identifier (SID) unique to this server and database domain:
C:\> set ORACLE_SID=pdb1
5. Connect to the PDB specified in the ORACLE_SID with user SYS as SYSDBA using data-
base authentication:
C:\>sqlplus sys/system@pdb1 as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Fri Nov 29 14:28:34 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
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 USER
USER is "SYS"
SQL>
SQL> SHOW CON_NAME
CON_NAME
---------
PDB1
SQL>
6. While you're here, create a new local user, grant connect to the user, and then con-
nect to the PDB as the user via the net service name:
SQL> CREATE USER testpdb IDENTIFIED BY password
CONTAINER = current;
User created.
SQL> GRANT CONNECT TO testpdb;
Grant succeeded.
SQL> connect testpdb/password@pdb1
Connected.
SQL>