Ora-01034
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Ora-01034

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    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

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    What Platform/RDBMS Version?
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Mar 2001
    Posts
    82
    OOPS Sorry about that

    Oracle 8.1.7 on HP-UX

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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
    Last edited by jovery; 11-21-2002 at 10:42 AM.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Mar 2001
    Posts
    82
    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

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  7. #7
    Join Date
    Dec 2000
    Posts
    8
    /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

  8. #8
    Join Date
    Mar 2001
    Posts
    82
    Hi,

    I have tweaked my parameters downwards and things are now working.

    Thanks for your help.

    Denis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width