To apply a PSU we can
download the required PSU and apply using “opatch apply” command of OPATCH
utility. In RAC environment or Oracle restart environment (single node Grid Infrastructure
installation), we would need to download “GI PSU” to patch the Grid
Infrastructure home. We have option to download and apply “GI PSU” patch to
both GI and RDBMS homes as well because GI PSU contains patch for both homes. In
this case we use “opatch auto” (for 11g) or “opatchauto” (for 12c and above)
command to be run as root user so that path can be applied on both homes.
Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.
Friday, May 31, 2019
Saturday, May 18, 2019
ORA-00245: control file backup failed; target is likely on a local file system
Your RMAN backup command may fail with ORA-00245
while backing up current control file as part of database backup. RMAN output
along with the error message may look similar to the following. The highlighted
in red is the actual cause of this error which I will explain later in this
article and provide the solution for this.
Subscribe to:
Posts (Atom)
Popular Posts - All Times
-
This error means that you are trying to perform some operation in the database which requires encryption wallet to be open, but wallet is ...
-
Finding space usage of tablespaces and database is what many DBAs want to find. In this article I will explain how to find out space usage ...
-
ORA-01653: unable to extend table <SCHEMA_NAME>.<SEGMENT_NAME> by 8192 in tablespace <TABLESPACE_NAME> This error is q...
-
You may also want to see this article about the ORA-12899 which is returned if a value larger than column’s width is inserted in the col...
-
This document explains how to start and stop an Oracle cluster. To start and stop Grid Infrastructure services for a standalone installatio...
-
If database server CPU usage is showing 100%, or high 90%, DBA needs to find out which session is hogging the CPU(s) and take appropriate ...
-
If you want to know how we upgrade an 11g database to 12c using DBUA, click here . For upgrading 12.1.0.1 to 12.1.0.2 using DBUA, ...
-
By default AWR snapshot interval is set to 60 minutes and retention of snapshots is set to 8 days. For better and precise investigation of...
-
SWAP space recommendation from Oracle corp. for Oracle 11g Release 2 If RAM is between 1 GB and 2 GB, SAWP should be 1.5 times the s...
-
This article explains how to install a 2 nodes Oracle 12cR1 Real Application Cluster (RAC) on Oracle Linux 7. I did this installation on O...