DB13 Warning CHECKDB Missing Index Situation

DB13 Warning CHECKDB Missing Index Situation
September 16, 2015 | No Comments »

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.

ORACLE Error “log X of thread X is being cleared, operation not allowed”

ORACLE Error "log X of thread X is being cleared, operation not allowed"
May 18, 2015 | No Comments »

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

DB02 Refresh Issue

DB02 Refresh Issue
February 18, 2015 | No Comments »

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…

SAP system’s Oracle Table Corruption – DBIF_RSQL_SQL_ERROR

SAP system's Oracle Table Corruption - DBIF_RSQL_SQL_ERROR
February 16, 2015 | No Comments »

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…

ORA-03113 : end-of-file on communication channel

ORA-03113 : end-of-file on communication channel
December 31, 2014 | No Comments »

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…

Shrink Option for Oracle Database

Shrink Option for Oracle Database
November 12, 2014 | No Comments »

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…

Open Oracle Alert Log Easily via ADRCI and SAP

Open Oracle Alert Log Easily via ADRCI and SAP
September 05, 2014 | No Comments »

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

ORA-01194: file 1 needs more recovery to be consistent

ORA-01194: file 1 needs more recovery to be consistent
July 31, 2014 | 5 Comments »

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…

ORA-01187: cannot read from file because it failed verification tests

ORA-01187: cannot read from file because it failed verification tests
July 30, 2014 | No Comments »

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…

Flashback Query for Restoring the Table Entries from UNDO

Flashback Query for Restoring the Table Entries from UNDO
July 11, 2014 | No Comments »

If you wrongly delete any table entry from oracle database level and you want to get your data back then you can use this procedure easily…

Finding Corrupt Indexes on Oracle

Finding Corrupt Indexes on Oracle
June 25, 2014 | No Comments »

You can find the corrupted INDEXES via ORACLE database view “v$database_block_corruption”..Let’s check with an example…

Rebuild an Oracle Database Index via SQLPLUS / RSANAORA / BRTOOLS

Rebuild an Oracle Database Index via SQLPLUS  / RSANAORA / BRTOOLS
June 24, 2014 | No Comments »

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…

Rebuild an Index via DB02

Rebuild an Index via DB02
June 19, 2014 | No Comments »

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…

Change SAPSR3 Password via BRTOOLS

Change SAPSR3 Password via BRTOOLS
May 21, 2014 | No Comments »

If you want to change your SAPSR3 users password, it’s so easy to do it via BRTOOLS on operating system level.

ORACLE DB Startup Modes

ORACLE DB Startup Modes
April 26, 2014 | No Comments »

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.

Oracle Datafile Resize

Oracle Datafile Resize
April 24, 2014 | No Comments »

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

DB13 “Checkpoint Not Complete”

DB13 "Checkpoint Not Complete"
April 23, 2014 | No Comments »

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 ;

ORA-12560: TNS:protocol adapter error

ORA-12560: TNS:protocol adapter error
April 09, 2014 | No Comments »

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.

ORA-01123: cannot start online backup; media recovery not enabled

ORA-01123: cannot start online backup; media recovery not enabled
April 06, 2014 | No Comments »

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 ;

ORA-01565 and ORA-27046 Errors

ORA-01565 and ORA-27046 Errors
April 03, 2014 | No Comments »

While tying to START a database sometimes if we are not lucky then we can see the following errors ;

ORA-01565 and ORA-27046

LOCK or UNLOCK SAP Users from Database Level via SQLPlus

LOCK or UNLOCK SAP Users from Database Level via SQLPlus
March 27, 2014 | No Comments »

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 ;

BR0970W Database Alert type: CRITICAL_TABLESPACE : MAX EXTENT

BR0970W Database Alert type: CRITICAL_TABLESPACE : MAX EXTENT
March 24, 2014 | No Comments »

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)”.

CREATE and DROP TEMPFILE from ORACLE Database

CREATE and DROP TEMPFILE from ORACLE Database
March 21, 2014 | No Comments »

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 ?

Blogroll

  • SAP Basis TURKEY