OCI-call failed with -1=OCI_ERROR ORA-00942: table or view does not exist

[Former Member]

Hi all,

In the prepare phase of migration from SAP R3 4.6D to ECC 6.0 the shadow instance crach and I have this error message :

+M calling db_connect ...+

C CLIENT_ORACLE_HOME is not set as environment variable or

C DIR_CLIENT_ORAHOME is not set as profile parameter.

C assuming using instant client with unspecified location.

C Oracle Client Version: '10.2.0.2.0'

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

C Connecting as /@TST on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 0000000013F250B0 0000000006BAF1D0 0000000006B6A8C8

C Attaching to DB Server TST (con_hdl=0,svchp=0000000006B6A788,srvhp=0000000013F2EC58)

C Starting user session (con_hdl=0,svchp=0000000006B6A788,srvhp=0000000013F2EC58,usrhp=0000000006BAF9E8)

C Now '/@TST' is connected (con_hdl 0, nls_hdl 0).

C Got SAPR3SHD's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=0000000006B6A788,usrhp=0000000006BAF9E8)

C Now I'm disconnected from ORACLE

C Connecting as SAPR3SHD/<pwd>@TST on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 0000000013F250B0 0000000006BAF1D0 0000000006B6A8C8

C Starting user session (con_hdl=0,svchp=0000000006B6A788,srvhp=0000000013F2EC58,usrhp=0000000006BAF9E8)

C Now 'SAPR3SHD/<pwd>@TST' is connected (con_hdl 0, nls_hdl 0).

C Database NLS settings: AMERICAN_AMERICA.WE8DEC

C DB instance TST is running on SAP-PROD with ORACLE version 10.2.0.2.0 since JUN 16, 2008, 18:53:08

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20080616 192058 SAP-PROD

C OCI-call failed with -1=OCI_ERROR

C SQL error 942: 'ORA-00942: table or view does not exist'

*B **LOG BZA=> table SVERS does not exist on database [dblink#5 @ 1299] [dblink 1299 ]

*M **LOG R19=> ThInit, db_connect ( DB-Connect 004096) [thxxhead.c 1440]

M in_ThErrHandle: 1

*M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10468]*

Please help me,

Thx

TA

[Former Member]

Hi

Please check the tablespace size related to your shadow instance. There would be other logs associated with it.

Check this note also: Note 1093629 - Error in upgrade phase SHADOW_IMPORT_UPG2

[Former Member]

Hi,

I have enough space... I have just this message error

Thx

[Former Member]

A remark I am in the prepare phase, I am not pass yet to the upgrade phase