Connect is not possible: DBMS = ORACLE error(return code 12) during transport

[Former Member]

Dear experts,

While performing transport to production, we are facing below error

Connect is not possible: DBMS = ORACLE

--- dbs_or

Message no. TW169

Diagnosis

R3trans cannot logon to the database.

System Response

The program is cancelled.

Procedure

In the R3trans log you will find an SQL error number, which gives you the cause of the error.

Environment variables not set (or incorrectly set) are the most frequent reason for the error

BR,

Fadzly Iqbal

[JamesZ]

Hi Fadzly,

What is the result by executing "R3trans -d" command via user sidadm?

It looks like the oracle client is not identified.

Best regards,
James

[Former Member]

Hello Iqbal,

Can you please check following sap notes:-

  1860519 - SAP fails to connect to the database

1576837 - ORA-01017: invalid username/password;

Regards

Anand

[Former Member]

Set the environment variables for ORACLE_SID and ORACLE_HOME in ora<sid> user