Re: create two db on the personal oracle

On 18-Jan-99 07:08:34, dperez said about Re: create two db on the personal oracle:
> OK, there is no way I'm gonna claim any expertise here, so take everything w
> a LARGE BAG OF SALT...... BUT, I'm running PO 8.0.4 and I have 4 instances
> including the ORCL one and the D703 that Designer uses, as well as two for
> projects I'm fiddling with........

> In the file that creates the oracle instance (not the database one, but the
> thats an NT command) it has a line that sets the oracle_sid. Then it does t
> create and startup for the instance)... At least that's how all mine have
> worked. When I've had to delete an instance because of moving the database
> don't know WHY I had to, but I did...) I just ran the command file and thing
> were fine again.......

Another way to do this, without setting the oracle_sid is to set up a listener on the instances. You can then "connect internal/@d073, startup pfile=n:\orant\database\initd073.ora" or "connect internal/@orcl, startup pfile=n:\orant\database\initorcl.ora", depending upon your tnsnames.ora. It is down to personal preference I think.

> I've created instances manually and had them created by other Oracle tools.
> far no problem... OH, one thing... I can go into server manager and connec
> internal. BUT, if I want to start the database with just a 'startup' instea
> 'startup open pfile=...' I have to have the initfile for the database in the
> n:\orant\database directory.......... This APPEARS to hold true even when t
> instance was created with the pfile pointing to some other directory.......

Yep, Windows holds no mapping of instance and pfile. When you issue a connect or startup, it looks for a default password file or pfile based upon a derivation of the oracle_sid.

> OH, and I frequently have between 2 and 4 of the instances up and running
> concurrently.........

I'm not sure if you are supposed to do this, but it is certainly possible!

Regards,
Ewan.

--
<mailto:ewan_at_chimera.u-net.com> Received on Mon Jan 18 1999 - 10:39:34 CST