Madan Blogs about Technology

Database statup and Shutdown

------------------------------------ DATABASE STARTUP--------------------------
1. Login as root with root password
2. To login as oracle9 user su - oracle9
3. Login in to oracle with /nolog option sqlplus /nolog
4. Login as sysdba with following command at SQL prompt SQL> connect / as sysdba
5. After login your will recieve a message as follow Connected to an idle instance.
6. To start the database issue the following command at SQL prompt SQL> startup
7. After issuing command your should see the following output.
ORACLE instance started.
Total System Global Area 236000476 bytes
Fixed Size 451804 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
8. Exit from SQL prompt SQL> exit
9. Start TNS Listerner process.
10. Change directory to ORACLE_HOME and bin cd $ORACLE_HOME/bin
11. start the listerner using the following command. lsnrctl start
12. Check connectivity using from another machine.

-------------------------------------------------- DATABASE SHUTDOWN--------------------1. Stop the listernet process using the following command lsnrctl stop
2. Login as root with root password
3. To login as oracle9 user su - oracle9
4. Login in to oracle with /nolog option sqlplus /nolog
5. Login as sysdba with following command at SQL prompt SQL> connect / as sysdba
5. After login your will recieve a message as follow Connected
6. Shutdown database in normal way SQL> shutdown
7. After issuing command your should see the following output.
Database closed.
Database dismounted.
ORACLE instance shut down.

posted by MadanMohan Chowdary Ummidi @ 1:05 AM