Skip to Content
avatar image
Former Member

sql error 12505 performing CON [dblnk 0489] in R3trans

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 02, 2010 at 07:12 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2010 at 07:25 AM

    Hi,

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

    Thanks and Regards,

    Kiron.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2010 at 06:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded