ORA-00942: table or view does not exist / BRBACKUP

[Former Member]

Has anyone seen this error when trying to do a brbackup?

BR0051I BRBACKUP 6.40 (40)

BR0055I Start of database backup: bdxxoiuu.anf 2008-05-14 10.10.36

BR0280I BRBACKUP time stamp: 2008-05-14 10.10.37

BR0301E SQL error -942 at location BrDbConnect-4

ORA-00942: table or view does not exist

BR0310E Connect to database instance BS1 failed

BR0280I BRBACKUP time stamp: 2008-05-14 10.10.37

BR0301E SQL error -942 at location BrDbConnect-4

ORA-00942: table or view does not exist

BR0310E Connect to database instance BS1 failed

[fidel_vales · Accepted solution]

>

> Has anyone seen this error when trying to do a brbackup?

yes

But it can have different causes.

One table is missing, but it is not indicated which one.

I've seen this when one of the SAP synonyms is not properly created.

But to be sure, first it is necessary to find out the "table" that is missing.

execute the brbackup command with a trace so we can see what fails (you can add to the brbackup command the option -TRC 15 at the end of the command)

then paste only the lines before the error

[Former Member]

Hello Jackie,

The problems is purely because the SAP -OPS$ user is not able to connect to the database.

For confirmation: Please open one of your developer traces - for instance dev_w0 and check: You should have the error where

C Logon as OPS$-user to get SAPR3's password

C Connecting as /@SID on connection 0 ...

C

C C Now I'm connected to ORACLE using OCI_7 API

C *** ERROR => ORA-980 when accessing table SAPUSER

and then the connection works as SAPR3 user with default password.

This is your problem. Solve this by running the oradbusr.sql -> or check SAP note system for more optiosn to solve this. And your backup should work fine.

Enjoy,

Maddy

Edited by: Madhusudan Gowda on May 16, 2008 3:02 PM

[Former Member]

Hello,

check this note

Note 662644 - Composite SAP Note: ORA-00942