“Upgrade is running! No import possible” in ACT_UPG

"Upgrade is running! No import possible" in ACT_UPG
March 20, 2022 | 3 Comments »

If the SAP system in upgrade mode and no import possible, then you can use the following database query on the “UVERS” table.

Read More

DB Statistics on ORACLE Databases – RTCCTOOL Error for DVM

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM
February 06, 2020 | 1 Comment »

You can get the “DB Statistics on ORACLE Databases” error while executing RTCCTOOL on your SAP system with the DVM subject and the following details.

Read More

The Central Inventory is Corrupted while Oracle Patch Installation

The Central Inventory is Corrupted while Oracle Patch Installation
November 28, 2019 | No Comments »

You can get an error message like “The Central Inventory is Corrupted” while installing the oracle patch operation, in this case you can start the check with “inventory.xml” file like shown in this post…

Read More

HANA Backup Filename, Destination and Size Informations

HANA Backup Filename, Destination and Size Informations
September 11, 2018 | No Comments »

You can check the SAP HANA backup Destination Path, Backup Size, Destination Type etc. informations via below SQL script.

Read More

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.

Read More

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

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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

Read More

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

ORA-01194: file 1 needs more recovery to be consistent
July 31, 2014 | 7 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…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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.

Read More

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.

Read More

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

Read More

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 ;

Read More

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.

Read More

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 ;

Read More

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

Read More

Page 1 of 212»

Recent Posts

Meta

Blogroll