TMS Check Transport Tool Error

[Former Member]

Hello Experts,

We have migrated the database from Informix(DEV old machine) to Oracle(DEV New machine) and found the system up and running fine except the DBconnect failed error when i run the STMS->system overview->select the system as DEV-->R3System->check->Transport tool.

Please find the error log herewith:

developertrace,0] Logon as OPS$-user to get SAPR3's password

developertrace,0] Connecting as /@DEV on connection 0 ...

developertrace,0] >oci_logon(con_hdl=0, user='', dbname='DEV')

dbsloci.,6405] *** ERROR => CONNECT failed with sql error '1019'

developertrace,0] Try to connect with default password

developertrace,0] Connecting as SAPR3/<pwd>@DEV on connection 0 ...

developertrace,0] >oci_logon(con_hdl=0, user='SAPR3', dbname='DEV')

dbsloci.,6405] *** ERROR => CONNECT failed with sql error '12705'

We have tried almost every option given in the SAP notes but couldnt figure out the issue. We are now not able to support PRD now as the DEV is not available. Can any one quickly help me in resolving the issue...

R3 -> 45B

OS: UNIX

Kernel: 45B_EXT

We are getting no error when we run R3Trans -x and R3Trans -d as well.

Please help us in resolving the issue ASAP...

P.S: If you could give your contact number, iam ready to call you and talk to you regarding the issue and can work upon this.

Thanks and Regards,

Mani

+91 934 749 6777

[Former Member]

dear mani,

im guessing this could be because of two reasons

1) the transport directory might not have been properely mounted.

2) the owner/permissions of the new(oracle) transpport directory could be different to the old(informix) transport directory.

try these two options and let me know my suggestions were of any help

[Former Member]

Hello Mani,

Have you set the environment variables correctly?

Also does SAPR3 has authorizations for Transport directory?

Regards.

Ruchit.

[Former Member]

Hi Ruchit,

Please find the trans.log file after I run R3Trans -x herewith:

4 ETW000 [developertrace,0] New connection 0 created 20 0.034731

4 ETW000 [developertrace,0] db_con_connect (con_name=R/3) 62 0.034793

4 ETW000 [developertrace,0] Got ORACLE_HOME=/oracle/DEV/920_64 from environment

4 ETW000 89 0.034882

4 ETW000 [developertrace,0] -->oci_initialize 23 0.034905

4 ETW000 [developertrace,0] Got ORACLE_SID=DEV from environment

4 ETW000 42 0.034947

4 ETW000 [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environme

nt

4 ETW000 29 0.034976

4 ETW000 [developertrace,0] Logon as OPS$-user to get SAPR3's password

4 ETW000 22 0.034998

4 ETW000 [developertrace,0] Connecting as /@DEV on connection 0 ...

4 ETW000 29 0.035027

4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='DEV')

4 ETW000 31 0.035058

4 ETW000 [developertrace,0] Now I'm connected to ORACLE 62893 0.097951

4 ETW000 [developertrace,0] Got SAPR3's password from table SAPUSER

4 ETW000 1408 0.099359

4 ETW000 [developertrace,0] Disconnecting from connection 0 ...

4 ETW000 23 0.099382

4 ETW000 [developertrace,0] -->oci_logoff(con_hdl=0) 22 0.099404

4 ETW000 [developertrace,0] Now I'm disconnected from ORACLE

4 ETW000 1032 0.100436

4 ETW000 [developertrace,0] Try to connect with the password I got from OPS$-us

er

4 ETW000 25 0.100461

4 ETW000 [developertrace,0] Connecting as SAPR3/<pwd>@DEV on connection 0 ...

4 ETW000 22 0.100483

4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='DEV')

4 ETW000 22 0.100505

4 ETW000 [developertrace,0] Now I'm connected to ORACLE 40345 0.140850

So as this is not giving any error, i dont think this is a problem with sapr3 password.

Apart from that we suspect that there is some problem with the env variable ORA_NLS33... but couldnt get to the bottom of the problem...

Please find the trace file we got when we ran tp command:

[developertrace,0] db_con_connect (con_name=R/3) 64 0.058188

[developertrace,0] Got ORACLE_HOME=/oracle/DEV/920_64 from environment

85 0.058273

[developertrace,0] -->oci_initialize 23 0.058296

[developertrace,0] Got TNS_ADMIN=/oracle/DEV/920_64/network/admin from environment

42 0.058338

[developertrace,0] Got ORACLE_SID= from environment 43 0.058381

[developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

29 0.058410

[developertrace,0] Logon as OPS$-user to get SAPR3's password

21 0.058431

[developertrace,0] Connecting as /@DEV on connection 0 ...

28 0.058459

[developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='DEV')

30 0.058489

[dbsloci.,6405] *** ERROR => CONNECT failed with sql error '1019'

2235 0.060724

[developertrace,0] Try to connect with default password 18 0.060742

[developertrace,0] Connecting as SAPR3/<pwd>@DEV on connection 0 ...

23 0.060765

[developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='DEV')

22 0.060787

[dbsloci.,6405] *** ERROR => CONNECT failed with sql error '12705'

60464 0.121251

[ ,597] ***LOG BY2=>sql error 12705 performing CON 48 0.121299

[ ,597] ***LOG BY0=> 17 0.121316

[tpsqlora.c,1104] end: tp_connect 13 0.121329

Any help in this way is very much appreciative.

Best Regards,

Mani

[Former Member]

Hello Mani,

Did you make changes in SE06 after the DB migration?

Regards.

Ruchit.

[Former Member]

Hi Ruchit,

Thanks a lot for the response.

I have done the changes in se06 as part of post migration activities.

I have deleted the old TMS and have created new.

Regards,

Mani