
Oracle


Managing Oracle Instance
Oracle Database Startup Modes NOMOUNT MOUNT OPEN RESTRICT FORCE The first two( NOMOUNT and MOUNT) is known as maintenance mode. OPEN is general startup mode. Only DBAs can startup the instance in RESTRICT mode and access the database, other users […]

Unlock/Lock HR account in Oracle 11g
It is possible that you might forget to unlock the HR account while installation at the Password Management section. ALTER USER HR ACCOUNT UNLOCK IDENTIFIED BY S0m3P@ssw0rD; In order to execute this command, the user must have privilege of SYSDBA. For […]