cancel
Showing results for 
Search instead for 
Did you mean: 

BoH HANA - DBCON/DBACOCKPIT Connection to External Oracle Database

mani_perumal
Explorer
0 Kudos

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

former_member611367
Discoverer
0 Kudos

Hello Mani,

I'm going through this situation of not being able to create a connection at DBCO and not working, my question is whether this functionality is working in the current version of S / 4Hanna?

Thank you.

Hélder Lins

Accepted Solutions (1)

Accepted Solutions (1)

former_member182967
Active Contributor
0 Kudos

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

mani_perumal
Explorer
0 Kudos

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

former_member182967
Active Contributor
0 Kudos

Hello Mani,

Do you set environment variable TNS_ADMIN for AP user <sid>adm. (if not, set it in user profile and restart the application server) ?

Make sure the connection information is maintained correctly in DBCO as well.

Regards,

Ning Tong

mani_perumal
Explorer
0 Kudos

Ning,

TNS_ADMIN and DBCO are correct. Thanks

mani_perumal
Explorer
0 Kudos

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.

Answers (0)