Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 52 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI 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 -
