table DBCHECKORA does not exist on JAVA stack

[former_member204746]

Hi,

my config:

windows 2003

Oracle 10.2.0.2

Netweaver 7.0 SR2 java stack only (patched to SP16)

I am using this command:

brconnect -c -u / -f check

I get this error:

BR0970W Database administration alert - level: ERROR, type: NOARCHIVELOG_MODE, object: NWD

So, This means that my system is in no_archive mode, which is OK becasue that`s what I want as this is just a sandbox system. In an ABAP stack, I would go into DB17 and change this value... or, at DB level, I can maintain table DBCHECKORA. This table does not exist on my system.

So, to troubleshoot thism, I have set BR_TRACE to level 15 and ran BRCONNECT, I get this interesting bit:

BR0966I Table DBCHECKORA not found or empty - using default settings for checks

So, this is what I expected, this table does not exist in my SAPSR3DB schema.

So, what should I do?

Create this table manually and insert wanted values?

Has anyone else hit this problem?

[Former Member · Accepted solution]

Have a look at SAP note 892294.

[former_member204746 · Accepted solution]

thanks for the quick reply.

This SAP note resolved my issue.

I added these lines in my init[SID].sap file:

check_cond = (

"DBA:ARCHIVER_STUCK:Y:W:>:90:P:",

"DBA:CONTROL_FILE_MIRROR:Y:E::::",

"DBA:CONTROL_FILE_MISSING:Y:E::::",

"DBA:CRITICAL_FILE:Y:W::::",

"DBA:CRITICAL_SEGMENT:Y:W:<=:2::",

"DBA:CRITICAL_TABLESPACE:Y:W::::",

"DBA:DATA_FILE_MISMATCH:Y:E::::",

"DBA:DATA_FILE_MISSING:Y:E::::",

"DBA:FILE_OFFLINE:Y:E::::",

"DBA:FILE_SYSTEM_FULL:Y:W:>:99:P:",

"DBA:HARMFUL_STATISTICS:Y:E::::",

"DBA:INVALID_FILE_TYPE:Y:E::::",

"DBA:IN_WRONG_TABLESPACE:Y:W::::",

"DBA:MISSING_INDEX:Y:E::::",

"DBA:MISSING_STATISTICS:Y:E::::",

"DBA:NOARCHIVELOG_MODE:N:E::::",

"DBA:PCTINCREASE_NOT_ZERO:Y:W::::",

"DBA:REDOLOG_FILE_MIRROR:Y:E::::",

"DBA:REDOLOG_FILE_MISSING:Y:E::::",

"DBA:TABLESPACE_FULL:Y:W:>:95:P:",

"DBA:TABLESPACE_IN_BACKUP:Y:W::::",

"DBA:TABLESPACE_OFFLINE:Y:E::::",

"DBA:TOO_MANY_EXTENTS:Y:W:>:90:P:",

"DBO:ARCHIVE_TOO_OLD:N:W:>:10:D:",

"DBO:BACKUP_TOO_OLD:N:W:>:10:D:",

"DBO:LAST_ARCHIVE_FAILED:N:W::::",

"DBO:LAST_BACKUP_FAILED:N:W::::",

"DBO:LAST_OPERATION_FAILED:Y:W::::chk",

"DBO:LAST_OPERATION_FAILED:N:W::::",

"DBO:LAST_STATS_FAILED:Y:W::::",

"DBO:OPERATION_TOO_OLD:Y:W:>:10:D:chk",

"DBO:OPERATION_TOO_OLD:N:W:>:10:D:",

"DBO:STATS_TOO_OLD:Y:W:>:10:D:",

"ORA:00060:Y:W::::",

"ORA:00272:Y:E::::",

"ORA:00376:Y:E::::",

"ORA:00600:Y:E::::",

"ORA:01113:Y:E::::",

"ORA:01114:Y:E::::",

"ORA:01115:Y:E::::",

"ORA:01122:Y:E::::",

"ORA:01135:Y:E::::",

"ORA:01149:Y:W::::",

"ORA:01555:Y:W::::",

"ORA:01562:Y:W::::",

"ORA:01578:Y:E::::",

"ORA:03113:Y:E::::",

"ORA:07445:Y:E::::",

"ORA:Checkpoint not complete:Y:W::::",

"PROF:COMPATIBLE:Y:E:<>:10.2.0::",

"PROF:CONTROL_FILE_RECORD_KEEP_TIME:Y:W:<:30::",

"PROF:DB_BLOCK_SIZE:Y:E:<>:8192::",

"PROF:DB_FILES:Y:W:<:254::",

"PROF:DB_FILE_MULTIBLOCK_READ_COUNT:Y:W::::",

"PROF:FILESYSTEMIO_OPTIONS:Y:E:<>:SETALL::",

"PROF:LOG_ARCHIVE_START:Y:W::::",

"PROF:LOG_BUFFER:Y:W:><:4096,512:K:",

"PROF:LOG_CHECKPOINTS_TO_ALERT:Y:W:<>:TRUE::",

"PROF:MAX_DUMP_FILE_SIZE:Y:W:><:100000,10000::",

"PROF:OPEN_CURSORS:Y:W:><:2000,800::",

"PROF:OPTIMIZER_FEATURES_ENABLE:Y:W::::",

"PROF:OPTIMIZER_INDEX_COST_ADJ:Y:W::::",

"PROF:OPTIMIZER_MODE:Y:W::::",

"PROF:PARALLEL_EXECUTION_MESSAGE_SIZE:Y:W:><:16384,4096::",

"PROF:PARALLEL_THREADS_PER_CPU:Y:W:><:2,1::",

"PROF:QUERY_REWRITE_ENABLED:Y:E:<>:FALSE::",

"PROF:RECYCLEBIN:Y:E:<>:OFF::",

"PROF:REMOTE_OS_AUTHENT:Y:E:<>:TRUE::",

"PROF:REPLICATION_DEPENDENCY_TRACKING:Y:E:<>:FALSE::",

"PROF:SHARED_POOL_SIZE:Y:W:<:400:M:",

"PROF:STAR_TRANSFORMATION_ENABLED:Y:W:<>:TRUE::",

"PROF:STATISTICS_LEVEL:Y:W::::",

"PROF:TIMED_STATISTICS:Y:W::::",

"PROF:TRACE_ENABLED:Y:W::::",

"PROF:UNDO_MANAGEMENT:Y:E:<>:AUTO::",

"PROF:UNDO_TABLESPACE:Y:W:<>:PSAPUNDO::")