Is it possible to install multiple Oracle 10g instances from one installation?

190 pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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 <b>CREATE DATABASE</b> 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?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Mayankspgupta
    Hi All, Can we have many instances for one database. If yes, then what is the use of that.....pls provide your answers in detail......
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following