Apps DBA Workshop

  The title of the blogpost looks weird right? But sometimes as a business requirement we many need to delete or drop the databases. If there is requirement to drop any database which has prod/non prod data then ensure you've performed a complete backup of the database. Once you drop the database there is no chance that you can recover it and hence backup is must. This blogpost will provide a step by step method for dropping an Oracle 19c Cluster Database. 1. check the status of Database: [oracle@ebsdb01 ~]$ ps -ef | grep pmon oracle 92680 92633 0 16:33 pts/4 00:00:00 grep --color=auto pmon oracle 110059 1 0 03:36 ? 00:00:10 ora_pmon_ebsdb1 2.  Stop the Database on all nodes: [oracle@ebsdb01 ~]$ srvctl stop database -d ebsdb [oracle@ebsdb01 ~]$ 3.  Startup database and disable cluster database parameter: bring up he database in mount mode. oracle@ebsdb01 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 8 16:37:59 2021 Ver...

Oracle EBS R12.1.3 clone configuration script failing while configuring config tools. This issue is reported on OracleEBS running on IBM-AIX 6.1. Environment details: OS Version             => IBM-AIX 6.1 (64-Bit) EBS version           => R12,1.3 Database Version   => 11.2.0.1 Error Stack while running adcfgclone.pl on appsTier: Setting LIBPATH to /oratest/R12_app/apps_st/comn/clone/oui/lib/aix Beginning application tier Apply - Mon Feb 2 11:11:30 2022 /oratest/R12_app/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /oratest/R12_app/apps_st/comn/clone/jlib/xmlparserv2.jar:/oratest/R12_app/apps_st/comn/clone/jlib/ojdbc14.jar:/oratest/R12_app/apps_st/comn/clone/jlib/java:/oratest/R12_app/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/oratest/R12_app/apps_st/comn/clone/jlib/oui/ewt3.jar:/oratest/R12_app/apps_st/comn/clone/jlib/oui/sha...