Ora-04031 Unable to allocate nn bytes of shared memory

1 ps -ef|grep oracle
2 find the smon and kill the pid for it
3 SQL> startup mount

ORACLE instance started.

Total System Global Area 4831838208 bytes Fixed Size 2027320 bytes Variable Size 4764729544 bytes Database Buffers 50331648 bytes Redo Buffers 14749696 bytes Database mounted. SQL>
4 SQL> alter system set shared_pool_size=100M scope=spfile;

System altered.
5 SQL> shutdown immediate

ORA-01109: database not open

Database dismounted. ORACLE instance shut down.
6 SQL> startup

ORACLE instance started.

Total System Global Area 4831838208 bytes Fixed Size 2027320 bytes Variable Size 4764729544 bytes Database Buffers 50331648 bytes Redo Buffers 14749696 bytes Database mounted. Database opened.
7 SQL> create pfile from spfile;

File created.

SOLVED

Tweet