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.

• What is SSFS and How we can add SSFS authentication

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>  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

Table Modification:

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 / -‘;

SQL> commit;
SQL> exit;

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 / -‘;
SQL> commit;
SQL> exit;

Test Brtools with SSFS:

brconnect -u // -c -f check 

it should provide positive result now.