Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12c - increasing number of automatic restarts for OBIS service
Hi All,
OBIS service in my installation of OBIEE 12c sometime fails and automatically tries to start up but only 2 times. From time to time it manages to go up at first or second attempt but unfortunately most of the time it is not enough. Is is possible to increase the number of auto-restart attempts?
The only thing i could find is
AUTOMATIC_RESTART = YES;
in NQSConfig.INI.
Regards,
Piotr
Answers
-
My suggestion would be to actually identify the root cause behind the obis crashes.Have you looked at what may be causing these crashes?
0 -
+1 to Joel. What's the root cause?
What do the log files say?
Are there core dumps?
etc. etc. etc.
0 -
That is the plan, but in the meantime I need to get the environment available and semi-stable at least.
The cause of the crashes seems to be this:
------------- log ----------------
[2019-08-05T23:55:19.529+02:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: 005ZqMkfYBk1vXaj9L6iKD0004U4004j2f,0] [sik: ssi] [tid: eb37700] [55005] The cache polling delete statement failed for table .....
[2019-08-05T23:55:19.529+02:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: 005ZqMkfYBk1vXaj9L6iKD0004U4004j2f,0] [sik: ssi] [tid: eb37700] [55005] The cache polling delete statement failed for table
0 -
In order for us to be able to help you, please post that in your initial question next time. We can't see your system or read your log files
0 -
Hi Christian,
But going back to my initial question - is there a way to increase number of automatic restarts for OBIS?
Regards,
Piotr
0 -
That's pretty much attacking the problem from the wrong end. Beating a dead horse 5 times instead of 2 won't make it magically well again.
I have systems which are running without a single restart. It isn't supposed to fail at all
What is going wrong and why. That's important. If you want you can always schedule a graceful shutdown and startup nightly with a cronjob and the stop/start commands.
0 -
