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

Message was edited by:

Kirill Mishurovsky

[Former Member]

Hi,

You might want to post this in the Oracle forum. The BRTOOLS are setup to work with Oracle and not MS SQL Server.

Hope that helps.

J. Haynes

Denver, CO