Symptom
After restarting the database, primary ASE indicate Standby Mode and cannot logon to force it to Primary.
cannot logon through isql using users "sa", "sapsa", "DR_admin" or "sapsso" with message:
Login failed. Adaptive Server is running in 'Standby' mode. You do not have the
necessary role or privilege to login while the server is running in this mode
and login redirection cannot occur since there is no Active Primary.
From ASE errorlog:
background task error 968: Database 'database 'master' (1)' is not upgraded and hence is not available for access. Please retry your query after database has been upgraded.
background task error 4001: Cannot open default database 'master'.
background task error 968: Database 'database 'master' (1)' is not upgraded and hence is not available for access. Please retry your query after database has been upgraded.
background task error 4002: Login failed.
remote HADR server XXXXXX is UNREACHABLE
local server is now Standby
Read more...
Environment
Adaptive Server Enterprise/16.0 SP04 PL01 HF2/EBF 30225 SMP/P/AMD64/Windows 2012 R2/ase160sp04pl01x/0/64-bit/FBO/Thu Feb 10 01:08:49 2022
Product
Keywords
KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.