Setup of SSFS secure storage to support BRTOOLS
Here i have explained all the steps ,please follow step by step in order to setup SSFS to support Brtools.
First i’ll recommend to read:Before setup explained in below article should be done before going for SSFS setup for BRTOOLS.
Preparing file system
Create dir rsecssfs/data and rsecssfs/key Under /oracle/SID/security.Make sure to give appropriate permission.
<server:sidadm> mkdir rsecssfs
<server:sidadm> chmod 775 rsecssfs
<server:sidadm> mkdir data
<server:sidadm> mkdir key
<server:sidadm> chmod 777 data key
Result: Directory Structure should look like as below screen:
Create User brt$adm and grant proper permission:
sqlplus / as sysdba
SQL> create user brt$adm identified by <your password>
SQL> grant sapdba, sysdba, sysoper to brt$adm;
if brt$adm is already there in system then use alter command to change password.
Change the password of BRT$ADM user :
execute below command to change password,it’ll change the password and will store it in file system,data and key folder.
brconnect -u / -c -f chpass -o ‘BRT$ADM’ -p <your password> -s brtools
You can also use the new connection method for BR*Tools calls in the CCMS transaction DBACOCKPIT/DB13. To enable this, the option “-u /” must be manually replaced (for example, with transaction SE16) with the option “-u //” in the SAP table SDBAC_DATA (SAP_BASIS releases 7.10, 7.11, 7.20, and 7.30) or SDBAC (other SAP_BASIS releases) in the field PSTRING.
Refer SAP NOTE: 1764043 for more details.
Instead of making the changes manually,Please execute below commands from sqlplus:
For SAP_BASIS releases 7.10, 7.11, 7.20, and 7.30:
SQL> update SAPSR3.SDBAC_DATA set PSTRING = concat(‘-u // -‘, substr(PSTRING, 7)) where DBSYS = ‘ORACLE’ and substr(PSTRING, 1, 6) = ‘-u / -‘;
For other SAP_BASIS releases:
SQL> update SAPSR3.SDBAC set PSTRING = concat(‘-u // -‘, substr(PSTRING, 7)) where DBSYS = ‘ORACLE’ and substr(PSTRING, 1, 6) = ‘-u / -‘;
Test Brtools with SSFS:
brconnect -u // -c -f check
it should provide positive result now.