DB02 statistics blank

If I’m not mistaken, display for DB02 is changed from SAP Netweaver 7.0  SP12 into a kind of DB Cockpit which also can be accessed from tx code ST04, DB13, DB14, and some DB transactions. After a Support Package upgrade or refresh sometimes it’s not displayed properly or blank as displayed below :

In my case, [...]

DB13 – errno 13: Permission Denied

Problem
You found this error in DB13 Job Log :
Job started
Step 001 started (program RSDBAJOB, variant &0000000000053, user ID SAPBASIS)
Execute logical command BRCONNECT On host sapdev00
Parameters: -u / -jid CHECK20090710123233 -c -f check
BR0801I BRCONNECT 7.00 (18)
BR0252W Function fopen() failed for ‘/oracle/DEV/102_64/dbs/initDEV.ora’ at location BrInitOraCopy-2
BR0253W errno 13: Permission denied
BR0252E Function fopen() failed for ‘/oracle/DEV/sapcheck/ceazhwgd.chk’ at location main-9
BR0253E [...]

Change Password of Database User

This is the command to change password of Oracle Database User :
From BRTOOLS= BRTOOLS -> 8 – Additional functions -> 4 – Change password of database user -> continue, then you can type your new password as below (ex, SID = DEV):
BR0801I BRCONNECT 7.00 (18)
BR0280I BRCONNECT time stamp: 2009-07-14 01.52.04
BR0263I Enter password for database user [...]

Split Destination Directory in Backup

This is just a little tips about Backup activity. When you are running out spaces in your destination directory and you still have space in another directory, so what will you do to split your backup into one or more directory (or different drive) ?
Some of you might not notice that there are numbers of [...]

New BR*Tools Feature in SAP Netweaver 7.1

In SAP Netweaver 7.1 you can find the following features of BR*Tools :

Verification of database and archive log files with RMAN ( BR*Tools 7.00 patch 22 ) which affects :
o BRARCHIVE -w|-verify use_rmv|first_rmv|only_rmv
o BRBACKUP -w|-verify use_rmv|only_rmv
o BRRESTORE -w|-verify use_rmv
Support for Oracle Data Pump like export and import ( BRSPACE patch 17 ) which affects :
o [...]

Reorganize Table in SAP

Why do we need to reorganize table in SAP system ?
This is the important question before we plan to reorganize table in SAP system. Since Data Management Strategy is the key factor to boost system performance and and to keep data accessibility more efficient, we need to maintain or oraganize the data itself. One [...]