LOCK or UNLOCK SAP Users from Database Level via SQLPlus

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

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 ?

Check Version Information of Oracle Database

Check Version Information of Oracle Database
March 19, 2014 | No Comments »

We can easly find our ORACLE database version via SAPGui like below ;

SAPGUI –> System –> Status

Oracle Database Backupmode Control

Oracle Database Backupmode Control
March 12, 2014 | No Comments »

We can check our database’s tablespace or datafile status is in BACKUPMODE or Not with the following sql syntax ;

Blogroll