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 Managing TNS_ADMIN  Variable in env.ora S tarting from 12cR2 you can manage TNS_ADMIN variable in $ORACLE_HOME/env.ora file   ls -lrt $ORACLE_HOME |grep env.ora -rw-r--r--  1 oracle dba   852 Aug 18  2015 env.ora By default, the $ORACLE_HOME/env.ora is empty. If you leave this file untouched and nothing else is set, the default $ORACLE_HOME/network/admin location is read. $cat env.ora # Copyright (c) 2015, Oracle and/or its affiliates. All rights reserved. # # NAME #   env.ora # # FUNCTION #   Oracle ENVironment variables persistency file template # # NOTES #   This is a generic file for defining environment variables. #   It facilitates the requirement to maintain persistency of environment #   variables across multiple instances in lieu of setting the variables in #   the environment. # #   Note that setting a variable in the envir...

<<Back to Oracle DataGuard Main Page When License Oracle Active Dataguard (ADG) feature You can use Oracle Data Guard as long as you are holding license for EE (DG license is included in Oracle Database Enterprise Edition). However Active Data Guard feature requires additional license on top. You need ADG license if you are using any or all of the features from the list below. Using BCT (Block Change Tracking) at standby Running redo apply services while an User PDB is open in read only Running Multi Instance redo apply -RAC Rolling Upgrade Using Active Data Guard Automatic Block Repair Global Data Services Real-Time Cascading (transferring the redo to the cascaded destination without waiting for the redo to be archived to a standby redo log file.) Active Data Guard Far Sync Starting from 18c (At least I test with 18c) you can have PDB$SEED and CDB$ROOT in read only without having ADG license.  Lets have a quick test: At Standby Database   set...

<<Back to DB Administration Main Page How to Patch oracle 18c/19c Non RAC (Single Instance) database NOTE: Starting from 18c Oracle calls Patch Set Update (PSU), as Release Update (RU). S tep1> Download the Patch Download the patch to be applied from oracle support Step2> Transfer the patch on the sever and unzip it using unzip utility Note: I am using OCT2019 PSU(RU) together with OJVM patch p30112122_180000_Linux-x86-64.zip  <= OCT DB PSU (DB RU) p30133603_180000_Linux-x86-64.zip  <= OCT JAVA Patch $unzip p30112122_180000_Linux-x86-64.zip -d /OCT_2019_PSU/ $unzip p30133603_180000_Linux-x86-64.zip -d /OCT_2019_PSU/ Step3> Verify Utility the Opatch version OPatch Utility: You must use the OPatch utility version as described in README file for the patch. Oracle recommends that you use the latest released OPatch version for 18c, which is available for download from My Oracle Support patch 6880880 by selecting the 18.0.0.0.0 release. $export P...