SAP system not able to connect to oracle database after restart

[pankaj_pabreja]

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: <no ctrlfile> 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

[pankaj_pabreja]

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

[BJarkowski]

Hi,

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

R3trans -d -w log.txt

Best regards

Bartosz