ORacle

ORACLE DATABASE IS DOWN,INSTENCE DOWN HOW TO START
IMG_20180223_152323_HDRorlc
IMG_20180223_152257_HDR1
venkata s  s sharma AradhyulaSr. system administratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
slightwv (䄆 Netminder) Commented:
Log into the physical server.  Go to Windows Services and stop and start the OracleServiceORCL service.

If that fails to startup the instance, check the alert log for the reasons.

I forget the exact path in Windows but somewhere under D:\app\Administrator there should be a diag/rdbms/ORCL/ORCL/trace folder

In there look for a file alertORCL.log.  Go to the end and look for errors.
0
 
Mark GeerlingsDatabase AdministratorCommented:
If you can't easily find the alertORCL.log file, check for any physical problems in the server, including:
1. failed disk drive
2. network interface problems
3. disk full
4. storage system (NAS, SAN, etc.) problems.

Figure out where the alert*.log file is for your database.  Whenever something goes wrong in Oracle, you should check that first.  It will usually contain the actual error, or a clue to the problem (unless the disk this file is on fails or gets full, or if the connection to this disk is not working)
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.