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 ;
Everything About SAP Basis
-
Huge difference by table TST03 between Memory allocation
Sometimes table TST03 can appear to be very large with it’s LOB segment, in this case, we need to check and compare the...
-
SAP extends support for Business Suite 7 from 2025 to 2027
SAP will provide mainstream maintenance for core applications of SAP Business Suite 7 software until the end of 2027 followed by optional extended...
-
DB Statistics on ORACLE Databases – RTCCTOOL Error for DVM
You can get the “DB Statistics on ORACLE Databases” error while executing RTCCTOOL on your SAP system with the DVM subject and the...
-
You Cannot Use a Request of This Type
When you want to save some changes to a transport request, then the error “You cannot use request SIDKXXXXX” happens and the transport...
-
Enabling SNOTE for Digitally Signed SAP Notes for 740 and Above
SAP recognizes a security threat during upload of SAP Note into customer landscape. The SAP Note can get modified maliciously and the customer can...
-
Enabling the System for SAP Note Transport-based Correction Instruction Rollback
You can rollback TCI similar to regular SAP Notes from Note Assistant. To do this, you first enable or update SNOTE for TCI rollback as follows,...
-
Enabling SNOTE for Transport-based Correction Instructions
SAP Note transport-based correction instruction (TCI) is a new way to deliver ABAP correction instructions to customer in a flexible manner. ...
-
SAP Technical Communication User for SAPHUB Connection
SAP provides a communication channel between SAP systems and SAP backbone systems, to be able to use this communication channel, customers must...
-
ERROR: program IGS.
not registered Sometimes you may get an error about IGS (Internet graphics server), in this case you can check your IGS status and if needed restart your IGS like...
-
The Central Inventory is Corrupted while Oracle Patch Installation
You can get an error message like “The Central Inventory is Corrupted” while installing the oracle patch operation, in this case you can...
BR0970W Database Alert type: CRITICAL_TABLESPACE : MAX EXTENT
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
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 ?
Check Version Information of Oracle Database
We can easly find our ORACLE database version via SAPGui like below ;
SAPGUI –> System –> Status
Oracle Database Backupmode Control
We can check our database’s tablespace or datafile status is in BACKUPMODE or Not with the following sql syntax ;
Featured Posts
-
Huge difference by table TST03 between Memory allocation
-
SAP extends support for Business Suite 7 from 2025 to 2027
-
DB Statistics on ORACLE Databases – RTCCTOOL Error for DVM
-
You Cannot Use a Request of This Type
-
Enabling SNOTE for Digitally Signed SAP Notes for 740 and Above
-
Enabling the System for SAP Note Transport-based Correction Instruction Rollback
-
Enabling SNOTE for Transport-based Correction Instructions
-
SAP Technical Communication User for SAPHUB Connection
-
ERROR: program IGS.
not registered -
The Central Inventory is Corrupted while Oracle Patch Installation
Recent Comments