DB CONNECT Issue

[Former Member]

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

[AtulKumarJain · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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