Home » Infrastructure » Windows » Server Reboot not making DB ON. (oracle 12c Windows 2012)
Server Reboot not making DB ON. [message #670600] Mon, 16 July 2018 06:14 Go to next message
muthukrish104
Messages: 68
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
Re: Server Reboot not making DB ON. [message #670608 is a reply to message #670600] Mon, 16 July 2018 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 66192
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at alert.log file.

Re: Server Reboot not making DB ON. [message #670636 is a reply to message #670600] Tue, 17 July 2018 06:45 Go to previous messageGo to next message
gazzag
Messages: 1062
Registered: November 2010
Location: Bristol, UK
Senior Member
Are you sure you've configured both the service and the database to start?

oradim [-NEW -SID SID] | -SRVC service_name | -ASMSID SID | -ASMSRVC service_name
[-SYSPWD password][-MAXUSERS number][-STARTMODE auto | manual] [-SRVCSTART system | demand]
[-PFILE filename | -SPFILE] [-SHUTMODE normal | immediate | abort] [-TIMEOUT
secs] [-RUNAS osusr[/ospass]]
Re: Server Reboot not making DB ON. [message #670709 is a reply to message #670636] Mon, 23 July 2018 00:27 Go to previous messageGo to next message
muthukrish104
Messages: 68
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
Re: Server Reboot not making DB ON. [message #670711 is a reply to message #670709] Mon, 23 July 2018 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 66192
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So you don't want I answer you.

Re: Server Reboot not making DB ON. [message #670715 is a reply to message #670709] Mon, 23 July 2018 03:06 Go to previous messageGo to next message
gazzag
Messages: 1062
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?
Re: Server Reboot not making DB ON. [message #670716 is a reply to message #670711] Mon, 23 July 2018 03:07 Go to previous messageGo to next message
gazzag
Messages: 1062
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66192
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.

Re: Server Reboot not making DB ON. [message #670721 is a reply to message #670718] Mon, 23 July 2018 05:58 Go to previous messageGo to next message
muthukrish104
Messages: 68
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
Re: Server Reboot not making DB ON. [message #670723 is a reply to message #670715] Mon, 23 July 2018 06:13 Go to previous messageGo to next message
gazzag
Messages: 1062
Registered: November 2010
Location: Bristol, UK
Senior Member
gazzag wrote on Mon, 23 July 2018 09:06

Did it resolve your issue?
Re: Server Reboot not making DB ON. [message #670742 is a reply to message #670723] Tue, 24 July 2018 00:30 Go to previous message
muthukrish104
Messages: 68
Registered: November 2017
Member
Hi Gazzag,

I have changed the oradim entries.
Yet to restart the server.

Thanks and Regards
M.Krish
Previous Topic: Problem with sequences
Next Topic: Create Directory Oracle 9i
Goto Forum:
  


Current Time: Tue Feb 19 19:56:46 CST 2019