Home of Tips and Tricks, specially on Oracle, PHP, MySql. Others different topics will also be provided.
Below trigger will be created after SYS login to Container database
CREATE OR REPLACE TRIGGER auto_open_pdb
AFTER STARTUP ON DATABASE
BEGIN
EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';
END auto_open_pdb