cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot run system after enabling SSFS

Former Member
0 Kudos

Hello,

I followed note 1639578 when setting SSFS. I would like to install EHP7 and SSFS connection is prerequisite.

Everything went according to steps, but after I set environment variable rsdb_ssfs_connect=1 and profile parameter rsdb/ssfs_connect = 1 my system refused to start. All disp+work processes are down few seconds after I restart the system.

r3trans -d shows:

C:\Users\steadm>r3trans -d
This is r3trans version 6.24 (release 741 - 04.02.14 - 20:14:02 ).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_o
ra_tnsname = 'STE'"
r3trans finished (0012).

trans.log contents:

4 ETW000 r3trans version 6.24 (release 741 - 04.02.14 - 20:14:02 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000 
4 ETW000 date&time   : 23.06.2014 - 14:39:31
4 ETW000 control file: 4 ETW000 R3trans was called as follows: r3trans -d -w c:\trans.log
4 ETW000  trace at level 2 opened for a given file pointer
4 ETW000  [     dev trc,00000]  Mon Jun 23 14:39:31 2014                                                 109  0.000109
4 ETW000  [     dev trc,00000]  db_con_init called                                                        29  0.000138
4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        34  0.000172
4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000        

it looks like ssfs is not used, but parameters are set according to guide. Also database is accessable trough sqlplus, there is no problem to connect and select data.

Do you have any ideas where could be problem?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

Few things you can check

rsdb/ssfs_connect not set => ssfs not used

1) Env is applied (You need to log out and login with sidadm check by command env if its set )

2) Crednetial file created and accesible (Verify using command rsecssfx list )

3) maintained pwd is correct for SAP<SID>

Former Member
0 Kudos

hi,

I just restarted whole server (on OS level)...

system still cannot start, also r3trans -d shows that connection is not possible, but trans.log looks better, there are positive messages about SSFS, but there is also ORA-28000: the account is locked, so I'm going to fix it now.


rsecssfx list looks ok:

C:\Users\steadm>rsecssfx list
|---------------------------------------------------------------------------------|
| Record Key                     | Status             | Timestamp of last Update  |
|---------------------------------------------------------------------------------|
| DB_CONNECT/DEFAULT_DB_PASSWORD | Encrypted          | 2014-06-23  12:22:36  UTC |
| DB_CONNECT/DEFAULT_DB_USER     | Plaintext          | 2014-06-23  11:18:57  UTC |
|---------------------------------------------------------------------------------|

Summary
-------
Active Records    : 2 (Encrypted : 1, Plain : 1, Wrong Key : 0, Error : 0)
Outdated Records  : 2 (occupied space can be released by the "compact" command)
Former Member
0 Kudos

Hi,

rsecssfx list is perfect , Account lock can be the only reason i can see now , Hopefully it will be fixed .

Good luck !

Regards,

Former Member
0 Kudos

Yes, I ran: alter user sapsr3 account unlock trough sqlplus, then I ran r3trans -d again, there was ORA-01017, so I tried another password for SAPSR3 (I was not sure which one of these two is the correct one) running:

C:\Users\steadm>rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD [2ndPassword]

then r3trans -d ended with zero status.

System still started for 2 seconds (start coulmn of disp+work processes turned to YES), so I switched back to kernel 731 from 740 and now it Works... finally.

Obviously kernel has to be switched sometime later during EHP installation...

Thanks for help.

Regards,

Martin

Reagan
Advisor
Advisor
0 Kudos

If your present BASIS release is lower than 7.40 then kernel 740 wont work.

Former Member
0 Kudos

I tried kernel 740 only to try if it returns same error message as 731 (EDIT: sorry, obviously I meant 721EXT, kernel 731 does not exist) and I forgot to revert it back.

Answers (1)

Answers (1)

Reagan
Advisor
Advisor
0 Kudos

As this is a Windows system I believe you will need to restart Windows after setting the environment variables for the user.