Re: Help needed on creating Multiple Instances

Ibraheem Ahmad Malik wrote:
>
> Hi,
> We have ORACLE release 7.3.2 Installed on Sun SPARK Solaris. I want to
> create Multiple Instances on one database. I have gone through Installation
> Guide for SUN SPARC Solaris and did not find any useful reference. Any help or
> reference on this would be welcomed.
>
> Regards
>
> Ibraheem Ahmad Malik

If you truly want to create multiple instances that point to the same database, that requires Oracle's Parallel Server Option. This is an additional cost item, and requires some special setup in your init.ora files. I have had some experience with this on VMS platforms, but not on UNIX platforms.

If you want multiple databases and instances, that is not too hard. You can actually use the installer to build additional databases, then update your oratab file to contain all of the instance entries.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com