ORA-00942: table or view does not exist

[Former Member]

During run BRBACKUP I get error

[code]

BR0051I BRBACKUP 6.40 (45)

BR0262I Enter database user name[/password]:

BR0055I Start of database backup: bdwmjyam.anf 2007-10-31 04.55.32

BR0484I BRBACKUP log file: /oracle/THR/sapbackup/bdwmjyam.anf

BR0280I BRBACKUP time stamp: 2007-10-31 04.55.34

BR0301E SQL error -942 at location BrLicCheck-47

ORA-00942: table or view does not exist

BR0056I End of database backup: bdwmjyam.anf 2007-10-31 04.55.34

BR0280I BRBACKUP time stamp: 2007-10-31 04.55.34

BR0054I BRBACKUP terminated with errors

[/code]

Enhanced trace level on

that's it's log

[code]

/oracle/THR/saptrace/usertrace/thr_ora_13331.trc

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.6.0 - Production

ORACLE_HOME = /oracle/THR/920_64

System name: HP-UX

Node name: rp4440-2

Release: B.11.11

Version: U

Machine: 9000/800

Instance name: THR

Redo thread mounted by this instance: 1

Oracle process number: 38

Unix process pid: 13331, image: oracle@rp4440-2 (TNS V1-V3)

• SESSION ID37.21972) 2007-10-31 15:30:04.166

• 2007-10-31 15:30:04.166

ksedmp: internal or fatal error

ORA-00942: table or view does not exist

Current SQL statement for this session:

select count(*) ,sum(BLOCKS) into :b0,:b1 from SYS.SEG$ where USER#=:b2

[/code]

We download latest version brtools from service.sap.com, recreate sapdba role, check's OPS$ user mechanism. We granted select from SYS.SEG$ to sapdba, but error don't eleminated

[Former Member · Accepted solution]

Hello Kirill,

if you granted the SELECT on SYS.SEG$ to the SAPDBA role, the only reason for the problem I can imagine is that the SAPDBA role itself is not granted to the user that executes BRBACKUP. Which user do you use? Can you switch to a different user or grant the SAPDBA role to that user?

Regards

Martin

[Former Member · Accepted solution]

Hello, Martin

You are right... problem solved... great thank's