SAP Knowledge Base Article - Preview

3027785 - SYB: The database requires DBA interaction - SAP ASE

Symptom

1. Command 'saphostctrl -function ListDatabases' shows following error:

Component name: Database (SYBASE Server Database), Status: Error (The database requires DBA interaction.)  

2. Enable trace level 3 for SAP Host Agent, trace log /usr/sap/hostctrl/work/dev_sapdbctrl shows following messages,

[PID 841] ERROR AT sybOpenClient.cpp:executeQuery:2183 TIME: **** DESCRIPTION: Server message: Number 208, Severity 16, State 1, Line 2, Server * --- Message string: dbname..sapsa_alive_chk not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).  LAST OS-ERROR: (0) : Success
[PID 841] ERROR AT sybServer.cpp:getDatabaseStatus:32782 TIME: **** DESCRIPTION: SAPSA user 'sapsa' failed to interact with the database (delete/insert) LAST OS-ERROR: (0) : Success


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

DBA interaction, saphostctrl, sapsa_alive_chk, dev_sapdbctrl , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.