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

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

Oracle Solaris 11.2 introduced new package in IPS  "oracle-rdbms-server-12cR1-preinstall". Users need to check all packages exists on the system before starting the Installation. This preinstall package was first introduced in Oracle Enterprise Linux and now available in Oracle Solaris 11.2. In Oracle Solaris 11.2  its very easy for administrators to install this package and they are not required to check dependencies/version of each and every package. For Installing "oracle-rdbms-server-12cR1-preinstall"  package your solaris IPS repository should be configured. IPS can be configured via Internet or can be configured on your local file system. For more information on configuring IPS locally please refer my earlier blogpost: Configure IPS on Oracle Solaris11.2 Locally Check for IPS repository publisher root@solaris11-2:~# pkg publisher PUBLISHER TYPE STATUS P LOCATION solaris origin online F file:///IPS/ roo...

Here is an excellent opportunity to buy books from PACKT Publishers. They are celebrating 2000 titles for their published books. Now if you buy 1 book than you can get another book free of cost. Its 1 + 1 offer. I am reading books from packt publishers since 3 years and  they are really very helpful for understanding latest technologies. You can buy using URL's: bit.ly/1j26nPN   http://www.packtpub.com/?utm_source=referral&utm_medium=marketingPR&utm_campaign=2000thTitle thanks, X A H E E R