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:
Post a Comment