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:

How to add a datafile to a bigfile tablespace in Oracle 23ai Database.

  Syntax for Bigfile Tablespace: SQL > ALTER TABLESPACE tablespace_name ADD DATAFILE SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED; Ho...