High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

RMAN-04006: error from auxiliary database: ORA-12514 error during standby creation

Hi

We have a 2 node RAC 11.2.0.3 primary database and from that we are trying to create a stand alone physical standby database

After completing all the pre-requisites, from one of the primary nodes, we executed the following

Standby database

================

==>  startup nomount pfile='init.ora'; (init.ora contents --> db_name='stgappdr')

==>  export ORACLE_HOME=$GRID_HOME ; export ORACLE_HOME

==>  lsnrctl start

==> lsnrctl status

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                13-MAR-2014 23:41:15

Uptime                    0 days 0 hr. 19 min. 10 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center