DBCA failing with ORA-01034

I faced this issue while creating database using DBCA in one of the UAT database server. Issue was with just DBCA , I was able to create database manually without any issues.

Each attempt of creating database with DBCA utility was failing with ORA-01034: ORACLE not available.

After putting lots of efforts, I started concentrating on error itself ORA-01034: ORACLE not available. 

What is the possibility of getting ORA-01034 in normal scneario:

  •  Database is down & u r trying execute some sql statement on it

Simple… I am creating my database, means database is not open, & what is the possibility of someone executing any query on my database….

one and only glogin.sql is the culprit.

What Oracle documentation says about glogin.sql

There’s a script in ORACLE_HOME/sqlplus/admin which is called glogin.sql.  This script is automatically run when the user starts SQL*PLUS or uses the Connect command, hence any command added to it will be executed. 

I found following sql was present in glogin.sql:

select name,open_mode from v$database;

After removing all entries from glogin.sql, I was able to create database using DBCA without issues.

..

Hope so this post will be useful for u 🙂

Cheers

Regards,

Adityanath

 

 

 

Advertisements

6 thoughts on “DBCA failing with ORA-01034

  1. I used to be suggested this website by means of my cousin. I am not certain whether or not this submit is written by
    way of him as nobody else know such specified approximately
    my problem. You’re incredible! Thank you!

  2. This is a great tip particularly to those new to the blogosphere.
    Short but very precise information… Appreciate your sharing this one.
    A must read article!

  3. Wow! In the end I got a weblog from where I be capable of actually take valuable
    facts concerning my study and knowledge.

  4. Pretty great post. I just stumbled upon your weblog and wished to say that I have really enjoyed
    surfing around your weblog posts. In any case I will be subscribing to
    your rss feed and I hope you write again soon!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s