Hi, in this post I will write about how Oracle Database 19c Multitenant architecture PDB is created with DBCA. Run the DBCA after the CDB Database is set. Then just follow the steps as below. Choose Manage Pluggable Databases Choose Create a Pluggable Database Enter the sys information for the container database. Choose Create a […]

When I wanted to change the password on the pluggable database user, I got an error like the one below. SQL> alter user test identified by test; alter user test identified by test ERROR at line 1:ORA-65066: The specified changes must apply to all containers View connection information. SQL> show con_nameCON_NAMEPLUG1 Login as sysdba SQL> […]

Today I will talk about a problem I encountered in pdbs “ORA-01033” error on Oracle Container Database. Query existing databases running on the container. SELECT inst_id,con_id,name,open_mode FROM gv$pdbs ORDER BY con_id,inst_id If the databases are “ALTER PLUGGABLE DATABASE ALL OPEN” If you opened it with the command, you just opened it on the relevant cdb. […]