Re: Creating new SID

On Fri, 22 May 1998 09:18:35 -0500, Jayesh Thakker <jthakker_at_nortel.com> wrote:
>hello everyone...
>
>We had already installed oracle 8.0.4 on our solaris box with the
>sid=ora1 and we decided to make ora1 as our test database and create new
>sid for our actual production database, is it possible to have two sid
>on same server ,if so what is required to be done..., i mean do i have
>to install whole oracle again in new oracle home and oracle base with
>new sid... or can i use the same oracle home and if i use same oracle
>home will it delete any tables from old sid(ora1).....
>any comments or help in this matter welcome...
>thank you all...
>Jayesh Thakker
>jthakker_at_nortel.com
>

Be sure and add up the requirements for both instances wrt kernel modifications and SGA calculations. Depending on what kind of testing you will be doing, you may want to keep the SGA for it real small to leave system resources for the production database. If you will be doing performance testing, don't do that of course. Don't use more than half physical memory for both SGA's, or one good SQL could bring solaris to it's knees.

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.