Remedy - Server - AR Server does not start due to SQL failure

Knowledge Article

Article Number

000258474

Old Article Number

000038625

Article Type

Solutions to a Product Problem

Title

Remedy - Server - AR Server does not start due to SQL failure

Summary

AR Server does not start due to SQL failure.

Product

Remedy AR System Server

Component

AR System Server

Applies to

BMC Remedy AR System Server 7.6.04

Problem

AR Server does not start due to SQL failure.

Oracle 11g r2 RAC Database

Cause

Solution

This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

Legacy ID:KA371631

AR Server does not start if the database is not running. Below is the typical SQL failure which can be seen in arerror log. (DB is Oracle)

The SQL database operation failed. (ARERR 552)
ORA-03113: end-of-file on communication channel
SQL database is still not available -- continuing to attempt connection (ARNOTE 591)
ORA-03113: end-of-file on communication channel

Attachment(s):