on 02-13-2016 11:30 PM
Dear Experts,
We have migrated ECC system from Oracle to HANA.
We are troubleshooting a database connection in HANA DBCON/DBACOCKPIT to our external Oracle database. We had the external database connection working before migration, but in HANA does not seem to connect to the external database. Details below.
We are able to connect to the remote database with tnsping from the HANA server following command, but going through SAP results in 12154 Error.
> tnsping WTKTST
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 13-FEB-2016 17:16:31
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
/sapmnt/DD1/profile/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = lrlupsaptax1.sap.entergy.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = WTKTST.WORLD)))
OK (10 msec)
===========================================
Testing from ADBC_TEST_CONNECTION:
Testing a Database Connection Defined in DBCON
Could not open connection TAXDB .
sql error 12,154 occured:
con=1(WTKTST): ORA-12154: TNS:could not resolve the connect identifier specified.
=========================================
more dev_w21
Sat Feb 13 16:55:00 2016
B Library '/usr/sap/DD1/DVEBMGS00/exe/dboraslib.so' loaded
B Version of '/usr/sap/DD1/DVEBMGS00/exe/dboraslib.so' is "742.06", patchlevel (0.314)
B Connect to TAXDB as SMSAP_OPER with WTKTST
C dbs/ora/array_buf_size = 130000
C dbs/ora/stmt_cache_size = 250
C Register application info.
C Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 742 301115, UNICODE[2])
C Installed Oracle client patches:
C # Patch 13508485 : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT
C # Patch Description: Created on 3 Jan 2012, 02:50:27 hrs PST8PDT
C # Patch 11742262 : Created on 7 Mar 2012, 12:22:41 hrs CET
C Connecting as SMSAP_OPER/<pwd>@WTKTST on connection 1 (nls 0) ... (dbsl 742 301115, UNICODE[2])
C OCIHandleAlloc(con=1): Service svc=84d8a58 created, rc=0
C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154:
C ORA-12154: TNS:could not resolve the connect identifier specified
C OCIServerAttach(con=1, svc=84d8a58): Error 12154 attaching new srv=84d9a70 to 'WTKTST'
C OCIHandleFree(con=1): Server handle srv=84d9a70 freed.
C OCIHandleFree(con=1): Service svc=84d8a58 freed (i=0).
C rc=12154 -> Trying to reattach to server 'WTKTST'
C OCIHandleAlloc(con=1): Service svc=84d8a58 created, rc=0
C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154:
C ORA-12154: TNS:could not resolve the connect identifier specified
C OCIServerAttach(con=1, svc=84d8a58): Error 12154 attaching new srv=84d9a70 to 'WTKTST'
C OCIHandleFree(con=1): Server handle srv=84d9a70 freed.
C OCIHandleFree(con=1): Service svc=84d8a58 freed (i=1).
C *** ERROR => CONNECT failed with SQL error '12154'
[dbsloci.c 16088]
C {root-id=005056AA0C991EE5B4D480022BFD7EAF}_{conn-id=00000000000000000000000000000000}_0
B ***LOG BY2=> sql error 12154 performing CON [dbds 971]
B ***LOG BY0=> con=1(WTKTST): ORA-12154: TNS:could not resolve the connect identifier specified [dbds 971]
Regards,
Mani
Hello Mani,
I think you should test command tnsping WTKTST in application server and check if it succeeds or not, Oracle client and library should be installed in application server.
Regards,
Ning Tong
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Ning,
The Oracle client and library are installed in application server, the. tnsping WTKTST was tested working OK from the application server( I wrongly mentioned as HANA server, actually CI sever connected to HANA DB).
In debugging ABAP Database Connectivity (ADBC_TEST_CONNECTION), it fails at
SAP kernel calls CALL 'C_DB_FUNCTION' with sql-code errror 12154.
Thanks
Mani
The problem is solved.
The steps are,
1) Install oracle client on the HANA system CI server.
2) Set oracle environment variable for the <sid>adm user .sapenv.csh profile
setenv PATH /oracle/SID/112_64/bin:$PATH
setenv TNS_ADMIN /sapmnt/SID/profile/oracle
3) Make sure tnsping works
4) Restart HANA CI.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.