DB13 SQL error -942 after homogenous system copy

[Former Member]

Dear all,

I've performed hpmogenous system copy from the productiion system running on ECC 6.0 Oracle 10.2.0.4 and HP-UX 11.31.

Then after finishing all post homogenous system copy activites I've tried to start check db in DB13 and I got this error message.

In sqlplus from the server I checked this SELECT and it shows the appropriate rows. But from DB13 there is the error message.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000360, user ID RPO)

Execute logical command BRCONNECT On host sapds

Parameters: -u / -jid CHECK20111024152519 -c -f check

BR0801I BRCONNECT 7.00 (52)

BR0477I Oracle pfile /oracle/TST/102_64/dbs/initTST.ora created from spfile /oracle/TST/102_64/dbs/spfileTST.ora

BR0280I BRCONNECT time stamp: 2011-10-24 15.25.24

BR0301E SQL error -942 at location BrLicCheck-51,SQL statement:

'SELECT COUNT(*), NVL(SUM(BLOCKS), 0) FROM SYS.SEG$ WHERE USER# = 28'

ORA-00942: table or view does not exist

BR0806I End of BRCONNECT processing: cehbjvyf.chk2011-10-24 15.25.24

BR0280I BRCONNECT time stamp: 2011-10-24 15.25.25

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Does anyone knows why?

Thanks in advance.

Ruzica

[Former Member]

Solved

sapdba_role needed to be performed again

sqlplus /nolog @sapdba_role R3

This solves the problem

Ruzica