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                               READ WRITE NO SQL> $ export ORACLE_PDB_SID=PDB01 $ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 13 11:22:50 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> show con_name CON_NAME ------------------------------ PDB01

<<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                             integer     1 SQL> alter system set max_pdbs=3; System altered. 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 Inventory and click Next         Step2.6> Verify and Click Next