Home » RDBMS Server » Server Administration » Value of sga_target too small (oracle 11.2.0.3 on linux)
Value of sga_target too small [message #586610] Sat, 08 June 2013 02:08 Go to next message
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


Re: Value of sga_target too small [message #586612 is a reply to message #586610] Sat, 08 June 2013 02:24 Go to previous messageGo to next message
John Watson
Messages: 4082
Registered: January 2010
Location: Global Village
Senior Member
Copy $ORACLE_HOME/dbs/initQR01MRA1.ora to somewhere safe, then

create pfile from spfile='+DB_DATA/QR01MRA/spfile';
Re: Value of sga_target too small [message #586619 is a reply to message #586612] Sat, 08 June 2013 02:53 Go to previous message
vivek_k47
Messages: 14
Registered: August 2012
Location: india
Junior Member
that solved the problem.thanks.
Previous Topic: INVALID satus in dba_registry
Next Topic: Space management in 10g + high water mark
Goto Forum:
  


Current Time: Sat Apr 19 15:56:59 CDT 2014

Total time taken to generate the page: 0.12910 seconds