My Learning

OS: OEL 5.7 DB: 11.2.0.3.0 64 Bit RMAN> startup nomount ; startup failed: ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u02/oracle/ERP/db/tech_st/11.2.0/dbs/initERP.ora' starting Oracle instance without parameter file for retrieval of spfile RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of startup command at 07/24/2014 11:08:06 RMAN-04014: startup failed: ORA-04031: unable to allocate 1048608 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","row cache") During rman restore and recovery testing i was trying to restore spfile from backup. But issuing startup nomount with RMAN threw "ora-10078". I remember reading somewhere, rman will start databa

Oracle Application R12.1.3 Database 11.2.0.3 Os OEL 5.7 vmprod-primary - Primary Database vmprod-standby - Standby Database Installation base (Both Application and Database) /u02/oracle/ERPDG 1. Prepare Primary Database Server Check if force logging is enabled SYS@ERPDG*vmprod-primar$ select force_logging from v$database; If not enabled enable it with following command SYS@ERPDG*vmprod-primar$ alter database force logging ; Create Oracle Net service names and Listener Modification required to for net connfiguration to setup standby database will be done using ifiles As autoconfig overwrites changes made to tnsnames and listener files, configuration changes required for net configuration files to setup standby database will be done using ifiles. Create/Modify ifiles Go to TNS_DMIN cd $TNS_ADMIN Ifile names listener = listener_ifile.ora tsnames = ERPDG_vmprod-primary_ifile.ora Note: Check th