Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question