RATE THIS ANSWER
+1
Click to Vote:
- 1
0
Last Answered:
Apr 30 2008 5:24 PM GMT
by WillC
You don't have to run the full installer each time to create a database, but you can only create one database at a time. For each additional database you can run dbca to create a database from a GUI based program, or create a new database from sqlplus using the
CREATE DATABASE statement. Use the GUI if you can.
Oracle uses the term instance to represent the part of the database that the end user knows as the place there data is stored, and the database is the server side programs that make it available. During an install Oracle ask for the location to install these database file and that is known as the ORACLE HOME, of which you can have more that more.
References: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c06start.htm
http://download-east.oracle.com/docs/cd/B12037_01/server.101/b10742/instance.htm
http://www.stanford.edu/dept/itss/docs/oracle/10g/em.101/b12140/3_oui_oracle_homes.htm
From your question I am not clear want you are trying to achieve. Are you wanting to install Oracle 10g multiple times on the same server to provide 10g to different client groups that require autonomy as in they may be different customers onan ISP host; or do you want more than one end user database as a Dev, Test & Prod?
Oracle 10g, Oracle administration
I would like to know if it is possible to install multiple Oracle 10g instances from one installation, or if we have to run the installer every time to create a new instance. If it is possible, how is it done? 
