Oracle Database Startup Process (2/2) [You are Here]
5. Once you are at mounted state you will able to query selected Oracle management view, in this case we can see the state of the database.
The command is
SELECT name, open_mode FROM v$database;
6. Now we going to upgrade the state to open state. The command is ALTER DATABASE OPEN;
7. Again to see the state of the database we can use the query from step 5. SELECT name, open_mode FROM v$database;
As you can see that I am now at READ WRITE, that is mean I am Open READ WRITE. As I mentioned earlier there are three types of open state mode, READ WRITE, READ ONLY and RESTRICTED.
8. Above all are the stage of Oracle database startup, you don't have to jump from one state to another, I just demonstrate to you to show you different type of startup stage.
Normally you just need to issue command STARTUP to startup the database at open stage.
Now I am shutdown my database and perform normal startup.
As you can see in order for the Oracle database to go to OPEN state Oracle will go through 3 stages, Nomount, Mounted then Open. (I drew 1, 2, 3)
So STARTUP command will perform all three stages.
In short how to startup Oracle database.
1. login as oracle account
sqlplus "/as sysdba"
2. at SQL prompt
startup
Please note:
Once the database at higher stage it will not be able to go back to lower stage, for example from mount state to nomount state, or from open state to mount or to nomount state, the only way to go to lower state is by shutdown the database and startup again.
Oracle Database Startup Process (1/2)
Oracle Database Startup Process (2/2) [You are Here]
