Home » Server Options » RAC & Failsafe » Oracle Service gets Stopped (windows 2012, oracle 12c)
Oracle Service gets Stopped [message #639905] Mon, 20 July 2015 05:01 Go to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi All,

Kindly guide me,

One of our Production DB's oracle instance service gets stopped automatically, hence DB shutdown. None of other services are facing problem.
In alert log file, there is no intimation about the service stopped.

Kindly suggest.
Muktha
Re: Oracle Service gets Stopped [message #639910 is a reply to message #639905] Mon, 20 July 2015 05:04 Go to previous messageGo to next message
Michel Cadot
Messages: 66636
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Check Windows event log.

Re: Oracle Service gets Stopped [message #639912 is a reply to message #639905] Mon, 20 July 2015 05:22 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
How often does this happen?
Re: Oracle Service gets Stopped [message #639916 is a reply to message #639912] Mon, 20 July 2015 05:47 Go to previous messageGo to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi,

In the windows event log, it shows the below error message.
In this server it is first time occurring.

Oracle Fail Safe Resource *** failed to complete IsAlive poll within timeout interval.


Regards
Muktha
Re: Oracle Service gets Stopped [message #639921 is a reply to message #639916] Mon, 20 July 2015 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 66636
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Ah! You didn't say you were on RAC and use Fail Safe!
Don't you think it'd be important to mention your special configuration.

Check its logs.

Re: Oracle Service gets Stopped [message #640148 is a reply to message #639921] Thu, 23 July 2015 01:29 Go to previous message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi Michel,

Sorry for the delayed reply.

We are not using RAC.

We just have the FAILSAFE with 2 servers.

We have found the issue:
------------------------
1) There is a mechanism called ISACTIVE in windows, which was disabled, but still it got triggered and enabled automatically.
2) The reason for is, heavy load of activities taken place in DB.
3) Where the node should supposed to be shifted automatically, but we had disable the option of node shifting automatically.

Which was the reason, the server were stopped, as it couldn't shift the node.

Thanks for the help.

Regards
Muktha
Previous Topic: Convert Non RAC To RAC
Next Topic: RAC v. Data Guard (split from http://www.orafaq.com/forum/mv/msg/197950/639911/#msg_639911)
Goto Forum:
  


Current Time: Mon Oct 14 15:55:55 CDT 2019