-
database shut down error
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
-
sounds like a data dictionary issue.
Jeff Hunter
-
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
-
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
-
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
-
Typo - Correct it
SQL>@standard.sql
seyiisq, open the trace file and read for further errors.
-
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
Last edited by seyiisq; 06-14-2007 at 11:46 AM.
-
was that during the upgrade - after, what?
did you follow the upgrade instructions about setting shared pool (probably not)
-
all i did was
i was able to login as '/ sysdba'
ALTER SYSTEM SET sessions = 1000 SCOPE=SPFILE;
it all worked fine yesternight.
Last edited by seyiisq; 06-14-2007 at 12:40 PM.
-
done it
i had to reset it back to 170 and it worked
alter system set sessions = 170 scope = spfile;
thanks for your support
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|