Re: How do you install a multiple Oracle instance?

liminglu_at_my-dejanews.com wrote:

> How do you create a multiple instance oracle on Linux?
> We are currently use Oracle8.0.5 and have successfully installed Oracle8 on
> RedHat 5.2.
> For development, we may have to run multiple oracle instances on linux.
> Do we have to create another instance by using installer?
> We could not find any step-by-step guides in Oracle Technology Network.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Hello,

The general method of creating the second instance is :-

1. Copy the init<oldsid>.ora to init<newsid>.ora & config<sid>.ora
2. Modify the init<newsid>.ora to have appropriate paths for the new instance and the <dbname>.
3. Modify the path for the control file on the config<newsid>.ora.
4. copy the crdb<oldsid>.ora,crdb2<oldsid>.ora to crdb<newsid>.ora, crdb2<newsid>.ora and change the required parameters on the file to point to the new Instance.
5. change the ORACLE_SID on the environment with the new Instance Name.
6. svrmgrl connect internal startup nomount Run the scripts to create the new instance.

This works for me on unix o/s. May be this could work  on Linux too.

Good Luck

Thanks
Sai Received on Thu Mar 11 1999 - 11:08:15 CST