DBCA failing with ORA-01034

Published on

June 2, 2014

3,507 hits

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 scenario:

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

9 responses to “DBCA failing with ORA-01034”

lfwusmuqorf

May 24, 2016

Sustain the great work and generating the crowd!

Reply
1. Adityanath Dewoolkar
  
  May 24, 2016
  
  Thanks for visiting and appreciate your feedback.:-)
  
  Regards,
  Adi
  
  Reply
Anonymous

August 15, 2018

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!

Reply
Anonymous

August 15, 2018

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!

Reply
Anonymous

August 15, 2018

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

Reply
Anonymous

August 17, 2018

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!

Reply
Anonymous

February 22, 2019

Thanks for the marvelous posting! I certainly enjoyed reading it,
you could be a great author.I will make certain to bookmark your
blog and will come back in the foreseeable future.
I want to encourage one to continue your great job, have a
nice evening!

Reply
Fallon

August 20, 2021

Generally I don’t read article on blogs, however I would like to say that this write-up
very forced me to check out and do it! Your writing style has been amazed me.

Thanks, very great post.

Reply
Amy

August 24, 2021

This is a great tip particularly to those new to the
blogosphere. Short but very accurate information… Thank you
for sharing this one. A must read post!

Reply