R3trans not connecting

[prasad_sure]

Hi Guys,

Kindly help me the below issue. We are trying to connect R3trans we are this issue.

2EETW169 no connect possible: "DBMS = ORACLE --- ORACLE_SID = '<sid>'"

Regards

S.Prasad

[prasad_sure]

Dear All,

Thanks for the support. But sorry for the late reply. We have resolved the issue internally.

After Oracle Client Installation Every think is working fine.

Regards

S.Prasad

[prasad_sure]

Dear All,

Thanks for the support. But sorry for the late reply. We have resolved the issue internally.

After Oracle Client Installation Every think is working fine.

Regards

S.Prasad

[werner_flamme]

Hi,

does your sidadm find the tnsnames.ora? The environment variable TNS_ADMIN should point to a directory where the tnsnames.ora must be found. And inside this tnsnames.ora, your SID mus have the correct value. For example, on one of our Linux boxes for an ABAP system:

/home/sidadm> echo $TNS_ADMIN

/sapmnt/SID/profile/oracle

(normally this points to /usr/sap/SID/SYS/profile/oracle/tnsnames.ora)

/home/sidadm> ls -l $TNS_ADMIN/tnsnames.ora

-rw-r--r-- 1 root root 8120 Nov 30 12:22 /sapmnt/SID/profile/oracle/tnsnames.ora

/home/sidadm> grep SID /sapmnt/SID/profile/oracle/tnsnames.ora

SID= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = oracle1.intranet.corp)(PORT = 1527))) (CONNECT_DATA = (SERVICE_NAME=SID)))

SID.WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = oracle1.intranet.corp)(PORT = 1527))) (CONNECT_DATA = (SERVICE_NAME=SID)))

When tnsnames.ora is not at the right place, or the respective entries inside are wrong, the client can't contact the server, and you get no connect. This is also the case on Java systems. I'm not sure if there may be another config underneath /usr/sap/SID/Jxx/j2ee/.

BTW, on ABAP systems "R3trans -x" generates R3trans.log, a more explicit error description can be found there.

HTH

Werner

[Former Member]

This is also the case on Java systems. I'm not sure if there may be another config underneath /usr/sap/SID/Jxx/j2ee/.

For AS Java you need to use configtool to configure connection to your database system. For more info please read Note 1033993 - Maintaining database-specific JDBC props with the ConfigTool and Note 867176 - FAQ: Oracle JDBC.

Regards,

Roman

[ashish_mishra2]

Hi,

Is this ABAP or JAVA stack ?  For Java stack, it will not work.

If this is abap stack, provide us the trans.log file output to investigate this further.

Cheers !!!

Ashish Mishra

[Former Member]

Hi Prasad

What is R3trans -D telling .    Run the command and paste the output of trans.log file . Would be helpful for analysis.

Also is this not working after some activity : like system copy / refresh etc , or is it after a restart.

Please check if your listener is working up ( as u are using Oracle ) . Login as orasid and check lsnrctl status.

Thanks

Rishi

[giri_dharan]

Hi Prasad,

Please read the following SAP Note carefully and perform corrections. This will solve your problem.

SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle.

If you are not able to guess, Please try as below

1) Open command prompt in windows

2) Type R3trans -d

3) Now type trans.log

The trans.log will open, Now copy paste the entire log here, so that i will analyse and suggest.

Regards,

Giridharan