OraFAQ Forum: Windows » Server Reboot not making DB ON.

Home » Infrastructure » Windows » Server Reboot not making DB ON. (oracle 12c Windows 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Server Reboot not making DB ON. [message #670600]

Mon, 16 July 2018 06:14

muthukrish104
Messages: 73
Registered: November 2017

Member

Hi All,

Whenever my UAT DB server get restarted only the instance get start and running but not the DB get opened.
Wondering why.

Kindly suggest.

Here is the current setup.

HKLM/software/oracle/key_ora_home_name/ora_oracle_sid_autostart ---- TRUE
HKLM/software/oracle/key_ora_home_name/ora_oracle_sid_shutdown ---- TRUE

SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)

Thanks and Regards
M.Krish

Report message to a moderator

Re: Server Reboot not making DB ON. [message #670608 is a reply to message #670600]

Mon, 16 July 2018 10:27

Michel Cadot
Messages: 67476
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Have a look at alert.log file.

Report message to a moderator

Re: Server Reboot not making DB ON. [message #670636 is a reply to message #670600]

Tue, 17 July 2018 06:45

gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK

Senior Member

Report message to a moderator

Re: Server Reboot not making DB ON. [message #670709 is a reply to message #670636]

Mon, 23 July 2018 00:27

muthukrish104
Messages: 73
Registered: November 2017

Member

Hi Gazzag,

Thanks for the reply.

I couldn't recollect, so now I have edited and modified it.

But, is there any way to check the existing settings?

Regards
M.Krish

Report message to a moderator

Re: Server Reboot not making DB ON. [message #670711 is a reply to message #670709]

Mon, 23 July 2018 00:35

Michel Cadot
Messages: 67476
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So you don't want I answer you.

Report message to a moderator

Re: Server Reboot not making DB ON. [message #670715 is a reply to message #670709]

Mon, 23 July 2018 03:06

gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK

Senior Member

I don't know, off-hand. I suspect that the seetings are in the registry somewhere.

Did it resolve your issue?

Report message to a moderator

Re: Server Reboot not making DB ON. [message #670716 is a reply to message #670711]

Mon, 23 July 2018 03:07

gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK

Senior Member

How is OP supposed to answer "Have a look at alert.log file"? Confused

[Updated on: Mon, 23 July 2018 03:08]

Report message to a moderator

Re: Server Reboot not making DB ON. [message #670718 is a reply to message #670716]

Mon, 23 July 2018 03:25

Michel Cadot
Messages: 67476
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If he does not know he can ask but maybe opening the alert.log with notepad and possibly posting the abstract around the time of the startup. Smile

But my post was about him just addressing you.

Report message to a moderator

Re: Server Reboot not making DB ON. [message #670721 is a reply to message #670718]

Mon, 23 July 2018 05:58

muthukrish104
Messages: 73
Registered: November 2017

Member

Hi Michel,

Sorry I missed your name.

When I seen Gazzag post, immediatley I realized, that I may not have done it in ORADIM.

So, I went ahead.

Thanks and regards
M.Krish

Report message to a moderator