ORA-00371: not enough shared pool memory, shocould be atleast 62198988 bytes

The problem is as follows:

ORA-00371: not enough shared pool memory, shocould be atleast 62198988 bytes

Solution Process:

Method 1:

First confirm '$ ORACLE_HOME/dbs/spfileORCL. ora '. Check whether the file exists. Note that the instance is case sensitive. If spfileorcl exists. ora, you only need to modify the file name to spfileORCL. the ora problem can be solved;

Method 2:

1) Start pfile first

SQL> startup nomount pfile = '/opt/ora10g/product/10.2.0/db_1/admin/orcl/pfile/init. ora.105201102812 ';

ORACLE instance started.

Total System Global Area 218103808 bytes

Fixed Size 1218604 bytes

Variable Size 71305172 bytes

Database Buffers 142606336 bytes

Redo Buffers 2973696 bytes

2) create a new pfile from spfile (this file is required later when you create a spfile)

SQL> create spfile = '/opt/ora10g/product/10.2.0/db_1/dbs/spfileORCL. ora 'from pfile = '/opt/ora10g/product/10.2.0/db_1/admin/orcl/pfile/init. ora.20111105 ';

File created.

Note: If the spfile. ora file is not found in the dbs directory under the database installation directory, you can find it in the database directory under the directory. * The spfile file is generally the SPFILE Instance name. ora... if my Instance name is ORCL, then my spfile file is spfileORCL. ora.

3) After pfile is created, you can modify the shared_pool_size in it to your desired size.

4) shut down the database and start from the new pfile file.

SQL> shutdown immediate

SQL> startup pfile = '/opt/ora10g/product/10.2.0/db_1/admin/orcl/pfile/init. ora.20111105'

ORACLE instance started.

Total System Global Area 218103808 bytes

Fixed Size 1218604 bytes

Variable Size 71305172 bytes

Database Buffers 142606336 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

5) create a spfile from the modified pfile.

SQL> create spfile = '/opt/ora10g/product/10.2.0/db_1/dbs/spfileORCL. ora 'from pfile = '/opt/ora10g/product/10.2.0/db_1/admin/orcl/pfile/init. ora.20111105 ';

File created.

6) Disable restart and solve the problem

SQL> shutdown immediate

SQL> startup

ORACLE instance started.

Total System Global Area 218103808 bytes

Fixed Size 1218604 bytes

Variable Size 71305172 bytes

Database Buffers 142606336 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.