Database Blog

Correct permission for oracle binary from GRID and RDBMS Home and ASM devices to avoid ORA-27041 ORA-15025 ORA-15081

Correct permission for oracle binary from GRID and RDBMS Home and ASM devices.   GRID(oracle binary) RDBMS(oracle binary) ASM Devices permission Correct Permission for role separation -rwsr-s–x 1 grid oinstall…

Read More

RMAN-20109: remote database has different database ID

Cause: Command RESYNC CATALOG FROM DB_UNIQUE_NAME was executed and the database ID of the remote database was different than the connected target database. Action:   The remote database should have…

Read More

RMAN-20222: datafile name not found in recovery catalog or is ambiguous

Cause: The specified datafile name is not the name of a datafile that is currently part of the target database, or an UNTIL clause has been specified and the file…

Read More

RMAN-20246: new db_unique_name is already known to the recovery catalog

Cause: the user specified known DB_UNIQUE_NAME value when renaming a DB_UNIQUE_NAME in the recovery catalog. Action:  change the database DB_UNIQUE_NAME to an known DB_UNIQUE_NAME value; or unregister the new DB_UNIQUE_NAME…

Read More

RMAN-20501: redo logs from parent database incarnation cannot be applied

Cause: A RESTORE or RECOVER of a datafile was requested, but recovery of the datafile would require applying redo logs that were generated before the most recent OPEN RESETLOGS. Action:…

Read More

RMAN-20507: some targets are remote – aborting restore

Cause: During the restore process, one or more backup files were unavailable locally for the restore operation. Action: This message should be accompanied with the list of remote backup files.…

Read More

RMAN-20511: database name is ambiguous in source recovery catalog database

Cause: Two or more databases in the source recovery catalog database match this name. Action:  Use DBID option in IMPORT CATALOG command to specify the source database.  

Read More

RMAN-20512: source database already registered in recovery catalog

Cause: Source database was already registered in the recovery catalog. Action: If the source database is really registered, there is no need to register it again. Note that the recovery…

Read More

ORA-39358: Export dump file version 12.1.0.2.0 not compatible with target version 11.2.0.4.0

Problem: While doing import got te below error. ORA-39358: Export dump file version 12.1.0.2.0 not compatible with target version 11.2.0.4.0 . Solution: 1. Check the compatible parameter of both source…

Read More

OPATCHAUTO-72046: No Wallet Option Provided

Problem: While applying latest PSU patch on oracle 12c RAC database, execution of opatchauto apply command got below error. $ORACLE_HOME/OPatch/opatchauto apply /patch/Jan2018/26635880 -oh /oracle/app/oracle/product/12.2.0.1/grid OPatchauto session is initiated at Wed…

Read More