Friday, August 4, 2017

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

I am trying to setup dataguard for one of our database and while starting the DG instance in nomount mode I am getting an ORA-00371 error

SQL> startup nomount pfile='inittst_aux.ora';
ORA-00371: not enough shared pool memory, should be atleast 1034490288 bytes
SQL>
SQL> !cat inittst_aux.ora
db_name=dev1tstp
SQL> 

This is a bug in Oracle 11.2 and as a workaround what I have done is added a parameter sga_target to ensure that instance has enough memory to start with

[oracle@comp01 (dev1tstd1) dbs]$ cat inittst_aux.ora
db_name=dev1tstp
sga_target=2560M
[oracle@comp01 (dev1tstd1) dbs]$ 

After setting up the parameter the instance started alright.

[oracle@comp01 (dev1tstd1) dbs]$ sqlplus "/ as sysdba"
 set pages 10000 lines 270 long 10000
SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 3 09:48:14 2017
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> SQL>
SQL>
SQL> startup nomount pfile='inittst_aux.ora';
ORACLE instance started.
Total System Global Area 2672361472 bytes
Fixed Size                  2231352 bytes
Variable Size             654312392 bytes
Database Buffers         1979711488 bytes
Redo Buffers               36106240 bytes
SQL> 


No comments: