which starts the database up during system startup process. (It is a .com file that invokes .sql file that connects internal and starts up the DB).
Something like that stands in a shutdown file (and it closes the database) - only, be careful to leave enough time for database to close before system shuts down.
If your system runs under Windows, use "Scheduled Tasks"; write a script that will start up your database and schedule it "At System Startup". I wouldn't know how to shut down a database automatically during Windows shutdown process ... perhaps there's someone who can tell you how to accomplish this task.
And if you have another operating system, I have no idea how to do that
now we are starting the database manually like this
I want to start the database automatically when system is starting ans also closing automatically.
How to do automatically.
When you install Oracle under Unix, you will have some scripts to start the DB (like dbstart, ...). You must write which will accept the two parameters stop and start. Copy this script in the /ect/init.d directory (as root) and make link in the directory /ect/rcx.d called SxxOracle and KxxOracle.
(xx = number e.g. S99Oracle). Automatically when you reboot the Unix, your Oracle DB will stop and restart.