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