on 12-29-2014 4:59 AM
Hi,
Could you upgrade kernel 720 with 720_EXT and recheck SSFS connection again.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pooja,
As i replied earlier first you need to configure SSFS database connection properly for the source kernel as well,for that you could refer earlier mentioned SCN doc and can refer SAP Notes 1622837 - Secure connection of AS ABAP to Oracle via SSFS
2097613 - Database is running with inconsistent Secure Storage File System (SSFS)
1905775 - SSFS connection is not working
Hope this will help you.
Regards,
Gaurav Rana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Supply the output of these commands.
su - qasadm
/usr/sap/trans/ehp7/SUM/abap/exe/tp -v
/usr/sap/trans/ehp7/SUM/abap/exe/R3trans -v
/oracle/client/11x_64/instantclient/genezi -v
R3trans -d
cat trans.log
4 ETW000 [dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read
sapqas:qasadm 61> cd data
sapqas:qasadm 62> ll
total 32
-rwxrwxrwx 1 qasadm sapsys 29 Dec 27 20:39 JUpgrade.key
-rwxrwxrwx 1 qasadm sapsys 195 Dec 27 20:39 JUpgrade.properties
The file /usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT is not present at that location then there is no point in providing the full permission.
Thanks
RB
Message was edited by: Reagan Benjamin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Reagan,
I have check all below log.
sapqas:qasadm 21>
sapqas:qasadm 21> cd /usr/sap/trans/ehp7/SUM/abap/exe/
sapqas:qasadm 22> tp -v
This is tp version 380.10.20 (release 720, unicode enabled)
--------------------
tp information
--------------------
kernel release 720
kernel make variant 720_REL
DBMS client library OCI_102,
DBSL shared library version 720.00
compiled on HP-UX B.11.23 U ia64 for hpia64
compiled for 64 BIT
compilation mode UNICODE
compile time Mar 9 2014 21:13:22
update level 0
patch number 526
source id 0.600
sapqas:qasadm 23> R3trans -v
This is R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).
unicode enabled version
--------------------
R3trans information
--------------------
kernel release 720
kernel make variant 720_REL
DBMS client library OCI_102,
DBSL shared library version 720.00
compiled on HP-UX B.11.23 U ia64 for hpia64
compiled for 64 BIT
compilation mode UNICODE
compile time Mar 9 2014 21:13:22
update level 0
patch number 525
sapqas:qasadm 24> cd /oracle/client/11x*
sapqas:qasadm 28> genezi -v
Client Shared Library 64-bit - 11.2.0.3.0
System name: HP-UX
Release: B.11.31
Version: U
Machine: ia64
Operating in Instant Client mode.
Small timezone file = timezone_14.dat
Large timezone file = timezlrg_14.dat
sapqas:qasadm 29>
sapqas:qasadm 38> pwd
/sapmnt/QAS/global/security/data
sapqas:qasadm 39> ll
total 64
-rwxrwxrwx 1 qasadm sapsys 29 Dec 27 20:39 JUpgrade.key
-rwxrwxrwx 1 qasadm sapsys 195 Dec 27 20:39 JUpgrade.properties
-rw-rw-rw- 1 qasadm sapsys 8854 Dec 29 16:01 trans.log
sapqas:qasadm 40>
But in this SSFS_QAS.DAT file does not exist in /sapmnt/QAS/global/security/data
and i have give full permission on /sapmnt/QAS/global/security/data.
Regards
Dear Pooja,
as already said by Gaurav Kumar Pandey you need the kernel version 740/741/742 in the upgrade directory if you would like to go to EHP7.
Please check which kernel is valid according to note #1969546 (Release Roadmap Kernel 740) and switch the kernel. Afterwards please repeat the upgrade.
Cheers,
Andreas
Your commands are wrong and they are not executed in the way I suggested you.
There is a difference in the way I asked you and the way you are executing it.
Andreas - The commands are not run in the way it should be executed so it is not confirming the kernel used by the shadow system is based on 740/741 release or not.
If the file SSFS_QAS.DAT is missing then the SSFS is not set correctly. First set the SSFS correctly.
Hello Pooja,
You used commands :
sapqas:qasadm 21> cd /usr/sap/trans/ehp7/SUM/abap/exe/
sapqas:qasadm 22> tp -v
#### if the path is not set properly them it might still pick the tp from main instance directory only.
Can you use :
sapqas:qasadm 21> /usr/sap/trans/ehp7/SUM/abap/exe/tp -v
or
sapqas:qasadm 21> cd /usr/sap/trans/ehp7/SUM/abap/exe/tp -v
sapqas:qasadm 22> ./tp -v
Regards,
Gaurav
Dear gaurav,
Its tp version
sapqas:qasadm 24> cd /usr/sap/trans/ehp7/SUM/abap/exe/
sapqas:qasadm 25> tp -v
This is tp version 380.10.20 (release 720, unicode enabled)
--------------------
tp information
--------------------
kernel release 720
kernel make variant 720_REL
DBMS client library OCI_102,
DBSL shared library version 720.00
compiled on HP-UX B.11.23 U ia64 for hpia64
compiled for 64 BIT
Regards
Dear Adreas,
I done below activity for Secure Storage File System
Create new directories with qasadm
cd /usr/sap/SID/SYS/global
mkdir /usr/sap/SID/SYS/global/security
mkdir /usr/sap/SID/SYS/global/security/rsecssfs
mkdir /usr/sap/SID/SYS/global/security/rsecssfs/data
mkdir /usr/sap/SID/SYS/global/security/rsecssfs/key
Set authorizations on directories with qasadm
cd /usr/sap/SID/SYS/global
chmod 700 security
chmod 700 security/rsecssfs
chmod 700 security/rsecssfs/data
chmod 700 security/rsecssfs/key
Set Default profile parameters via OS Level RZ10
In the default profile, add following parameter:
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
Set environment Variables in these two file /home/qasadm>
.sapenv.sh and .sapenv.csh
vi .sapenv.sh
At the end of the file add lines :
export RSEC_SSFS_DATAPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/data
export RSEC_SSFS_KEYPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/key
rsdb_ssfs_connect=1
vi .sapenv.csh
At the end of the file add lines :
setenv RSEC_SSFS_DATAPATH /usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/data
setenv RSEC_SSFS_KEYPATH /usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/key
setenv rsdb_ssfs_connect 1
sapqas:qasadm 65> rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPSR3 -plain
SAP-Profile is not used; in this case, all three environment parameters SAPSYSTEMNAME, RSEC_SSFS_DATAPATH and RSEC_SSFS_KEYPATH must exist and have non-initial values
sapqas:qasadm 66> ll
sapqas:qasadm 71> pwd
/home/qasadm
sapqas:qasadm 72> rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD abcdefg
SAP-Profile is not used; in this case, all three environment parameters SAPSYSTEMNAME, RSEC_SSFS_DATAPATH and RSEC_SSFS_KEYPATH must exist and have non-initial values
sapqas:qasadm 73>
But my SAP is not starting . Plz find last few lines of trans log
4 ETW000 [ dev trc,00000] New connection 0 created 26 0.445108
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = N
O , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 8186 0.453294
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 7283 0.460577
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 27 0.460604
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 33 0.460637
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 24 0.460661
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 53 0.460714
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 25 0.460739
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0
4 ETW000 849 0.461588
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 52 0.461640
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 69 0.461709
4 ETW000 ==> Using default key set to get connect info from ssfs
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 41 0.461750
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 872] 29115 0.490865
4 ETW000 [ dev trc,00000] Mon Dec 29 14:41:45 2014 71566 0.562431
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 4353]
4 ETW000 37 0.562468
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read
[rsecssfs.c 2535]
4 ETW000 5923 0.568391
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Data file "/usr/sap/QAS/SYS/glob
al/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read) [rsecssfs.c 936]
4 ETW000 105 0.568496
4 ETW000 [dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/QAS/S
YS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read
4 ETW000 6506 0.575002
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 26 0.575028
4 ETW000 [dbcon.c ,00000] *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS
4 ETW000 46 0.575074
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 8199 0.583273
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 94 0.583367
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 366 0.583733
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 71 0.583804
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 775 0.584579
4 ETW000 [ dev trc,00000] -> 'OCI_102, ' 353 0.584932
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"
sapqas:qasadm 23>
Regards
Dear Andreas,
Should I download these new kernel 7.41 as given below path and copy /usr/sap/trans/ehp7/
SAP KERNEL 7.41 64-BIT UNICODE -> HP-UX on IA64 64bit -> #Database independent
HP-UX on IA64 64bit
Database independent
SAPEXE_100-10012461.SAR Kernel Part I 100 Info 580086
SAPEXEDB_100-10012462.SAR Kernel Part 100 Info 26417
Then Our SAP Can Start.
Regards
Dear Pooja,
"/usr/sap/trans/ehp7/SUM/abap/exe/" represents the target release kernel. If you switch to that directory and run "tp - v" then you will see the tp version of that tp which is maintained in your path variable first.
If you would like to have the output of a specific directory then you have to switch to it (cd /usr/sap/trans/ehp7/SUM/abap/exe/) and run the statement with a "./" before the TP call.
So it should not be "sapqas:qasadm 25> tp -v", but "sapqas:qasadm 25> ./tp -v".
Best regards,
Andreas
Dear Andreas,
Currentyly our SP Level is as given belwo
SAP_BASIS | 700 | 0027 | SAPKB70027 |
SAP_ABA | 700 | 0027 | SAPKA70027 |
PI_BASIS | 2006_1_700 | 0017 | SAPKIPYM17 |
ST-PI | 2008_1_700 | 0007 | SAPKITLRD7 |
SAP_BW | 700 | 0029 | SAPKW70029 |
SAP_AP | 700 | 0028 | SAPKNA7028 |
SAP_APPL | 600 | 0016 | SAPKH60016 |
SAP_HR | 600 | 0096 | SAPKE60096 |
Kernal Release 720 patch level 401
Regards
Hi Pooja,
*** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS
SSFS is fine here,now you just need to check with the permissions on the directories as well as on the SSFS files,as connection is failing on retrieve of user password from the SSFS .Kindly follow SCN doc and check your SSFS steps again.
After that retry with R3trans -d to get output 0000.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pooja,
Error shows database connection is not successful,if possible share output for R3trans -d with trans.log file.Also try to configure SSFS database connection methods for the further processes.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Gaurav,
When I check
sapqas:qasadm 21> R3trans -d
This is R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"
R3trans finished (0012).
sapqas:qasadm 22> pwd
sapqas:qasadm 24> more trans.log
a57y0C4 ETW000 R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 29.12.2014 - 14:41:44
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] Mon Dec 29 14:41:44 2014 44035 0.044035
4 ETW000 [ dev trc,00000] db_con_init called 8006 0.052041
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 15032 0.067073
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 6029 0.073102
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 24 0.073126
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' ... 13148 0.086274
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/QAS/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 299458 0.385732
4 ETW000 [ dev trc,00000] Library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' loaded 37 0.385769
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 84 0.385853
4 ETW000 [ dev trc,00000] Version of '/usr/sap/QAS/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.522)
4 ETW000 56555 0.442408
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 368 0.442776
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 763 0.443539
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 936 0.444475
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 49 0.444524
4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 49 0.444573
4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 61 0.444634
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 385 0.445019
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 32 0.445051
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 31 0.445082
4 ETW000 [ dev trc,00000] New connection 0 created 26 0.445108
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = N
O , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 8186 0.453294
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 7283 0.460577
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 27 0.460604
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 33 0.460637
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 24 0.460661
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 53 0.460714
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 25 0.460739
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0
4 ETW000 849 0.461588
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 52 0.461640
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 69 0.461709
a57y0CdBtrans.log (66%)d@a57y0Ca57y0C4 ETW000 ==> Using default key set to get connect info from ssfs
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 41 0.461750
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 872] 29115 0.490865
4 ETW000 [ dev trc,00000] Mon Dec 29 14:41:45 2014 71566 0.562431
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 4353]
4 ETW000 37 0.562468
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read
[rsecssfs.c 2535]
4 ETW000 5923 0.568391
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Data file "/usr/sap/QAS/SYS/glob
al/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read) [rsecssfs.c 936]
4 ETW000 105 0.568496
4 ETW000 [dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/QAS/S
YS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read
4 ETW000 6506 0.575002
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 26 0.575028
4 ETW000 [dbcon.c ,00000] *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS
4 ETW000 46 0.575074
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 8199 0.583273
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 94 0.583367
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 366 0.583733
4 ETW000 [ dev trc,00000] --DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 71 0.583804
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 775 0.584579
4 ETW000 [ dev trc,00000] -> 'OCI_102, ' 353 0.584932
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"
a57y0CdBtrans.log: ENDd@
Regards
Dear Gaurav,
sapqas:qasadm 30> tp -v
This is tp version 380.10.20 (release 720, unicode enabled)
--------------------
tp information
--------------------
kernel release 720
kernel make variant 720_REL
DBMS client library OCI_102,
DBSL shared library version 720.00
compiled on HP-UX B.11.23 U ia64 for hpia64
compiled for 64 BIT
compilation mode UNICODE
compile time Mar 9 2014 21:13:22
update level 0
patch number 526
source id 0.600
sapqas:qasadm 31> R3trans -v
This is R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).
unicode enabled version
--------------------
R3trans information
--------------------
kernel release 720
kernel make variant 720_REL
DBMS client library OCI_102,
DBSL shared library version 720.00
compiled on HP-UX B.11.23 U ia64 for hpia64
compiled for 64 BIT
compilation mode UNICODE
compile time Mar 9 2014 21:13:22
update level 0
patch number 525
source id 0.600
Regards
Hi Pooja,
Provide the permission on the file SSFS_QAS.DAT
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read
[rsecssfs.c 2535]
4 ETW000 5923 0.568391
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Data file "/usr/sap/QAS/SYS/glob
al/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read) [rsecssfs.c 936]
4 ETW000 105 0.568496
4 ETW000 [dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/QAS/S
YS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read
Then check the same with R3trans -d option again.
With Regards
Ashutosh Chaturvedi
Hello Pooja,
I would recommend to update the kernel in the ../abap/exe/ directory with latest one available on SMP. You said that you are upgrading the system to EHP7 so i believe the target kernel should be
740 or 741 or 742 based on your target SPS level.
1969546 - Release Roadmap Kernel 740
Regards,
Gaurav
Dear Ashutosh,
I have given full permission on below link
usr/sap/QAS/SYS/global/security/rsecssfs/
sapqas:qasadm 57> chmod -R 777 security
sapqas:qasadm 58> ll
total 7808
drwxrwx--- 2 qasadm sapsys 73728 Dec 29 15:33 000JOBLG
drwxrwx--- 2 qasadm sapsys 8192 Aug 7 00:30 500BDCLG
drwxrwx--- 2 qasadm sapsys 368640 Dec 29 15:55 500JOBLG
drwxrwx--- 2 qasadm sapsys 96 Dec 28 00:01 500TEST0
-rw-r--r-- 1 qasadm sapsys 0 May 11 2014 ABAPPROT
-rw-r--r-- 1 qasadm sapsys 1522848 May 17 2014 SLOGJ
-rw-r--r-- 1 qasadm sapsys 1999840 May 15 2014 SLOGJO
-rw-r--r-- 1 qasadm sapsys 272 May 11 2014 ms_acl_info
drwxr-xr-x 2 qasadm sapsys 96 Dec 23 14:56 sapcontrol
drwxrwxrwx 5 qasadm sapsys 96 Dec 23 12:31 security
sapqas:qasadm 59> cd security
sapqas:qasadm 60> ll
total 0
drwxrwxrwx 2 qasadm sapsys 96 Dec 27 20:39 data
drwxrwxrwx 3 qasadm sapsys 96 May 11 2014 lib
drwxrwxrwx 4 qasadm sapsys 96 Dec 23 12:32 rsecssfs
sapqas:qasadm 61> cd data
sapqas:qasadm 62> ll
total 32
-rwxrwxrwx 1 qasadm sapsys 29 Dec 27 20:39 JUpgrade.key
-rwxrwxrwx 1 qasadm sapsys 195 Dec 27 20:39 JUpgrade.properties
sapqas:qasadm 63> R3trans -d
This is R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"
R3trans finished (0012).
sapqas:qasadm 64>
But same error code comes.
Regards
Jagdish Kumar
Hi Jagdish,
Paste the trans.log file.
Kindly check the profile parameter
Set Profile parameters
****Take backup of DEFAULT.PFL****
In the default profile, add following parameter :
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
Environment varaible
export RSEC_SSFS_DATAPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/data
export RSEC_SSFS_KEYPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/key
rsdb_ssfs_connect=1
If all the above parameters are sets then rerun the below two commands
rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPSR3 -plain
rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD *****
Also do follow the steps suggested by Former Member
With Regards
Ashutosh Chaturvedi
Dear Ashutosh,
Please find the trans log
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] Mon Dec 29 14:41:44 2014 44035 0.044035
4 ETW000 [ dev trc,00000] db_con_init called 8006 0.052041
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 15032 0.067073
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 6029 0.073102
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 24 0.073126
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' ... 13148 0.086274
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/QAS/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 299458 0.385732
4 ETW000 [ dev trc,00000] Library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' loaded 37 0.385769
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 84 0.385853
4 ETW000 [ dev trc,00000] Version of '/usr/sap/QAS/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.522)
4 ETW000 56555 0.442408
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 368 0.442776
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 763 0.443539
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 936 0.444475
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 49 0.444524
4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 49 0.444573
4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 61 0.444634
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 385 0.445019
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 32 0.445051
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 31 0.445082
4 ETW000 [ dev trc,00000] New connection 0 created 26 0.445108
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 8186 0.453294
43y0CBtrans.log (48%)@43y0C43y0C4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 7283 0.460577
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 27 0.460604
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 33 0.460637
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 24 0.460661
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 53 0.460714
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 25 0.460739
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0
4 ETW000 849 0.461588
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 52 0.461640
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 69 0.461709
4 ETW000 ==> Using default key set to get connect info from ssfs
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 41 0.461750
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 872] 29115 0.490865
4 ETW000 [ dev trc,00000] Mon Dec 29 14:41:45 2014 71566 0.562431
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 4353]
4 ETW000 37 0.562468
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read [rsecssfs.c 2535]
4 ETW000 5923 0.568391
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read) [rsecssfs.c 936]
4 ETW000 105 0.568496
4 ETW000 [dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read
4 ETW000 6506 0.575002
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 26 0.575028
4 ETW000 [dbcon.c ,00000] *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS
4 ETW000 46 0.575074
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 8199 0.583273
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 94 0.583367
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 366 0.583733
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 71 0.583804
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 775 0.584579
4 ETW000 [ dev trc,00000] -> 'OCI_102, ' 353 0.584932EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"
43y0CBtrans.log: END@43y0C43y0C@sapqas:qasadm 23>
I was not able to set below parameter in Default Profile . Right now my SAP Instance is not running.
Default Profile:=
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
I have set below environment in .sapenv.sh
Please find last seven line of .sapenv.sh
Environment varaible in /home/qasadm>tail -7 .sapenv.sh
fi
done
fi
export SEC_SSFS_DATAPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/data
export RSEC_SSFS_KEYPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/key
rsdb_ssfs_connect=1
end SAP R/3 Environment
sapqas:qasadm>
Please suggest
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.