SAP Not started : LOG BZA=>table SVERS does not exist

[Former Member]

Hi Experts,

After the database restore, we are getting the below error of command output R3trans -d

LOG BZA=>table SVERS does not exist

Complete message of trans.log is attached

Restore, recovery, create ops$ account completed.

I have referred the below SAP Notes & thread

50088

134592

400241

534765

530392

Thread: 98940

Thanks,

QAS.txt.zip

[Jiajia]

Hello,

Have you checked whether the object SVERS exist on your database or not? You can using following sql statement:

SQL>SELECT OWNER FROM ALL_TABLES WHERE TABLE_NAME = 'SVERS';

Then, please make sure you have set the environment variable dbs_ora_schema=SAP<SID> where SAP<SID> is the owner of the tables in the database, which you can also get it from above output.

Best regards,

Jiajia

[Former Member]

Hi Jiajia,

My environment variable is pointing to SAPQAS.

Table exists but the owner is SAPPRD

SQL> SELECT OWNER FROM ALL_TABLES WHERE TABLE_NAME = 'SVERS';

OWNER

------------------------------

SAPPRD

Also refer the below output "SELECT owner, table_name FROM dba_tables"

Except the the below listed tables,  all other tables are owned by "SAPPRD"

OWNER                          TABLE_NAME

------------------------------ ------------------------------

SAPPRD                         ZMM_CM_REDTAG

SAPPRD                         ZMM_CM_STAT

SAPPRD                         ZMM_CM_STAT_YR

OPS$QASADM                     SAPUSER

SAPQAS                         T000

SYS                            WRI$_ADV_OBJSPACE_TREND_DATA

SYS                            WRI$_ADV_OBJSPACE_CHROW_DATA

Thanks,

[ashish_mishra2]

Hi

You will have to change dbs_ora_schema environment variable from SAPQAS to SAPPRD as the table owner (Schema) has been changed to SAPPRD.

Please refer Note 534765 - db connect fails because of wrong db schema in environment

Symptom 1

In the trans. log messages like the following can be found:

              ***LOG BZA=>table SVERS      does not exexist on database

Solution

Set the environment variable dbs_ora_schema=SAP<SID> where SAP<SID> is the owner of the tables in the database.

Cheers !!!

Ashish