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

 We were not able to create the container database and it encountered following Error: [pool-1-thread-1] [ 2021-08-17 15:25:52.277 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName [pool-1-thread-1] [ 2021-08-17 15:25:52.277 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName:nodenumber: 1 [pool-1-thread-1] [ 2021-08-17 15:25:52.279 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName:nodename: erp-preprod-db01 INFO: Aug 17, 2021 3:25:52 PM oracle.assistants.dbca.util.NodeSelectionHelper reorderLocalNodeIndex INFO: Local node found at index:0 localnode:erp-preprod-db01 INFO: Aug 17, 2021 3:25:52 PM oracle.assistants.dbca.action.DBIdentificationAction updateRACConfiguration INFO: Added: [erp-preprod-db01, erp-preprod-db02] to the node list in the bean [pool-1-thread-1] [ 2021-08-17 15:25:52.280 AST ] [has.UtilNative.Native] prsr_trace: Native: getCRSHome [pool-1-thread-1] [ 2021-08-17 15:25:52.280 AST ] [has.UtilNa...

What is Oracle Autonomous Database? Oracle Autonomous Database allows you rapidly & easily create mission critical databases, It protects data from both external and internal threats, automates all infrastructure & database maintenance, recovers from any failure without downtime and scales online for highest performance & lower cost. Components of Oracle Autonomous Database: An Oracle Autonomous database comprises of 3 components: Oracle Exadata Oracle database Automated Data Center Operations and Machine Learning   How Does Oracle Database Works: An Oracle Autonomous Database is self driving, self securing and self repairing. Self Driving:  It Automates all databases and infrastructure management, Patching, tune Queries and Monitoring Self Securing:  Protects database from both external and malicious internal users by automatically encrypting data both at rest and in transit Self Repairing:  Automatically recover from any failure. Protects fro...