Home » RDBMS Server » Server Administration » my instance is not starting up...
my instance is not starting up... [message #211067] Tue, 26 December 2006 01:24 Go to next message
Messages: 101
Registered: May 2006
Senior Member
Hi all

i am getting following error message, when i try to startup the instance,

ORA-00371: not enough shared pool memory, should be atleast 102464307 bytes

the instance is using spfile, before that i changed the sga_target parameter from 900m to 0 and shutdown the instance,

now my database is down, how can i overcome this situation..

pls help me in this.

Re: my instance is not starting up... [message #211073 is a reply to message #211067] Tue, 26 December 2006 01:58 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

SQL> startup
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes
SQL> --edit init<sid>.ora file and increase SHARED_POOL_SIZE=62198988
SQL>--create spfile file from pfile(init<sid>.ora)

SQL> create spfile from pfile;

File created.

SQL> startup
ORACLE instance started.

Total System Global Area  150994944 bytes
Fixed Size                   787888 bytes
Variable Size             124516944 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
Database mounted.
Database opened.
SQL> show parameter shared_pool_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size                     big integer 60M


[Updated on: Tue, 26 December 2006 02:06]

Report message to a moderator

Previous Topic: ORA-12505 TNS:Listener does not currently know of SID given in connect descriptor
Next Topic: Impact of parameter changes in server
Goto Forum:

Current Time: Sat Oct 22 11:47:39 CDT 2016

Total time taken to generate the page: 0.09242 seconds