Raj,

For longer terms I suggest the Oracle Technology Network for Oracle
online documentation.
Please check the next URL:
http://www.oracle.com/technology/documentation/index.html
You can also download the documentation you need.

Your question is replied in the Administrator Guide (Article: Starting
up and shutting down database)
For this arcticle in case of Oracle9i check this links:

shutdown scenarios:
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/start.htm#7871
startup scenarios:
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/start.htm#5974

I hope it helps you.

Bertalan

raj írta:
> Hi DBA Gurus
> Good Moring to Every Body
>
> I am new to oracle Admin works
>
> I have seen the ALTER DATABASE CLOSE AND ALTER DATABASE DISMOUNT
> what is use of these statements over SHUTDOWN IMMEDIATE OR NORMAL
>
> Thanks & Regards,
>
> V. RajaVardhan Reddy
> Database Administrator
> GSS America Infotech Ltd
> Third Floor, Block 'B',
> Cyber Gateway, HITEC City, Madhapur,
> Hyderabad - 500 081. AP. India
> Visit us: http://www.gssamerica.com
>
>
>
> _________________________________________________________________________________________________
>
> Top Diversity Owned Businesses in Illinois (Div100State-2004)
>
> Disclaimer
> This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, w
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>



Oracle LazyDBA home page