Updating SAP – MaxDB

December 16th, 2009

Hi there folks, we got it ! this is the procedure

1- BACKUP all the BIN files and working directories for your BD instances

2- BACKUP all the databases, COMPLETE BACKUP !!

3- We where using MaxDB Ver. 7.7.04.028 and the upgrade is 7.7.06.17… so …. go to sap services and download the patches & upgrades for your O.S. and architecture in my case, Power 5, Intel x86_64, Intel x86_64.

4- Got into the servers via SSH ( ‘course ) and become a valid user to stop sap.

5- Get root :D and deflate the file you just download ( SAPCAR -xvf FILE.XXXX.XXXX.XXXX.SAR )

6- Go into the directory that was just created and type this:./SDBUPD -d SDB -u user,password

7- Keep an eye on it ’cause this is the way !!… all the bin files are parsed and/or replaced .. if you see: installation was sucessfull !! YOU ARE DONE !

8- Database changes from OFLINE to ONLINE and set using ADMIN user

9- Now use the user that you used below .. non root … and Stop the database instance ( stopdb )

10- Using this user start sap !! wait a little and start the GUI or go trough DB-CLI ( Remember, all the transactions needs to be recompiled so … do not lost patient )

11- Do the same in other servers !

That’s it !! We are DONE !

Leave a Reply