Query to display/report FULL and INCR backup details of database. In this article, we will demonstrate about the queries that provide FULL and INCR backup details of a oracle database.
Step by Step procedure for Oracle Grid Infrastructure dry-run upgrade on RAC Linux. Oracle Grid Infrastructure dry-run upgrade mode enables you to check system readiness for upgrade. Purpose of the
Error Received: Oracle Clusterware cannot be started : CRS-6706: Oracle Clusterware Release patch level (‘3909003374’) does not match Software patch level (‘3998055650’).CRS-4000: Command Start failed, or completed with errors. Error
Step by step procedure to deinstall 12201 GRID HOME. It is mandatory activity for Oracle DBA to uninstall the old version if it is not in use . Otherwise there
To Disable Online Analytical Process (OLAP) option in Oracle. Step 1)Database version 11g Release 2 and newer col parameter format a15 col value format a15 select * from v$option where
Issues & Fixes while upgrading GI from 12c to 19c. Issues & Fixes while upgrading GI from 12.1.0.2.0 to 19.14.0.0.0 RAC environment.Source GI version: 12.1.0.2.0Target GI Version: 19.14.0.0.0 Our Plan
Rough Estimation in terms of no.of hours for Oracle DB setup. In general , We need 30 hours (approximate) to complete all the below activities on servers in 10 working
To drop Oracle database… oracle@ORASRVR:/u00/app/oracle/ [ORCL] sqlplus “/as sysdba” SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 12 17:38:21 2022 Connected to an idle instance. SQL> startup mount restrictORACLE instance
