Good Morning!
The full error is
ORA-00371: not enough shared pool memory, should be atleast 1439485132 bytes
I've looked at
2140046 but it hasn't helped me.
df -h gives me
tmpfs 71G 12G 60G 16% /dev/shm
Here's a snip from sysctl -a:
...
kernel.threads-max = 2392064
kernel.cad_pid = 1
kernel.sysrq = 0
kernel.sem = 250 32000 100 128
kernel.msgmnb = 65536
kernel.msgmni = 16
kernel.msgmax = 65536
kernel.shmmni = 4096
kernel.shmall = 4294967296
kernel.shmmax = 68719476736
And my pfile is
[REDACTED]2.__db_cache_size=33017561088
[REDACTED]1.__db_cache_size=32614907904
[REDACTED]2.__java_pool_size=134217728
[REDACTED]1.__java_pool_size=134217728
[REDACTED]2.__large_pool_size=134217728
[REDACTED]1.__large_pool_size=134217728
[REDACTED]1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
[REDACTED]2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
[REDACTED]2.__pga_aggregate_target=21206401024
[REDACTED]1.__pga_aggregate_target=21206401024
[REDACTED]2.__sga_target=39594229760
[REDACTED]1.__sga_target=39594229760
[REDACTED]2.__shared_io_pool_size=402653184
[REDACTED]1.__shared_io_pool_size=536870912
[REDACTED]2.__shared_pool_size=5502926848
[REDACTED]1.__shared_pool_size=5771362304
[REDACTED]2.__streams_pool_size=0
[REDACTED]1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/[REDACTED]/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+SYSTEM/[REDACTED]/controlfile/current.261.749475105','+[REDACTED]_DATA/[REDACTED]/controlfile/current.256.749475105'
*.db_block_size=8192
*.db_create_file_dest='+[REDACTED]_DATA'
*.db_create_online_log_dest_1='+SYSTEM'
*.db_create_online_log_dest_2='+[REDACTED]_DATA'
*.db_domain=''
*.db_files=500
*.db_name='[REDACTED]'
*.db_securefile='ALWAYS'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=[REDACTED]XDB)'
[REDACTED]2.instance_number=2
[REDACTED]1.instance_number=1
*.memory_max_target=42949672960
*.memory_target=0
*.open_cursors=300
*.processes=5000
*.remote_listener='[REDACTED]:1521'
*.remote_login_passwordfile='exclusive'
*.sessions=7536
[REDACTED]2.thread=2
[REDACTED]1.thread=1
*.timed_statistics=TRUE
[REDACTED]1.undo_tablespace='UNDOTBS1'
[REDACTED]2.undo_tablespace='UNDOTBS2'
SPFILE='[REDACTED]' # line added by Agent
Two notes on the pfile: First, I've added the line breaks for readability. They don't exist in the actual file. Second, no, I don't know why the two instances have different memory settings. It was apparently done many months ago, and none of the Test DBAs remember who did it or why. Presumably it was a bit of on-the-fly tuning the last time this database was used heavily.
Finally, I have done the SPFILE create noted by the previous thread, for no help:
[oracle@[HOST] dbs]$ env ORACLE_SID=[REDACTED]1 sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Mar 6 09:35:48 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile='/u01/app/oracle/product/11.2.0.2/dbhome_1/dbs/init[REDACTED]1.ora';
SQL> startup;
ORA-00371: not enough shared pool memory, should be atleast 1439485132 bytes
What have I missed?
Thanks!
David
Edited by: dafydd on Mar 6, 2012 9:43 AM - Adapted to the broken link generator.