Oracle Database: Tip from our Instructor

ERROR: memory_target greater then memory_max_target

Steps:

1. edit the pfile 

$ vi $ORACLE_HOME/dbs/initorcl.ora

- - - make sure the value of memory_target is not greater than that of memory_max_target.

- - save the changes

2. start the database using the pfile

SQL > startup force pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'

3. create an spfile from the modified pfile

SQL > create spfile from pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora';

4. startup the database using the spfile.

SQL > startup force ( by default the database uses the spfile)