DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-06512: at line 2( This error is coming every time when the database is started)

  1. #1
    Join Date
    Apr 2002
    Posts
    291

    ORA-06512: at line 2( This error is coming every time when the database is started)

    Dear Gurus,
    Please Do not close this thread as a duplicateone,I forgot to post my error message in my previous thread so i'm posting here it again in a new thread.

    I'm running with oracle 8.1.7 on Linux 6.2. When ever my database is re-started,i'm getting the following errors in the alert.log. My shared_poolsize is 60MB and my shared_pool_reserved_size is 6MB.
    My total database size is 57Gigs.

    Here is the error message in the alert.log file:

    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","java/lang/StringSYS","joxlod: in ehe",
    "ioc_allocate_pal")
    ORA-06512: at "SYS.DBMS_JAVA", line 0
    ORA-06512: at line 2( This error is coming every time when the database is started)

    The output of sho sga:

    Total System Global Area 921673712 bytes
    Fixed Size 69616 bytes
    Variable Size 81915904 bytes
    Database Buffers 838860800 bytes
    Redo Buffers 827392 bytes

    Can any help me out here , please...

    Thanks in advance....
    PNRDBA

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore
    Posts
    52
    Hi.

    Looks like one on database start trigger is failing because it is unable to allocate enough memory in JAVA POOL.

    Have you set JAVA_POOL param ?

    Joe
    Regards

    Joe

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