Skip to Content
0

SAP system not able to connect to oracle database after restart

May 17, 2017 at 11:11 PM

72

avatar image

Hi Experts,

There was a linux patching recently in our pre-prod environment after which one of the SRM ABAP system is unable to connect to the database. It is a distributed installation with 1 application server and separate database host. We just stopped the database and app for the linux patching and once the servers were back, we were able to start the database and listener successfully but the R3trans -d is not working fine on ABAP and it doesn't give any detailed error. Kindly suggest

trans.log

4 ETW000 R3trans version 6.24 (release 721 - 01.04.15 - 20:15:04). 4 ETW000 unicode enabled version 4 ETW000 =============================================== 4 ETW000 4 ETW000 date&time : 18.05.2017 - 03:43:45 4 ETW000 control file: 4 ETW000 R3trans was called as follows: R3trans -d 4 ETW000 trace at level 1 opened for a given file pointer 4 ETW000 [ dev trc,00000] Thu May 18 03:43:45 2017 69 0.000069 4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/SRU/SYS/exe/run/ dboraslib.so' ... 11 0.000080 4 ETW000 [ dev trc,00000] Library '/usr/sap/SRU/SYS/exe/run/ dboraslib.so' loaded 5972 0.006052 4 ETW000 [ dev trc,00000] Version of '/usr/sap/SRU/SYS/exe/run/ dboraslib.so' is "721.02", patchlevel (0.419) 4 ETW000 339 0.006391 4 ETW000 [ dev trc,00000] dbs/ora/stmt_cache_size = 250 56 0.006447 4 ETW000 [ dev trc,00000] Register application info. 132 0.006579 4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 721 030315, UNICODE[2]) 4 ETW000 94 0.006673 4 ETW000 [ dev trc,00000] Installed Oracle client patches: 23 0.006696 4 ETW000 [ dev trc,00000] # Patch 13508485 : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT 4 ETW000 8 0.006704 4 ETW000 [ dev trc,00000] # Patch Description: Created on 3 Jan 2012, 02:50:27 hrs PST8PDT 14 0.006718 4 ETW000 [ dev trc,00000] # Patch 11742262 : Created on 7 Mar 2012, 12:22:41 hrs CET 17 0.006735 4 ETW000 [ dev trc,00000] # CharacterSet NCharSet envhp errhp er2hp bathp 4 ETW000 3073 0.009808 4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error -1 performing CON 28 0.009836 4 ETW000 [ dblink ,00000] ***LOG BY0=>OCI returned error code -1. 11 0.009847 2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SRU'"

Regards,

Pankaj

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Bartosz Jarkowski May 18, 2017 at 07:40 AM
0

Hi,

please execute following command and then please paste the log.txt file here:

R3trans -d -w log.txt

Best regards

Bartosz

Share
10 |10000 characters needed characters left characters exceeded
Pankaj Pabreja Aug 30, 2017 at 08:23 AM
0

Hi All,

Thanks for your suggestions. The issue was one of the oracle client files was present in the kernel directory, hence SAP application was not coming up. Removed that file and the system got started.

Thanks,

Pankaj

Share
10 |10000 characters needed characters left characters exceeded