Re: create two db on the personal oracle

>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 don't know if this will work when creating the instance... I THINK since you're doing something like

oradim80 -new -sid d703 -intpwd internal -startmode auto -pfile k:\d703\initd703.ora

how does Oracle know where to put stuff if you don't do an oracle_sid=... in the command file? In any case, it'll work one way or the other... or maybe both!

>> 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!
>

Um how come? How do I reverse engineer an instance into the Designer if I can't have both instances up? I'm the only user, so I figure if Oracle didn't want me to have more than one instance up, PO8 WOULD NOT LET MORE THAN ONE START! Received on Tue Jan 19 1999 - 20:37:20 CST