-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|