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
Categories: ORA errors
Sustain the great work and generating the crowd!
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
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!
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!
Wow! In the end I got a weblog from where I be capable of actually take valuable
facts concerning my study and knowledge.
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!
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!
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.
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!