Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

checkdb fail in DB13 : BR0301E SQL error -942 at location db_connect-5, SQL statement

Windows Server 2008

Oracle 10.2.0.4

Netweaver 7.0 EHP1

Hi,

I got the following error when I run checkdb on DB13  in an environment PID :

BR0801I BRCONNECT 7.00 (40)

BR0805I Start of BRCONNECT processing: celyvkqi.chk 2013-08-28 11.59.04

BR0484I BRCONNECT log file: E:\oracle\PID\sapcheck\celyvkqi.chk

BR0280I BRCONNECT time stamp: 2013-08-28 11.59.17

BR0301E SQL error -942 at location db_connect-5, SQL statement:

'SELECT NAME FROM V$DATABASE WHERE ROWNUM = 1'

ORA-00942: table or view does not exist

BR0310E Connect to database instance PID failed

BR0280I BRCONNECT time stamp: 2013-08-28 11.59.17

BR0301W SQL error -942 at location brc_dblog_open-1, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20130828115904', 'chk', 'PID', 'DATABASE', '9999', ' ', 'celyvkqi', '7.00 (40) JID=CHECK20130828115858')'

ORA-00942: table or view does not exist

BR0324W Insertion of database log header failed

BR0806I End of BRCONNECT processing: celyvkqi.chk 2013-08-28 11.59.17

BR0280I BRCONNECT time stamp: 2013-08-28 11.59.17

BR0804I BRCONNECT terminated with errors

I checked initPID.sap, initPID.ora, sapnotes 400241, 562863, 662644.

I performed the General checks  in note 400241, successfully.

I have another environment with the same settings and checkdb is running successfully.

I thought I'd run sapdba_role again, but not sure if it's a good idea.

best regards

Former Member
Not what you were looking for? View more on this topic or Ask a question