on 06-23-2014 2:15 PM
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?
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
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
As this is a Windows system I believe you will need to restart Windows after setting the environment variables for the user.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.