web analytics

ASM Error and ORA-1092 During DBCA

Both errors happen to me when I want to create Oracle Database 10.2.0.4 using ASM on RHEL5 i686 (32-bit).

All process during ASM Creation was happen smoothly without any complaint and any error.

Then, after ASM creation completed, and new database creation process started. The process stuck whenever I want to enter ASM password, an error occur:

dbca-error-asm

Password cannot be verified because io exception: The Network Adapter could not establish te connection.

Solution:

Take a deep breath, make a wish, light up a cigarette and yeah…got the idea….owh, my listener not started. Hahaha..

Then configure the listener using Net Configuration Assistant (netca) or whatever tools you like, start the listener and there are no “password cannot verified” error.

Ok, solved a problem and then the next problem happen during DBCA when the progress bar reach 42%.

dbca-error1

ORA-01092:  ORACLE instance terminated. Disconnection forced.

Ok, I’ve no idea at first, what is this ORA-01092 error about. After checked the alert log, there are the error:

ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

ORA-00313: open failed for members of log group 1 of thread 1 DBCA

Then found in metalink about this error (ID 859663.1).

Solutions

Option 1.

Use Custom database template instead of General Purpose or Transaction Processing Template.

dbca-custom

This happen IF patch set has applied before database creation and Pre-existing Datafiles are not “upgraded” during the patch bundle/patch set installation.

Incase the following error happen:

dbca-error2

Refer to my older post HERE

Option 2.

Uninstall everything, do fresh installation WITHOUT patch first. Create ASM and Database, then apply patch set installation.


Blog Widget by LinkWithin

database error, linux, Oracle, Red Hat Enterprise Linux 5, RHEL5, Technology Linux Tips, Oracle, Software, Technology

2 comments on “ASM Error and ORA-1092 During DBCA

  1. Mohammed Fayum on said:

    Salaam Vale Kumm
    Faiz Bhai,

    Good job !! Only one solution to your problem is that please quit smoking. Your only burning your money and health :)
    I’m sorry if you dont like my suggestion and if you think I’m being personal, but just wanted to share my experience as I have already quit smoking.

    Allah Bless you.

    Allah Hafiz

    Mohammed Fayum
    Senior Oracle DBA, London

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Password Reset

Please enter your e-mail address. You will receive a new password via e-mail.