| 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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
