database shut down error

[seyiisq]

i tried shutting down my database with 'shutdown immediate' command but i had the error below in my alert file

Wed Jun 13 23:16:49 2007
Errors in file c:\oracle\product\10.1.0\admin\orcl_1\bdump\orcl1_m001_3872.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-213: package STANDARD not accessible

Wed Jun 13 23:19:43 2007
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

pls can you help

[marist89]

sounds like a data dictionary issue.

[Balki]

According to your errors,maybe this can help,
before shutdown connect to the database from sqlplus as sys .And then run the script "standart.sql"
Maybe the standart package is invalid.But according to this idea,you should get these errors anytime in the alert log ,not only when you shutdown the database.So check for more errors in the alert.log and lets see if it helps

[seyiisq]

SQL> conn / as sysdba
Connected to an idle instance.
SQL> @standart.sql;
SP2-0310: unable to open file "standart.sql"
SQL>
I tried the above and got the error as shown. in my alert log file
I got this error


Errors in file c:\oracle\product\10.1.0\admin\orcl_1\bdump\orcl1_m000_1412.trc:
ORA-00018: maximum number of sessions exceeded
pls can you help

[Balki]

find the directory where standart.sql is located,
usually,
$ORACLE_HOME/rdbms/admin

then go to the directory where standart.sql is located.
when you re in the directory ,
do these steps
-sqlplus "/as sysdba"
-SQL>startup mount
-SQL>@standart.sql

[dbasan]

SQL>@standard.sql

seyiisq, open the trace file and read for further errors.

[seyiisq]

after checkin my trace file i got the following error


SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select f.file#, f.block#, f....","Typecheck heap","kgghteInit")
*** 2007-06-14 16:38:10.734
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select f.file#, f.block#, f....","Typecheck heap","kgghteInit")

pls can you help

[davey23uk]

was that during the upgrade - after, what?

did you follow the upgrade instructions about setting shared pool (probably not)

[seyiisq]

all i did was

i was able to login as '/ sysdba'


ALTER SYSTEM SET sessions = 1000 SCOPE=SPFILE;

it all worked fine yesternight.

[seyiisq]

done it
i had to reset it back to 170 and it worked
alter system set sessions = 170 scope = spfile;
thanks for your support