Re: 2nd Oracle instance

From: Arne Sødal <apsodal_at_online.no>
Date: 1998/03/31
Message-ID: <3520CCEB.E5E0C742@online.no>#1/1

1:
Copy the init<sid>.ora and make your own file out of this. 2:
Run the oradim73.exe (if NT)
3:
The db and instance is being created
4:
Be ware of the changes you have to do in regedt if you are switching between several instances, only one can be the default. If you do not want to make changes in regedt, you have to start like this: startup pfile=c:\orant\.....\init<sid>.ora

PS! You can have several db running on the same instance. Tnsnames.ora is very important here. This file is controlled by SQL*Net.

Arne Sodal
OraGod wrote:

> All,
>
> Can someone give me the procedures for creating and running a second
> instance and database? I have one instance and it is running fine, but
> need a second for production of our application. Any help would be
> greatly appreciated.
>
> thx!
>
> Jack
>
> NewDBAMan
Received on Tue Mar 31 1998 - 00:00:00 CST