Hi all,

I have been asked one question in oracle database basics
'How to start and shutdown an instance of Oracle ?'

Since i have used only simple SQL statements i couldn't answer that but wanted to know.

I hope this forum will give me answer for this.

If possible give me URL of document relating to basic database administration commands of oracle.

Regards.

You must start of SQL manager tool. To connect as internal user to your DB and execute:
start <DB_sid> - for start of database
shutdown <DB_sid> - for stop of database


The more documentation you can find on http://otn.oracle.com/documentation/database10g.html