Skip to Content
avatar image
Former Member

DB CONNECT Issue

Hi

I am trying to configure the DB Connect in SAP BI to connect Oracle database. Please write to me, what is the entry

that needs to be entered in SSID and SAPDBHOST. I have pasted the entry in the TNSNAMES.ORA file

IISTEST =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.87.10.13)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = IISTEST)

    )

  )

Please note that I am getting error ORA-12154 error in SM21 transaction, when I checked this error, it means that

TNS:could not resolve the connect identifier specified. Kindly give your inputs, how to resolve this error.

Thanks

Bala

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 13, 2015 at 06:31 AM

    Hi bala,

    It should be like

    A sample entry for the alias C11 and default domain WORLD could be, for example:

      C11.WORLD =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP) (HOST = c11host) (PORT = 1527)

            )

          )

          (CONNECT_DATA =

            (SID = PRD)

          )

        )


    Best Regards,

    Atul

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bala,

      Add your database details as a separate entry in TNSnames.ora file apart from your existing Database entry.

      with required hostname listerner ports details as mentioned by Atul. Also check the sqlnet.ora file if you have restricted the host connecting to this database. if you have restricted then you need to add the hostname/ipaddress in the sqlnet.ora file too.

      Regards,

      ram

  • avatar image
    Former Member
    Jan 13, 2015 at 06:14 AM

    Hi,

    You can use the tcode dbco to create new connection in SAP R/3 system. And test the connection by programe ADBC_TEST_CONNECTION.

    Regards

    Ankit

    Add comment
    10|10000 characters needed characters exceeded