ORACLE12C Open Scott Account

In the Oracle directory app\orcl\product\12.1.0\dbhome_1\network\admin\ tnsnames.ora file, add the following:

  PDBORCL =1521)    )=      = dedicated)      =     pdborcl)   ))

Then enter Sqlplus to connect to the login sys account and run the following statement

SQL > Conn Sysyoupassword asSysdba; SQL> Alter SESSIONSetcontainer =PDBORCL; SQL>Startupsql> conn [email protected] asSysdba; SQL>alter user Scott account unlock identified by Tiger; SQL> Conn Sysyoupassword asSysdba; SQL>CREATE OR REPLACE TRIGGER Open_all_pdbs after STARTUP on DATABASE BEGIN EXECUTE IMMEDIATE'Alter pluggable database all open';    END Open_all_pdbs; SQL>shutdown Immediatesql> Startup

Now you can use the account [email protected] Password Tiger login

ORACLE12C Open Scott Account