Home » RDBMS Server » Server Administration » ora-00604 and ora-04031
ora-00604 and ora-04031 [message #62766] Thu, 12 August 2004 04:51 Go to next message
James
Messages: 120
Registered: June 2000
Senior Member
Hello
I have installed oracle9i server under a sun solaris 8
and everything is ok (i can connect to the database with sqlplus qnd i create a new user)
but when i restart my system, i restart my database with the dbstart command then i have those errors:
ora-00604=error occured at recursive sql level
ora-04031=unable to allocate 664bytes of shared memory(shard pool........)
can you help me please because i am newbie
thanks

Report message to a moderator

Re: ora-00604 and ora-04031 [message #62786 is a reply to message #62766] Fri, 13 August 2004 06:33 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

Try to increase your SHARED_POOL value in the database's parameter file (INIT.ORA or SPFILE) and restart the database.

Best regards.

Frank

Report message to a moderator

Previous Topic: Oracle into SQL Server 2000
Next Topic: Transaction
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 14:22:53 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.