| my instance is not starting up... [message #211067] |
Tue, 26 December 2006 01:24  |
sreehari
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  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
hi,
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
SQL>
regards
Taj
[Updated on: Tue, 26 December 2006 02:06] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
