Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: 2nd Oracle instance
Its pretty simple. Each "database" is a separate set of tablespaces and a separate user_id. You also set up a second listener for the instance and everyone pointing to the 2nd "database" uses that listener. It can be done and it's not that hard.
Alan V.
"I can please only one person per day.
Today is not your day.
Tomorrow isn't looking good either."
Dan Norris wrote in message <6g0rci$evr$1_at_sky.net>...
>To my knowledge, you cannot have multiple DBs on the same instance.
>However, running multiple instances that access the same database is the
>architecture used for Oracle Parallel Server.
>
>Dan
>
>
>"Vanita Chawla" <vanita.chawla_at_teradyne.com> writes:
>
>>Interesting to know you can have multiple DB running on the same instance.
>>I'd appreciate it if you could go into details of how to accomplish this.
>>Thanks.
>
>
Received on Fri Apr 03 1998 - 00:00:00 CST