RMAN-06403,RMAN-04006,ORA-01034,ORA-27101

Duplicating database using Rman fails with errors RMAN-06403,RMAN-04006,ORA-01034,ORA-27101 [ID 274233.1]

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.4 and later   [Release: 9.2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 18-Nov-2011***

Symptoms

RMAN DUPLICATE fails with errors :

RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Compaq Tru64 UNIX Error: 2: No such file or directory

Cause

The errors are occuring because the auxiliary database is not started in nomount state.

Solution


The auxillary instance must be in a nomount state during duplication of database
using rman.

Startup the auxiliary instance in nomount state. Then try to duplicate the database again.

SQL> connect / as sysdba
     startup nomount;

Also you have to verify the following:

1. Ensure that the ORACLE_SID and ORACLE_HOME were set correctly when starting
the auxiliary instance. Especialy and additional backslash at the end of the ORACLE_HOME can cause mismatches

2. Verify that the ORACLE_HOME directory is not a linked directory.
    Make a hard copy of the init.ora in the ORACLE_HOME/dbs directory.

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...