-
Hallo,
there is a Oracle 9i data base running on a Linux plattform. My Oracle 9i client is on a seperat node running on windows 2000 plattform.
So, and now my problem:
When I tried last time to connect to the database server I got the following error message:
ORA-00604: orror occurred at recursive SQL level 2
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","TRIGGERS$","sga heap","state objects")
If I remember right, I finished my last telnet session (and than working with svrmgrl) to the server database not correctly. Could that be the reason? And, what could do to solve the problem?
Thank you in advance!
Christian
-
that means your shared pool is fragmentated, normally this happens quite often with MTS and not using large pool
-
Increase the shared_pool_size.
If the amount of free memory is less (< 5mb) for shared pool then must increase. (check v$sgastat). So also for the large pool.
HTH.
[Edited by ggnanaraj on 07-26-2002 at 04:53 AM]
-
As of now, issue
Alter System Flush Shared Pool;
-
As far as I know this is a bug and the workaround is to set _db_handles_cached = 0
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
a bug in 9.0.1.3.0 or 9.2.0.1?
-
It seems to be a bug....
shared_pool_size = 81457280
large_pool_size = 8014400
My personal problem now is, that I do not know the pwd of internal ... no connection (sys, system) is possible... so it seems that I can not reboot the database to change the init.ora parameter...
Christian
-
to start with we dont have internal in 9i
it´s sqlplus "/ as sysdba"
-
Originally posted by pando
a bug in 9.0.1.3.0 or 9.2.0.1?
8.1.7. I thought it was fixed in 9i. Don't know...
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Originally posted by pando
to start with we dont have internal in 9i
it´s sqlplus "/ as sysdba"
It is two weeks ago I started with 9i ... Sorry for that question ;>
Christian
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
|