Online DBA

<<Back to DB Administration Main Page How to connect to PDB directly as SYSDBA using OS Authentication The secret to this is environment variable ORACLE_PDB_SID SQL> show pdbs     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDB01                               READ WRITE NO          4 PDB02                             ...

<<Back to DB Administration Main Page ORA-65010: maximum number of pluggable databases created Solution: Increase the  max_pdbs parameter  alter session set container=cdb$root; Session altered. SQL> create pluggable database PDB02 admin user syspdb identified by password roles=(DBA) file_name_convert = ('pdbseed','PDB02'); create pluggable database PDB02 admin user syspdb identified by password roles=(DBA) file_name_convert = ('pdbseed','PDB02') * ERROR at line 1: ORA-65010: maximum number of pluggable databases created SQL> show parameter max_pdbs NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ max_pdbs            ...

<<Back to DB Administration Main Page How to Install Oracle 19c Database Software Oracle 12c Software Only Installation in Silent Mode   Step0> download the binaries Download Here Step1> Unzip Binaries Unzip the binary directly in the oracle home $unzip -d /ora_app/product/19c/dbd1 LINUX.X64_193000_db_home.zip Step2.0> Launch runInstaller $/ora_app/product/19c/dbd1/runInstaller  Step2.1> If you want to create the database together with software installation just click Next . If you want to install database binaries only and create the database later as demonstrated in this post choose Setup Software Only option and click Next   Step2.2> Choose Single Instance Database Installation and click Next     Step2.3>  Choose Enterprise Edition and click Next       Step2.4>  Enter correct path for OracleBase and click Next       Step2.5> Enter correct path for Invento...