Online DBA

  <<Back to Oracle RAC Main Page Cloning Oracle RAC Database to Single Instance Database Existing DB ORCL with 2 node (ORCL11 and ORCL12) Closed DB: ORCLN Step1: Add Static Listener Entry Add Static Listener Entry in GRID_HOME/network/admin/listener.ora and reload the listener  SID_LIST_LISTENER =   (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = ORCLN)      (ORACLE_HOME = /ora_app/product/19c/dbd1)      (SID_NAME = ORCLN)     )   )  lsnrctl reload LISTENER LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-FEB-2026 09:14:16 Copyright (c) 1991, 2023, Oracle.  All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) The command completed successfully [+ASM1] lsnrctl status |grep -i ORCLN Service "ORCLN" has 1 instance(s).   Instance "ORCLN", status UNKNOWN, has 1 handler(s) for this service... Step2:Add TNS entry for ORCLN add...

  Step by Step Upgrading Database using Autoupgrade utility  <<Back to DB Administration Main Page Step1: create config file  java -jar autoupgrade.jar -create_sample_file config /oracle/ORCL/ORCL_autoupgrade.cfg Step2: Adjust the config file  parameters  global.autoupg_log_dir=/ora_app/cfgtoollogs/autoupgrade upg1.log_dir=/ora_app/cfgtoollogs/autoupgrade/ORCL  upg1.sid=ORCL  upg1.source_home=/ora_app/product/12.1.0.2/home12 upg1.target_home=/ora_app/product/19c/home19 upg1.start_time=NOW  upg1.upgrade_node=host1.merckgroup.com upg1.run_utlrp=yes upg1.timezone_upg=yes step3: Run PreCheck java -jar autoupgrade.jar -config /ora_work/ORCL/ORCL_autoupgrade.cfg -mode analyze AutoUpgrade 24.6.240905 launched with default internal options Processing config file ... +--------------------------------+ | Starting AutoUpgrade execution | +--------------------------------+ 1 Non-CDB(s) will be analyzed Type 'help' to list console commands upg> Job 10...

  Oracle Autoupgrade Available Commands <<Back to DB Administration Main Page java -jar autoupgrade.jar -help Usage: java -jar autoupgrade.jar <option(s)> Syntax: <required> [optional] default* options = <run_type1|run_type2|run_type3> run_type1 = -version | -help | -create_sample_file <options> | -listchecks <checkName> run_type2 = [-settings <settings>]             <-config <config>|-config_values <config_values>>             [-mode <mode>]             [-load_password]             [-restore_on_fail]             [-console | -noconsole]             [-debug]             [-clear_recovery_data [-jobs job#,job#,...]]             [-restore -jobs <job#,job#,...>]>     ...

  <<Back to DB Administration Main Page Oracle Database AutoUpgrade tool Starting from oracle 19c there is a tool available to upgrade the databases. This is called oracle auto upgrade and is a recommended method  by oracle to upgrade the database. Start using and adopting it  soon this will be only way to upgrade the database  The idea of the tool is to run the prechecks against multiple databases, fix majority  of the potential issues, set a restore point in case something goes wrong – and then upgrade your databases. And of course, do the postupgrade, recompilation and time zone adjustment. The only thing you need to provide is a config file in text format How to download  AutoUpgrade Tool This tool is available with Oracle Database 19c (19.3)  You can download the most recent version from MOS Note: 2485457.1  AutoUpgrade documentation It is all here included in the Oracle Database 19c Upgrade Guide: Using AutoUpgrade for Oracle Data...

  <<Back to Oracle Backup & Recovery Main Page Restoring/Recovering  Table  from RMAN Backup oracle 19c Point In Time table Restore/Recovery in Oracle Today I had a situation where application team accidently deleted data from a table in prod database and wanted to restore it from backup. The requirement was to restore the table with different name washout touching the original table so that the application team can compare it and find out the different eventually deleted rows Before 12.2 the task was complicated and it was achieved by restoring the full database on 3rd server and export  the table from restored database and import it in original database. Oracle has now automated the procedure and made it quite easy. Now you just have to run one command and the rest is taken care by oracle Scenarios Container DB Name: CDBDB Pluggable DB Name: PDB1 Table  to be restored: TEST Schema/Owner of the table: EMPLOYEE New Table Name After Restore:...

<<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...