SUM cannot retrieve USERID and/or PASSWD from SSFS

[former_member196171]

We are upgrading SAP ECC from EHP6 to EHP7 with NW 742 from NW 7.0 SP3 on AIX 7.1

We have already upgraded to Oracle 12 with SAP connection with SSFS and SAP is up and running fine, but getting following error with SUM at SHADOW instance configuration step

trans.log with R3trans -d from SUM Directory

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 Jan 28 15:19:01 2016
4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/SID/SYS/exe/run/dboraslib.so' ...
4 ETW000  [     dev trc,00000]  Library '/usr/sap/SID/SYS/exe/run/dboraslib.so' loaded
4 ETW000  [dbcon.c     ,00000]  *** ERROR => Version mismatch between executable (742.06) and DBSL shared library (721.02)
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SID/SYS/exe/run') or dbms_type ('ORA')"
~

In DBCONNCHKSHD.LOG in SUM step "configuration"

4 ETW000 R3trans version 6.25 (release 742 - 27.11.15 - 20:15:12).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time   : 28.01.2016 - 14:46:56
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x -w /usr/sap/SID/SUM/abap/log/DBCONNCHKSHD.LOG
4 ETW000  trace at level 1 opened for a given file pointer
4 ETW000  [     dev trc,00000]  Thu Jan 28 14:46:56 2016
4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/SID/SUM/abap/exe/dboraslib.so' ...
4 ETW000  [     dev trc,00000]  Library '/usr/sap/SID/SUM/abap/exe/dboraslib.so' loaded
4 ETW000  [     dev trc,00000]  Version of '/usr/sap/SID/SUM/abap/exe/dboraslib.so' is "742.06", patchlevel (0.300)
4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): DBSL supports extended connect protocol
4 ETW000                         ==> connect info for default DB will be read from ssfs
4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): profile parameter auth/shadow_upgrade is set
4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): DBSL supports extended connect protocol for upgrade
4 ETW000                         ==> connect info for shadow upgrade will be read from ssfs with a shadow upgrade key set.
4 ETW000  [dbcon.c     ,00000]  *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/SHADOW_DB_USER)=1 : SSFS-4218: Record with key "DB_CONNECT/SHADOW_DB_USER" not found in secure storage <-- SSFS-4
215: Data file "/usr/sap/SID/SYS/global/security/rsecssfs/data/SSFS_SID.DAT" exists, but does not contain the requested entry
4 ETW000  [dbcon.c     ,00000]  *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'SID'"
~

[former_member196171 · Accepted solution]

Hi Gaurav ,

Thanks for your reply

I am upgrading to NW 7.42 and Kernel 7.42 , the note is for 7.50 and kernel 7.45, anyway it is helpful

I got the solution i.e. updated SSFS_SID.DAT file manually for SAPSR3SHD DB user, SUM created the user in DB , but could not update DAT file , my upgrade moved on  passed the configuration step.

Thanks

Al Mamun

[former_member182034]

hi Zahir,

*** ERROR => Version mismatch between executable (742.06) and DBSL shared library (721.02)

Please download and update the kernel along with Oracle Binaries. Check below SAP notes

2179752 - SYB: DBCONNCHK_SHD fails: Shadow connect user missing in secure storage

Regards,

[former_member182657]

Hi Abu,

RSecSSFsGetRecord(DB_CONNECT/SHADOW_DB_USER)=1 : SSFS-4218: Record with key "DB_CONNECT/SHADOW_DB_USER" not found in secure storage <-- SSFS-4

For the issue suggest you to check with SAP Note  2179752 - SYB: DBCONNCHK_SHD fails: Shadow connect user missing in secure storage for dbsl patch lib_dbsl.

Hope this will help you.

Regards,