Installation of SAP NW ABAP system issue in SWPM/kernal

[Former Member]

Dear experts

while installing SAP NW7.31  i throws error for invalid user/password in create userstoreICM

I have downloded this kernal which is 7.21

Kernel 7.21 for Linux (X86_64, on Power)              51049976

but it need 7.21 ext which is below one , shall i give this when it ask for kernal

ZIP          51049983_4        721 EXT UC Kernel for SWPM SP9 - Linux on X86_64

then how  should i upgrade swpm kernal with above files and which file to use

i used following media

Dear all

i am installing SAP NW 7.31 as ABAP with following media

510443228 part1

510443228 part2

51041939_1 to 6

51044253_19 kernal  kernal is 7.31

51047747  ocl

swpm01 sp 07

it throughs error in create icmstore  i am on this error from 2 days

r3trans -d shows 0012 error username or password incorrect

saplikey    :   cannot connect to database

dev_saplikey : cannot connect to database username or password incorrect

I found below answer for this how to implement this  i have downloaded two zip file

in the install master of NW731, sap suggest use Software Provisioning Manager 1.0 to do installation. I used the new 720 EXT kernel instead of old one and the installation process complete successfully.

Need some suggestions on this

Regards

[former_member185239 · Accepted solution]

Dear Rajendra,

When you face any issue regarding the password or cannot change the password of DDIC user.

Then 99% of this type of issue , get resolve by upgrading the kernel.

You would have resolve the issue , by upgrading the kernel to 720 EXT patch <latest> instead of using new SWPM

With Regards

Ashutosh Chaturvedi

[Former Member · Accepted solution]

Dear

Thanks for your immediate reply

My installation is still stuck is not over i got error on 25th step now i downloaded new kernal 7.21 ext and start the installation and select new option for installation and select new kernal when it ask for kernal 731 i gave 7.21 ext and went forward so i have to wait and see what could be the outcome when i reach to create icm userstore

Regrads

[former_member185239 · Accepted solution]

Hi Rajendra,

If you face the issue again, kindly paste the logs for user store.

With Regards

Ashutosh Chaturvedi

[Former Member · Accepted solution]

Dear

again i stuck same step with new logs as follows

fiorid:orafid 80> R3trans -d

This is R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).

unicode enabled version

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

R3trans finished (0012).

---------------------

cat trans.log

4 ETW000 R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 19.01.2016 - 14:53:03

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000  [     dev trc,00000]  Tue Jan 19 14:53:03 2016                                                5144  0.005144

4 ETW000  [     dev trc,00000]  db_con_init called                                                        33  0.005177

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): ssfs will be used to get connect information

4 ETW000                                                                                                  41  0.005218

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

4 ETW000                                                                                                  29  0.005247

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

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/FID/SYS/exe/run/dboraslib.so' ...            45  0.005311

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/FID/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000                                                                                              160770  0.166081

4 ETW000  [     dev trc,00000]  Library '/usr/sap/FID/SYS/exe/run/dboraslib.so' loaded                    29  0.166110

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library /usr/sap/FID/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  39  0.166149

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/FID/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.114)

4 ETW000                                                                                                  83  0.166232

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library /usr/sap/FID/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  32  0.166264

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library /usr/sap/FID/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  60  0.166324

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  42  0.166366

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

4 ETW000                                                                                                  43  0.166409

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

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

4 ETW000                                                                                                  24  0.166460

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          32  0.166492

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

4 ETW000                                                                                                  55  0.166547

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): reading connect info for connection R/3             26  0.166573

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): DBSL supports extended connect protocol             32  0.166605

4 ETW000                          ==> connect info for default DB will be read from ssfs

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): register callback ssfs_dbi_trace and max level 2

4 ETW000                                                                                                  42  0.166647

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 836]          42  0.166689

4 ETW000  [     dev trc,00000]  Tue Jan 19 14:53:04 2016                                               61144  0.227833

4 ETW000  [     dev trc,00000]  RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3664]

4 ETW000                                                                                                  38  0.227871

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "/usr/sap/FID/SYS/global/security/rsecssfs/data/SSFS_FID.DAT" cannot be opened for read [rsecssfs.c 2198]

4 ETW000                                                                                                  63  0.227934

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Data file "/usr/sap/FID/SYS/global/security/rsecssfs/data/SSFS_FID.DAT" cannot be opened for read) [rsecssfs.c 897]

4 ETW000                                                                                                  41  0.227975

4 ETW000  [    dbcon.c ,00000]  *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/FID/SYS/global/security/rsecssfs/data/SSFS_FID.DAT" cannot be opened for read

4 ETW000                                                                                                  40  0.228015

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): deregister callback ssfs_dbi_trace                  17  0.228032

4 ETW000  [    dbcon.c ,00000]  *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS

4 ETW000                                                                                                  29  0.228061

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

----------------------------------

[root@fiorid ABAP]# cat dev_likey

---------------------------------------------------

trc file: "dev_likey", trc level: 1, release: "720"

---------------------------------------------------

Tue Jan 19 15:17:04 2016

MtxInit: 0 0 0

Loading DB library '/usr/sap/FID/SYS/exe/run/dboraslib.so' ...

Library '/usr/sap/FID/SYS/exe/run/dboraslib.so' loaded

Version of '/usr/sap/FID/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.114)

read_con_info_ssfs(): DBSL supports extended connect protocol

  ==> connect info for default DB will be read from ssfs

Register application info.

Oracle client version: 11.2.0.3.0, V2, default build, (dbsl 720 081211, UNICODE[2])

Installed Oracle client patches:

# Patch  14489591     : Created on 19 Jan 2013, 20:08:26 hrs PST8PDT

# Patch  14042380     : Created on 23 Dec 2013, 22:24:52 hrs PST8PDT

# Patch description: Created on  7 Jan 2014, 02:20:21 hrs PST8PDT

# Patch  13508485     : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT

# Patch  11742262     : Created on  7 Mar 2012, 12:22:41 hrs CET

Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

Connecting as SAPSR3/<pwd>@FID on connection 0 (nls 0) ... (dbsl 720 081211, UNICODE[2])

Attaching to database server FID (con=0, svchp=1434e70, srvhp=1437378)

Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=1434e70, srv=1437378, usr=146db98)

Tue Jan 19 15:17:05 2016

   OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

   ORA-01017: invalid username/password; logon denied

*** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c    14533]

***LOG BY2=> sql error 1017   performing CON [dblink       540]

***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink       540]

*** ERROR => saplikey: failed to connect to the database. [saplikey_w.c 762]

[root@fiorid ABAP]#

-------------------------

[root@fiorid ABAP]# cat saplikey.log

saplikey: failed to connect to the database.

[root@fiorid ABAP]#

Suggest the solutions

Regards

[former_member185239 · Accepted solution]

Hi Rajendra,

You need to configure SSFS for oracle.

"/usr/sap/FID/SYS/global/security/rsecssfs/data/SSFS_FID.DAT" cannot be opened for read) [rsecssfs.c 897]

4 ETW000                                                                                                  41  0.227975

4 ETW000  [    dbcon.c ,00000]  *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/FID/SYS/global/security/rsecssfs/data/SSFS_FID.DAT" cannot be opened for read

With Regards

Ashutosh Chaturvedi

[Former Member · Accepted solution]

Dear

Ok i will implement SSFS  for oracle database

we are using REDHAT Linux 6.6

i will confirm once done

Regards

[Former Member · Accepted solution]

Dear

I have Implemented SSFS as u said

|-------------------------------------------------------------------------|

| Record Key                     | Status     | Timestamp of last Update  |

|-------------------------------------------------------------------------|

| DB_CONNECT/DEFAULT_DB_PASSWORD | Encrypted  | 2016-01-19  12:46:41  UTC |

| DB_CONNECT/DEFAULT_DB_USER     | Plaintext  | 2016-01-19  12:29:23  UTC |

|-------------------------------------------------------------------------|

Summary

-------

Active Records    : 2 (Encrypted : 1, Plaintext : 1, Wrong Key : 0, Error : 0)

Outdated Records  : 5 (occupied space can be released by the "compact" command)

Datafile Location : /usr/sap/FID/SYS/global/security/rsecssfs/data/SSFS_FID.DAT (when existing)

Keyfile Location  : /usr/sap/FID/SYS/global/security/rsecssfs/key/SSFS_FID.KEY (when existing)

------------

[fidadm@fiorid ~]$ ls -l /usr/sap/FID/SYS/global/security/rsecssfs/data/SSFS_FID.DAT

-rw-------. 1 fidadm sapsys 1762 Jan 19 18:16 /usr/sap/FID/SYS/global/security/rsecssfs/data/SSFS_FID.DAT

-----------------

[fidadm@fiorid ~]$ R3trans -d

This is R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).

unicode enabled version

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

R3trans finished (0012).

-------------------------------------------------

SQL> drop table ops$sidadm.sapuser;

drop table ops$sidadm.sapuser

                      *

ERROR at line 1:

ORA-00942: table or view does not exist

then i have create it with

SQL> CREATE TABLE "OPS$FIDADM".SAPUSER

  (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

INSERT INTO "OPS$FIDADM".SAPUSER VALUES ('SAPSR3', 'System123');  2

Table created.

----------------------------------------------------

orasid

sqlplus / as sysdba

alter system reset remote_os_authent scope=spfile;

------------

rsec/ssfs_datapath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)data

rsec/ssfs_keypath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)key

rsdb/ssfs_connect = 1

----------------------------

then shutdown system and startup again

then also it show same error

i ran installation with Root user should i change to sidadm

Kindly suggest where i went wrong it is very urgent..................

Regards

[Former Member · Accepted solution]

Dear

Now the trans.log shows following

/home/xxxadm/trans.log: line 1: syntax error near unexpected token `('

/home/xxxadm/trans.log: line 1: `4 ETW000 R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00)

Regards

[Former Member · Accepted solution]

Dear

Now the trans.log shows following

/home/xxxadm/trans.log: line 1: syntax error near unexpected token `('

/home/xxxadm/trans.log: line 1: `4 ETW000 R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00)

Regards

[former_member185239 · Accepted solution]

Hi Rajendra,

Run the command R3trans -d

and then paste the trans.log

With Regards

Ashutosh Chaturvedi

[Former Member · Accepted solution]

Dear

R3trans.log

[fidadm@fiorid ~]$ R3trans -d

This is R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).

unicode enabled version

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

R3trans finished (0012).

-------------------------------------

trans.log

[fidadm@fiorid ~]$ trans.log

/home/fidadm/trans.log: line 1: syntax error near unexpected token `('

/home/fidadm/trans.log: line 1: `4 ETW000 R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).'

Regards

[kallolathome · Accepted solution]

Please check Note 1643080 and Note 1639578.

I hope it will help you    

[Former Member · Accepted solution]

Dear

already set ENV variable

rsdb_ssfs_connect=1

Default.PFL

system/type = ABAP

rsdb/ssfs_connect = 1

rdisp/mshost = fiorid

rdisp/msserv = sapmsFID

Regards

[Former Member · Accepted solution]

Dear

i have implemented

Regards

[Former Member · Accepted solution]

Dear All

The installation has completed successfully after i upgrade my Kernal 7.21_ext to level 500

previously it was on 117

Regards

[isaias_freitas · Accepted solution]

Hello Rajendra,

Nice to hear that the issue was solved.

Please mark the thread as "answered" .

Regards,

Isaías