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..
Everything About SAP Basis
-
Automatically Reorganizing Short Dumps In order to clean the shortdumps in the system with certain criteria, the “SAP_REORG_ABAPDUMPS” job (Program Name : RSSNAPDL)...
-
Reset the password of user Administrator of SAP Cloud Connector Reset the password of user Administrator of SAP Cloud Connector - Stop the SAP Cloud Connector Service with the following command; #service...
-
Dumps after SPAM aborts while Importing SAP Support Package If the SPAM transaction is canceled or there is a connection interruption during the transfer of SAP Support Packages, errors as stated below may...
-
SAP HotNews : RSPO1043 detects false inconsistencies and deletes spool requests If you are storing ADS spool requests in the database and not in the default way in the filesystem or you are on one of this SPs or higher ; ...
-
SAP extends support deadline for getting off legacy software SAP has announced an extension for support for legacy systems for certain customers who sign up for specific ERP cloud migration deals. ...
-
500 Internal Server Error via Web Browser When trying to open a web browser-based screen via a transaction code in SAP, a “500 Internal Server Error” error may be received. ...
-
Asking and Answering Questions in the SAP Community SAP provides a convenient channel through which you can ask questions about any SAP topic. Before asking a question, you can also browse the...
-
Performance Issues on ABAP Stack Today we are going to check performance issues on ABAP stack…The system may be up and running, but performance issues will hurt...
-
What is RISE with SAP ? RISE with SAP is a “Business Transformation as a Service (BTaaS) product that focuses on shifting customers into the SAP cloud product...
-
SAP Spool : “Waiting in host spooler (Position 1)” When you get an issue on printing side of your SAP system and you found the error “Waiting in host spooler (Position 1)” then you can...
LOCK or UNLOCK SAP Users from Database Level via SQLPlus
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
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
-
Automatically Reorganizing Short Dumps
-
Reset the password of user Administrator of SAP Cloud Connector
-
Dumps after SPAM aborts while Importing SAP Support Package
-
SAP HotNews : RSPO1043 detects false inconsistencies and deletes spool requests
-
SAP extends support deadline for getting off legacy software
-
500 Internal Server Error via Web Browser
-
Asking and Answering Questions in the SAP Community
-
Performance Issues on ABAP Stack
-
What is RISE with SAP ?
-
SAP Spool : “Waiting in host spooler (Position 1)”