Changing SAPSR3 password using BRTOOLS

Hi All,

There are times when it becomes compulsory to change the password of SAP Schema User. The older technique involves sql query which is not allowed in SAP enviroment.

The best practice to change SAPSR3 or SAP password is through BRTOOLS utility.

Step1: Login to Server as ORASID user.

Step2: brconnect -u / -f chpass -o -p

Ex: brconnect -u / -f chpass -o SAPSR3 -p new_password

In the above example,

-u / -- option means that authorization will be done from OS level user

SAPSR3 -- Represents Schema user in Normal SR3 system

-p --  New Password

Hope this will help many novice consultants.

Cheers,
Sharib Tasneem

How to change Oracle database parameter using BRTOOLS

Hi All,

You can use BRTOOLS to change Oracle DB parameter.

brspace -u / -f dbparam

Cheers,
Sharib Tasneem

RSORAISQN - Report for improving index Quality in Oracle DB

Hi All,

In this post, I will show users to use SAP report RSORAISQN to improve the index quality of table in Oracle DB. Here we are taking an example of MSEG Table. You can similarly check the index quality of any SAP table.

Note: Please use this report during Off-Peak business hours.

Login to SAP System with appropriate user rights to execute reports.

TX : Se38 - RSORAISQN - Execute.

Step 1: Analysis

You will find a screen as shown below:

Enter the detail as shown in the above example.
Finally Click on execute button and it will ask for a confirmation popup, click "Ok" on that screen.

Step2 : Checking Quality

Once step 1 is done, it will bring you to the main screen as shown above.

Now Enter the detail as shown below to check the index quality of the MSEG table.

And Click on "Execute" button.


The below screen shows, the index quality to of MSEG Table(Example)

If you find index quality to be below 60%, please follow the Step 4 to rebuild it.

Step 3: Improving Index Quality

You can enter the detail as shown below. Please make sure that your ID should be same during analysis.
And click on execute button.

Once, you rebuild the index, you can check to it using Step1 and Step2.

Thanks,
Sharib Tasneem

Error in Phase PREP_INPUT/TOOLVERSION_INI of SUM Tool During EHP5 Upgrade

Error in PREP_INPUT/TOOLVERSION_INI phase while EHP5 Upgrade while using SUM Tool.

Error Log:
++++++++++++++++++++++++++++++++++++++++++++++++++
EXECUTING /usr/sap/SID/SUM/abap/exe/disp+work (disp+work) -V
disp+work: /lib64/libuuid.so.1: no version information available
(required by disp+work)
disp+work: /lib64/libc.so.6: version `GLIBC_2.7' not found (required by
disp+work)
disp+work: /usr/lib64/libstdc++.so.6: version `CXXABI_1.3.3' not found
(required by /usr/sap/SID/SUM/abap/exe/dw_gui.so)
SAPup> Process with PID 19406 terminated with status 1 at
20121007182625!
++++++++++++++++++++++++++++++++++++++++++++++++++
Solution:

Please refer to SAP note 1563102 for its cause and solution

Error in Phase 'PREP_INIT/VALCHK_INI' during EHP5 Upgrade Using SUM Tool

Hi Guys,

We encountered some error during EHP5 Upgrade on our ECC 6.0 System while using SUM Tool.

The Error Log As Follows:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
more VALCHK.LOG
1 ETQ201 Entering upgrade-phase "VALCHK_INI" ("20121008214727")
4 ETQ399 Set environment for standard connect:
2 ETQ367 Connect variables are set for standard instance access
4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000'
4 ETQ399 Environment variables:
4 ETQ399   dbs_ada_schema=SAPSID
4 ETQ399   auth_shadow_upgrade=0
1 ETQ200 Executing actual phase 'PREP_INIT/VALCHK_INI'.
1 ETQ399 Phase arguments:
2 ETQ399 Arg[0] = 'HARD-CHK'
1 ETQ359 RFC Login to: System="SID", AsHost="hostname" Nr="00", GwHost="hostname
", GwService="sapgw00"
2 ETQ232 RFC Login succeeded
4 ETQ010 Date & Time: 20121008214727
1 ETQ233 Calling function module "SUBST_HANDLE_UVERS" by RFC
2 ETQ373 parameter "IV_MODE" = "R"
2 ETQ373 parameter "IV_ALL" = " "
2 ETQ399 Table IT_UVERS (#5):
3 ETQ399 "SAP_ABA","700","","","","",""

,"","","","","",""
3 ETQ399 "SAP_APPL","600","","","","","","","","","","",""
3 ETQ399 "SAP_BASIS","700","","","","","","","","","","",""
3 ETQ399 "SAP_BW","700","","","","","","","","","","",""
3 ETQ399 "SAP_HR","600","","","","","","","","","","",""
1 ETQ234 Call of function module "SUBST_HANDLE_UVERS" by RFC succeeded
4 ETQ010 Date & Time: 20121008214727
2 ETQ374 parameter "EV_LEN" = "102"
2 ETQ399 Table IT_UVERS (#5):
3 ETQ399 "SAP_ABA","700","20121007","194751","20121007","194751","I","A","","700
","","",""
3 ETQ399 "SAP_APPL","600","20121007","194751","20121007","194751","I","A","","60
0","","",""
3 ETQ399 "SAP_BASIS","700","20121007","194751","20121007","194751","I","A","","7
00","","",""
3 ETQ399 "SAP_BW","700","20121007","194751","20121007","194751","I","A","","700"
,"","",""
3 ETQ399 "SAP_HR","600","20121007","194751","20121007","194751","I","A","","600"
,"","",""
1AETQ228 Detected invalid (temporary) start release "SAP_ABA"
1EETQ399 Last error code set is 'SAP_ABA is in an undefined state, that is not s
afe to be upgraded, reason Upgrade wasn't completed - Call the SAP Support'
1EETQ204 Upgrade phase "VALCHK_INI" aborted with severe errors ("20121008214727"

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
To fix this error, Please follow the step below:
Move to the location:
cd /usr/sap/SID/SUM/abap/bin

Execute the command: ./SAPup reset prepare

And then, once this command is executed successfully, delete SUM directory and extract fresh SUM files in the same location and continue.

Cheers,
Sharib

Note: Please refer to SAP notes for more detail.