database shut down error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: database shut down error

  1. #1
    Join Date
    Jun 2007
    Posts
    29

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    sounds like a data dictionary issue.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2007
    Location
    İstanbul/Turkey
    Posts
    25
    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

  4. #4
    Join Date
    Jun 2007
    Posts
    29
    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

  5. #5
    Join Date
    Jun 2007
    Location
    İstanbul/Turkey
    Posts
    25
    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

  6. #6
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650

    Typo - Correct it

    SQL>@standard.sql

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

  7. #7
    Join Date
    Jun 2007
    Posts
    29
    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.

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    was that during the upgrade - after, what?

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

  9. #9
    Join Date
    Jun 2007
    Posts
    29
    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.

  10. #10
    Join Date
    Jun 2007
    Posts
    29
    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
  •  



Click Here to Expand Forum to Full Width