TNS alias - For connecting secondary database - Oracle

[Former Member]

Hi all,

I am trying to connect secondary database oracle from sap. I have maintained userinfo, pw and LOGICAL name of db in DBCO transaction. But in connection field, i need to give tns alias. But am not getting how should i format the tns alias to enter that field. The following tns alias i have with me.

abcxyz.HEXCHN.LOCAL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = bdcpss2)(PORT = 1221))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = casltab)

)

)

Can anyone tell me how to format this string..

Rgds

Ram sri

[Former Member]

Hi Ram,

1. Alias is not required.

2. Why are u looking for it ?

3.

TEST_SERVER =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = testdb)

)

)

regards,

amit m.

[Former Member]

You need to give the connection name abcxyz.HEXCHN.LOCAL in the connection field in DBCON.

This will only work if:

the tnsnames.ora file exists on the application server (not on your PC) and the tnsnames.ora file on the application server has an entry with such a name.

Regards,

Rao A