Good Morning,
We upgraded our backend DB from Oracle 11g to 12c approximately 3 weeks ago. There have been no issues and we are shooting to do the same upgrade this coming weekend.
I did some further digging to ensure everything has been functioning as normal and noticed 2 WPs had randomly crashed at different times in the last 10 days. They came back online within seconds, so the system did what it was supposed to do, but it was just very odd and random.
When I look at the crash, all events before the crash were operating as usual and this is what's in the logs before the dmp file was created and the WP cycled itself:
20180901/125526.675 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 163ccf10 DB-HDBC: 16417848
20180901/125526.675 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
20180901/125526.675 - U00003592 UCUDB - Status: '' Native error: '3135' Msg: 'ORA-03135: connection lost contact
Process ID: 31680
Session ID: 214 Serial number: 22404'
20180901/125526.675 - U00003536 UCUDB: FATAL DATA BASE ERROR: Re-connection will be attempted in 10 seconds.
20180901/125526.675 - U00003537 UCUDB - RECONNECT: DB call 'OCITransRollback': Return code: '-1'.
20180901/125526.675 - U00003590 UCUDB - DB error: 'OCITransRollback', 'ERROR ', '', 'ORA-03114: not connected to ORACLE'
20180901/125526.675 - U00003592 UCUDB - Status: '' Native error: '3114' Msg: 'ORA-03114: not connected to ORACLE'
20180901/125526.737 - U00003538 UCUDB: Re-connection to database successful. Processing will continue.
20180901/125526.753 - U00000006 DEADLOCK
I asked our DBAs to cross reference the logs on the DB server for any errors on our DEV DB at those times and there are no errors. Now, it is of course DEV so could have been a temporary communication issue, but just wondering if anyone else has come across this before when moving from 11g to 12c, or even those who may already be on 12c.
Our current version of Automic is 11.2.6FH1 and we are running on Windows 2012R2 with Oracle backend.
Thanks!!
Tina