Before you read this article, I suggest you read the article “What is logging_clause On Oracle (LOGGING or NOLOGGING)” to better understand the concept of …
Read More »ORACLE
How to Restart the Oracle Database
For restart operation, we must stop and start the Oracle database. In this article we will show the below scenarios; stop an instance of …
Read More »Undo Advisor(OEM)
You can use Undo Advisor to set UNDO_RETENTION and the required undo tablespace size. You can open the Undo Advisor using the Database-> Diagnose-> …
Read More »How To Get User’s Password With Hash On Oracle 12c
In this article, I will show you how to get a user’s create script in Oracle12c, with the hash of the password. We may …
Read More »ORA-28001: the password has expired
When the user password expires, we get the error “ORA-28001: the password has expired“. The expiration date of the user’s password is defined in …
Read More »ORA-01555 Snapshot Too Old / ORA-30036: unable to extend segment by string in undo tablespace
ORA-01555 Snapshot Too Old The “ORA-01555 Snapshot Too Old” error usually comes in long-running queries. In Oracle, previous changes of the data are retained in …
Read More »Automatic Undo Management On Oracle
To run the database in automatic undo management mode, you must set undo_management to auto from the oracle startup parameters. You can use …
Read More »How To Create an Oracle Password File
The Oracle password file is a file that is created automatically during installation. Users defined in this file can connect to oracle via sqlplus without …
Read More »How To Create Tablespace On Oracle
Tablespaces are areas dedicated to storing objects in the database. Tablespaces are logical constructs. However, it contains physical data files or temp files. There are …
Read More »How To Create a User/Schema On Oracle
User and schema creation operations are the same in Oracle. When you create a user, a schema is automatically created for the user. Each …
Read More »