sqlplus: not enough shared pool memory, should be atleast 62198988 bytes
596314Sep 21 2007 — edited Sep 24 2007Hi,
Logged in to sqlplus -L /nolog with an idle instance. Couldn't do a startup (immediate option doesn't work in xe) because it complained that it couldn't fine the initORCL.ora parameter file in $ORACLE_HOME/dbs. Only the following files are located in $ORACLE_HOME/dbs:
oracle@oxygen:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs> ll
total 40
-rw-rw---- 1 oracle dba 1544 2007-09-21 08:31 hc_XE.dat
-r-xr-xr-x 1 oracle dba 8385 2006-01-30 04:59 init.ora
-r-xr-xr-x 1 oracle dba 8385 2006-01-30 04:59 initORCL.ora
-rw-rw---- 1 oracle dba 24 2007-09-18 18:55 lkXE
-rw-r----- 1 oracle users 1536 2007-09-18 18:55
initORCL.ora wasn't in there so I copied init.ora to initORCL.ora so see what would happen the next time I logged in to sqlplus. So the next time I logged in, I got the ORA00371 error:
oracle@oxygen:~> sqlplus -L /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 21 10:52:07 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
@ >connect / as sysdba
Connected to an idle instance.
SYS@ORCL >startup
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes
Obviously, I shouldn't have copied init.ora to initORCL.ora.
I know that from this error I need to set DB_HANDLES to at least 62198988. But why is initORCL.ora missing from the dbs subdirectory, and what should I do to workaround it?
Thanks.
Robert A G Cook
OCA
Message was edited by:
user593311
Message was edited by:
user593311
Message was edited by:
user593311
Message was edited by:
Robert A G