New TNS Entry not recognized by SAP application

[Former Member]

Hi Guys,

As per requirement our SAP system needs to be connected to the external bank's database. I made the required entry in the tnsnames.ora in SAP development system. From SAP Development os level I can connect to the bank database via SQL plus and external database is reachable via tnsping. Following is the TNS entry for external database (XE).

XE.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = )

(PROTOCOL = TCP)

(HOST = bankiba)

(PORT = 1521)

)

)

(CONNECT_DATA =

(SID = XE)

(GLOBAL_NAME = XE.WORLD)

)

)

tnsping result.

socdev01:oradev 7> tnsping XE

TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 29-JUL-2010 11:15:30

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/oracle/DEV/102_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY 😃 (PROTOCOL = TCP) (HOST = bankiba) (PORT = 1521))) (CONNECT_DATA = (SID = XE) (GLOBAL_NAME = XE.WORLD)))

OK (0 msec)

Connect Via sqlplus.

socdev01:oradev 8> sqlplus 9306332@XE

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jul 29 11:18:45 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter password:

Connected to:

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>

I did make an entry in the DBCONN table via DBCO transaction code with the following parameter

DB Connection : CONN_IBA

DBMS : ORA

User Name : 9306332

DB password : *********

Conn. info : XE.WORLD

Connection Limit 10

Optimum Conns 0

Now if I check the connection from dbacockpit the connection is giving the following error.

"ERROR Database connection CONN_IBA: SQL error 12154 ORA-12154: TNS:could not resolve the connect identifier specified"

do I need to reboot the sap system after making an new TNS entry. Could you guys help me?

[Former Member · Accepted solution]

Hi,

If it is working on OS level, just copy tnsname.ora file from /oracle/<SID>/102_64/network/admin to /sapmnt/<SID>/profile/oracle.

It will solve your problem.

If I am not wrong, At SAP level, SAP Application use tnsnames.ora from /sapmnt/<SID>/profile/oracle location...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Thanks Rajesh,

Thanks a ton for your help.

How could I forget such thing. Once again thank u all for your reply specially to rajesh.

[Former Member]

Hi Team PWC,

Though what Sunny is correct and you can have a look at below SAPnote it will solve your issue....

Note 1261329 - DBA Cockpit: Oracle as a remote database

[Former Member]

...

[sunny_pahuja2]

Hi,

Probable reason for the error you are getting is DB Connection : CONN_IBA name that you have added in DBCON table is different from that you added in tnsnames.ora file. Please put the same name as mentioned in the SAP note 443867.

Please check below extract:

6. If you want to set up a connection from R/3 to a remote Oracle database, the table DBCON must be maintained accordingly (Note 339092). The entry CON_NAME (connection name) must contain the alias that is also in tnsnames.ora. If the alias differs, ORA-12154 occurs.

Thanks

Sunny