OraFAQ Forum: Server Administration » Value of sga

Home » RDBMS Server » Server Administration » Value of sga_target too small (oracle 11.2.0.3 on linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Value of sga_target too small [message #586610]

Sat, 08 June 2013 02:08

vivek_k47
Messages: 14
Registered: August 2012
Location: india

Junior Member

Hi,
How can i increase the sga_target in this case.Im unable to create a pfile.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-00821: Specified value of sga_target 2048M is too small, needs to be at least 4112M

SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0

SQL>create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information:3

The $ORACLE_HOME/dbs location has a spfile.

more initQR01MRA1.ora
SPFILE='+DB_DATA/QR01MRA/spfile'

Need suggestions.thanks

Report message to a moderator