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