Skip to Content
avatar image
Former Member

New TNS Entry not recognized by SAP application

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 29, 2010 at 07:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • avatar image
    Former Member
    Jul 29, 2010 at 06:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 29, 2010 at 07:12 AM

    ...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 29, 2010 at 07:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded