| ora-00604 and ora-04031 [message #63077] |
Wed, 08 September 2004 01:26  |
James
Messages: 120
Registered: June 2000
|
Senior Member |
|
|
Hello
I have installed oracle 9 under a solaris 8i , all is ok
i can connect with the command sqlplus ....
but after restarting my system i restart my DB with the command dbstart but i have two errors :
ORA-00604: error occured at recursive sql level 1
ORA-04031: unable to allocate 664 bytes to shared memory shared pool
Can you help me please????
thanks
|
|
|
|
| Re: ora-00604 and ora-04031 [message #63080 is a reply to message #63077] |
Wed, 08 September 2004 02:29  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
What is the size of your shared pool. There can be multiple causes for ORA-4031 but in your case it seems that you have not assigned enough space to your shared pool.
Just give us the details of your memory allocation so that we can decide.
Daljit Singh.
|
|
|
|
|
|
|
|
| Re: ora-00604 and ora-04031 [message #63083 is a reply to message #63082] |
Wed, 08 September 2004 06:06 |
James
Messages: 120
Registered: June 2000
|
Senior Member |
|
|
Hello
i have increased the value of my shared pool
when i start my db i have three messages:
ORA-00202: controlfile: 'ora_control1'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
can you tell me more please????
|
|
|
|
| Re: ora-00604 and ora-04031 [message #63086 is a reply to message #63083] |
Wed, 08 September 2004 20:06 |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Check parameter control_files in your startup file, and verify all the files mentioned in that parameter are persent in your system. If not then shutdown the database and copy any available file to all the destinations.
Daljit Singh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
