DB not connecting with SAP

[Former Member]

Hi ,

i have a problem on AIX SAP is not able to connect with DB .

Trans.log :

4 ETW000 [dev trc ,00000] Out 00: DBSL_DATA_CHAR (len=2, max=2, dec=0) 23 0.159771

4 ETW000 [dev trc ,00000] bind_type_and_length(): 0 input variables given 23 0.159794

4 ETW000 [dev trc ,00000] bind_type_and_length(): 1 output variables given 17 0.159811

4 ETW000 [dev trc ,00000] -->oci_define ( 0: SQLT_CHR, l= 2, con_hdl=0, stmth_p=0x1114e9c88, vp=0x1114cd954,ip=0x1114c5a60,rlp=(nil),rcp=(nil))

4 ETW000 39 0.159850

4 ETW000 [dev trc ,00000] -->oci_execute_stmt(con_hdl=0, stmth_p=0x1114e9c88, iters=1, rowoff=0, dml_batch_errors=0)

4 ETW000 30 0.159880

4 ETW000 [dev trc ,00000] OCIStmtExecute() failed with -1=OCI_ERROR 387 0.160267

4 ETW000 [dev trc ,00000] SQL error 942: 19 0.160286

4 ETW000 [dev trc ,00000] ORA-00942: table or view does not exist

4 ETW000 26 0.160312

4 ETW000 [dev trc ,00000] <--oci_execute_stmt(rc=942, rows processed 0, iters-errors = 1-0) [time 0,000s]

4 ETW000 44 0.160356

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 942 16 0.160372

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=942) 17 0.160389

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 942 51 0.160440

4 ETW000 [dev trc ,00000] ORA-00942: table or view does not exist

4 ETW000 38 0.160478

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT DBASE FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 29 0.160507

4 ETW000 [dbntab ,01302] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#8 @ 13026]

4 ETW000 29 0.160536

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0) 270 0.160806

[Former Member]

problem was with OPS$ user .

[former_member188883]

Hi Dev,

I guess you have performed system copy and post that you are facing this DB connect problem.

change the dbs_ora_schema = SAP<SID>

here <SID> is of the source system.

Post that check R3trans -d to verify connection with database.

Regards,

Deepak Kori

[former_member189725]

Please check what is the value of the environment variable dbs_ora_schema. Is it the schema which has the SAP tables ??

Then login to the database :

Execute the following

select username from dba_users;

check the schema user.

[Former Member]

Hi Ratnajit,

i have checked and found the below info :

dbs_ora_schema=SAPSR3

SQL> select username from dba_users;

USERNAME

-

---

OPS$ORAE8X

OPS$SAPSERVICEE8X

DBAACT

OPS$E8XADM

SYS

SYSTEM

SAPSR3

OUTLN

ORACLE_OCM

DIP

APPQOSSYS

USERNAME

-

---

DBSNMP

12 rows selected.

I think its correct but still the error any suggestions ?

Edited by: Dev S on Jan 6, 2012 1:26 PM

[former_member189725]

can you please paste the complete trans.log