Oracle Database, Fusion Middleware, Linux


Moving SPFILE from file system to ASM (ORACLE RAC11g)

There are two nodes in oracle RAC database [rac1] and [rac2] Below tasks has to be executed from the first node [rac1] 1. Create spfile in ASM “+RACDB_DATA” disk group SQL> connect / as sysdba SQL> show parameter spfile NAME TYPE VALUE ——- ——- —————————— spfile string /u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdb11.ora SQL> create pfile=’/u01/app/oracle/product/11.2.0/db_1/dbs/initracdb11.ora’ from spfile=’/u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdb11.ora’; #Or simply: SQL> […]

, , ,

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.