If you are getting warning situation for your CHECKDB operation as a result and issue is related to “Missing Index” situation then you can check this note to eliminate this condition.
If you are getting an error message like “log X of thread X is being cleared, operation not allowed” while trying to reset your database logs especially after database copy operations then you can use the “clear unarchived logfile group” option to solve the issue..
If you changed something on database level of your SAP system , DB02 transaction couldn’t realize that immediately.. If you need this then check the steps below…
If you get an error message “DBIF_RSQL_SQL_ERROR” with “SQL error in the database when accessing a table” detail information in your ST22 transaction then you should check the following steps for this issue…
If your SAP system “HANGS or DOWN” due to error message of “ORA-03113 : end-of-file on communication channel” then you should check the following steps to find figure out what is going on…
If you delete some records in a SAP database table , it is a good option to make a “Shrink” operation on database level.You can do this online and easly with Oracle 11G like shown below…
If you need to check ORACLE’s “Alert Log” and you don’t want to use SQLPLUS or you don’t have Authorization to connect ORACLE database then you can use the following ways to do this..
If you got an error “ORA-01194: file 1 needs more recovery to be consistent” after the SQL command “alter database open resetlogs” you should check the related solution before trying anything else…
If you get an error like “ORA-01187: cannot read from file because it failed verification tests” after any homogenenous system copy operation on ORACLE database then you should check this article…
You can find the corrupted INDEXES via ORACLE database view “v$database_block_corruption”..Let’s check with an example…
When you are required to rebuild an index that is in an unusable, missing, or bad index status then you can use several tools like i would like to share with you below…
If you want to rebuild an index over SAP system then you can use the DB02 transaction for this operation….Let’s see the steps…
If you want to change your SAPSR3 users password, it’s so easy to do it via BRTOOLS on operating system level.
Let’s remember the ORACLE database startup options.
NOMOUNT : If we choose “nomount” option to start our ORACLE database , system first read “init.ora” file to get database configuration and related parameters thus database can start background processes.
Sometimes we get a message from DB13 “Check DB” operaion like ;
BR0970W Database administration alert – level: WARNING, type:
TABLESPACE_FULL, object: PSAPSR3DB, value: 95.46% (> 95%)
If you get “Checkpoint Not Complete” message from your “Alert.log” via DB13 tcode, it means that probably your REDOLOG file sizes are smaller than the oracle db needed.
DB13 tcode show us following screen in case of situation ;
Usually we get this error if Oracle Client dosen’t know which database to connect according to “TNS Alias” information.
To control to status firstly we should check the connection manually over SQLPLUS with the related Oracle user.
Sometimes when we trying to start “Online Backup” on our ORACLE/SAP system we get an error like “ORA-01123: cannot start online backup; media recovery not enabled”
For Oracle Version 10g and 11g please use the following syntax on SQLPlus ;
While tying to START a database sometimes if we are not lucky then we can see the following errors ;
ORA-01565 and ORA-27046
If you exceed the value of parameter “FAILED_LOGIN_ATTEMPTS” when trying to logon ORACLE database with wrong password then your oracle account will be locked and you will get the “ORA-28000:the account is locked” message..
If we can reach the SAP system from database via SQLPLUS tool then we can lock or unlock any SAP users without the SAPGUI
Let’s look a little bit closer with some examples ;
After DB13 – CHECKDB operation we could see the message like below ;
“BR0970W Database administration alert – level: WARNING, type: CRITICAL_FILE, object: N:\ORACLE\SID\SAPDATA3\ROLL_3\ROLL.DATA3, value: (max_extn) 146021 KB (> 111239 KB)”.
In this section you will find how can we CREATE and DROP tempfiles from ORACLE database
For an example , what we can do if a TEMPFILE was deleted wrongly from the operating system level ?