-
Ora-01034
Hi all,
Most of the answers I see about this problem is related to starting an instance. How do you fix this problem when CREATING an instance from dbassist.
I try to create a new instance, and I get the ORA-01034 error.
I tried more SGA space, still get the error.
What other things should I be looking at?
Thanks
-
What Platform/RDBMS Version?
-
OOPS Sorry about that
Oracle 8.1.7 on HP-UX
-
Have you made the required changes to the /etc/system file? Also this error can also occur if your host name is larger than 8 characters in /etc/hosts
The error refers to the fact that the SGA cannot fit into the allocated memory so if you increase the size of the SGA your just making the problem worst. Try it with a smaller SGA size
Regards
-
Thanks for your help Jim.
What changes should I be doing to /etc/system file?
I am a UNIX newbie, so I am not sure of what I am supposed to do.
Thanks
-
You'll need to review the chapter 2 of the HP-UX Oracle Installation guide:
http://download.oracle.com/docs/pdf/A85470_01.pdf
Regards
-
/etc/system is for solaris.
For HP you will need to use SAM to make changes to the kernel...that is what you are looking at. SU to root and call up sam. Take a look at all of the parameters that oracle needs to run (like SHMMAX, NPROC, NFILE, etc.) and make sure that they are more than what Oracle suggests in the installation guide.
But, like jovery said, try it with the shared_pool_size and db_block_buffers a little smaller first just to make sure that that is what is happening - that there is not enought memory allocated for oracle to start. Other possible things may be corrupted memory segments, zombie processes chewing up the allocated memory, etc. If you are not sure about these other things that are OS related then check with the sys admin on that. Also make sure that you have enough swap too.
hoh
-
Hi,
I have tweaked my parameters downwards and things are now working.
Thanks for your help.
Denis