Skip to Content

RSA1 Database error 12154 at CON issue

Good day,

I am trying to extract data from an Oracle database that is hosted on

another server.

I have configured the tnsnames.ora at the OS level.

I completed a test with tnsping and also connect to the database via

sqlplus. Everything works fine at the OS level.

I have created the connection parameters via tx:DBCO

However i get the system message with text "Database error 12154 at CON"when i create a DB connection via tx:RSA1.

Regards,

Tolu

DBCO.png (12.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Jul 29, 2013 at 01:49 PM

    Hi Tolu,

    1 . Check the parameter TNS_ADMIN

    2. In this location you will find tnsname.ora

    3. Maintain the connection parameter here.

    Please follow the below link

    http://scn.sap.com/thread/112985

    http://scn.sap.com/thread/3359610

    Also paste the content of tnsname.ora and also paste the screenshot of error in RSA1 transaction

    With Regards

    Ashutosh Chaturvedi

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 29, 2013 at 02:03 PM

    Hello

    Maintain the tnsnames.ora file present at /usr/sap/SID/SYS/profile/oracle

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 29, 2013 at 02:35 PM

    Check env variable TNS_ADMIN for sidadm and orasid.

    TNS_ADMIN should be set so that the Instant Client finds the oraNET Services profile files tnsnames.ora, listener.ora and sqlnet.ora.


    By default, TNS_ADMIN should be set to : /usr/sap/<SAPSID>SYS/profile/oracle

    Add comment
    10|10000 characters needed characters exceeded