sql error 12505 performing CON [dblnk 0489] in R3trans

[Former Member]

hi,

R3trans getting error as

4 ETW000 R3trans version 5.36 (release 31I - 08.12.00 - 12:30:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 control file: <no ctrlfile>

4 ETW000 date&time : 02.12.2010 - 10:57:06

Thu Dec 2 10:57:16 2010

***LOG BY2=> sql error 12505 performing CON [dblnk 0489]

***LOG BY0=> [dblnk 0489]

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'xxx'"

ORACLE 8.2

Database is up/open & running.

Checked for tnsnames.ora ,but port n hostname is correctly maintained.

Kindly suggest.

[former_member204746]

1. I guess you meant Oracle 9.2 ?

2. what is your OS?

3. have you set ORACLE_HOME?

4. have you set TNS_ADMIN?

5. provide contents from file tnsnames.ora

[Former Member]

Hi,

Also please read note no.576919, may help you.

Thanks and Regards,

Kiron.

[Former Member]

Hi,

The error : ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

Please check, whether listner is running,

Under OS user oraSAPSID execute the command - lsnrctl status

Also from os login by SAPSID, and check from command,R3trans -d, whether database is connected.

as the error 2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'xxx'"

Regards,

Kiron.