ERROR => Connect via SAPUSER not supported for kernel >= 740.

[Former Member]

Dear all

i am facing given problem when upgrade sap ecc6 to ehp 7 .

Please help.

4 ETW000 R3trans version 6.24 (release 741 - 10.10.13 - 20:13:08 ).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 19.04.2014 - 19:30:24

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d -w /usr/sap/PRD/SUM/abap/log/DBCONNCHK.LOG

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Sat Apr 19 19:30:24 2014                                                  73  0.000073

4 ETW000  [     dev trc,00000]  db_con_init called                                                        21  0.000094

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        16  0.000110

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  19  0.000129

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                 15  0.000144

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/PRD/SUM/abap/exe/dboraslib.so' ...           38  0.000182

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/PRD/SUM/abap/exe/dboraslib.so"), hdl 0, count 1, addr 47626d0

4 ETW000                                                                                                9465  0.009647

4 ETW000  [     dev trc,00000]  Library '/usr/sap/PRD/SUM/abap/exe/dboraslib.so' loaded                   21  0.009668

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library /usr/sap/PRD/SUM/abap/exe/dboraslib.so

4 ETW000                                                                                                  62  0.009730

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/PRD/SUM/abap/exe/dboraslib.so' is "741.10", patchlevel (0.11)

4 ETW000                                                                                                 108  0.009838

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library /usr/sap/PRD/SUM/abap/exe/dboraslib.so

4 ETW000                                                                                                  21  0.009859

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library /usr/sap/PRD/SUM/abap/exe/dboraslib.so

4 ETW000                                                                                                  46  0.009905

4 ETW000  [     dev trc,00000]  function sapic_get_instant_client_version loaded from library /usr/sap/PRD/SUM/abap/exe/dboraslib.so

4 ETW000                                                                                                  24  0.009929

4 ETW000  [     dev trc,00000]  function sapic_get_instant_client_flavor loaded from library /usr/sap/PRD/SUM/abap/exe/dboraslib.so

4 ETW000                                                                                                  23  0.009952

4 ETW000  [     dev trc,00000]  function sapic_get_patchset_version loaded from library /usr/sap/PRD/SUM/abap/exe/dboraslib.so

4 ETW000                                                                                                  22  0.009974

4 ETW000  [     dev trc,00000]  function sapic_get_ls_inventory loaded from library /usr/sap/PRD/SUM/abap/exe/dboraslib.so

4 ETW000                                                                                                  22  0.009996

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1

4 ETW000                                                                                                  38  0.010034

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK)                     21  0.010055

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                       21  0.010076

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  14  0.010090

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , info = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  44  0.010134

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                       21  0.010155

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             13  0.010168

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  18  0.010186

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          12  0.010198

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , info = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  26  0.010224

4 ETW000  [     dev trc,00000]  -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='741')

4 ETW000                                                                                                  96  0.010320

4 ETW000  [     dev trc,00000]  Register application info.                                               244  0.010564

4 ETW000  [     dev trc,00000]  Oracle client version: 11.2.0.3.0, V2, default build, (dbsl 741 231113, UNICODE[2])

4 ETW000                                                                                                  71  0.010635

4 ETW000  [     dev trc,00000]  Installed Oracle client patches:                                          42  0.010677

4 ETW000  [     dev trc,00000]  # Patch  14489591     : Created on 19 Jan 2013, 20:08:26 hrs PST8PDT

4 ETW000                                                                                                  21  0.010698

4 ETW000  [     dev trc,00000]  # Patch  14042380     : Created on 23 Dec 2013, 22:24:52 hrs PST8PDT

4 ETW000                                                                                                  62  0.010760

4 ETW000  [     dev trc,00000]  # Patch description: Created on  7 Jan 2014, 02:20:21 hrs PST8PDT         35  0.010795

4 ETW000  [     dev trc,00000]  # Patch  13508485     : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT

4 ETW000                                                                                                 350  0.011145

4 ETW000  [     dev trc,00000]  # Patch  11742262     : Created on  7 Mar 2012, 12:22:41 hrs CET          24  0.011169

4 ETW000  [dbsloci.c   ,00000]  *** ERROR => Connect via SAPUSER not supported for kernel >= 740.         28  0.011197

4 ETW000  [     dev trc,00000]     Only Secure Connect method possible.                                   15  0.011212

4 ETW000  [     dev trc,00000]     DbSlConnect(con=-1) -> orc=0, 15=DBSL_ERR_UNSUPPORTED                  23  0.011235

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)                        34  0.011269

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)                        24  0.011293

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO)                     45  0.011338

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET)                    26  0.011364

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION)                  27  0.011391

4 ETW000  [     dev trc,00000]                 -> 'OCI_112, 11.2.0.3.0, V2, default build'                19  0.011410

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'PRD'"

[Former Member · Accepted solution]

Hi Amit,

What is the current patch level for kernel.From where are you getting the log (which trans.log)

Regards,

Deepanshu    

[Former Member · Accepted solution]

kernel version 720_rel

trans.log.zip

[Former Member · Accepted solution]

Hi Amit,

I'm asking on the patch level.

Regards,

Deepanshu Sharma

[Former Member · Accepted solution]

sap kernel - 720_ext_rel

kernel patch number -600

dbsl patch no. 610

[former_member195313]

Hello Amit ,

Please activate "Secure Storage File System" if you are going to use 7.40 Kernel with Oracle DB

Secure Storage in File System (SSFS) for SAP

Best Regards.

[Former Member]

Guys,

Even after configuring, my R3trans is failing with same error.

My system is on EHP6 ECC 6 and I am trying to upgrade to Kernel 742.

Can someone help me on this please?

Regards,

Prithivi Raj

[Former Member]

Hi Prithvi ,

follow this

http://scn.sap.com/docs/DOC-45629

[Former Member]

Dear Victor,

I am facing the error which is discussed above. I am not asking steps for Kernel Upgrade.

Regards,

Prithivi Raj

[Former Member]

hi Prithvi,

this error occurs if you are going for a EHP update from kernal <=740 ,

hence before you do the

update you can upgrade your kernal and this issue wont be there .

else follow this blog: to set up the SSFS.

Regards,

Victor

[Former Member]

Victor,

I did the same, I have not yet started my EHP upgrade.

I just did the kernel upgrade and R3trans fails with the above discussed error.

Also I have already implemented SSFS after the kernel upgrade. But still i face the issue.

Regards,

Prithivi Raj

[Former Member]

Hi Prithvi,

Have you created the environment variable

rsdb/ssfs_connect = 1 for both the system and the user ,

try checking if you have created for the system in the OS level .

regards,

Victor

[Former Member]

Victor,

Thanks for your efforts.

My issue has been resolved, the issue was I created a password entry with some database user which was not the owner of the database tables. So the user was able to login to the database but was not authorized to access the database tables. Later I found the owners of the tables and I created a new password entry for SSFS with that user and it worked like charm...!

Regards,

Prithivi Raj

[Former Member]

Hi Prithvi

Could you please suggest the exact steps taken to fix this problem? I am also suffering with the same issue.

Thanks

Sidharth

[Former Member]

@Prithvi: Could you please suggest which user you changed to get this working?

[Former Member]

Hi,

Apologies for the very late reply, do you still want me to explain the steps ?

Regards,

Prithivi Raj

[sourabhchordiya]

Hi Amit,

You need to setup SSFS ( secure storage file system ) as advised in blog below , the kernel 740 and higher do not support OPS$ mechanism anymore and hence you are getting the error.

http://scn.sap.com/community/oracle/blog/2013/07/23/ssfs-secure-storage-in-file-system-configuration...

Regards,

Sourabh