PDBORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = ))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = PDBORCL)

    )

  )

SQL > conn sysYouPassword as sysdba;

SQL > alter session set container = PDBORCL;

SQL > startup

SQL > conn sys@pdborclYouPassword as sysdba;

SQL > alter user scott account unlock identified by tiger;

SQL > conn sysYouPassword as sysdba;

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 immediate

SQL > startup