Re: Changing to a new db with same SID

You cannot have two database with the same SID on the same machine. You should rename the old one by recreate the control file.

Jerry Davidson <jerry_davidson_at_compuserve.com> wrote in message news:<3C078A82.2010901_at_compuserve.com>...
> Pramod Ramachandran wrote:
>
> > Hi,
> >
> > I am new to Oracle and here is my question. I have been working with a
> > db with a certain SID. Now I need to mount another database
> > (preferably with the same SID). The new set of files is offline backup
> > pack and contains all the datafiles, control files and online redo
> > files except the Init.ora file. (I am not sure if the backup was made
> > after shutting down the db. )
> >
> > I have tried with changing the path of the control files in the
> > Init.ora but could not succeed. (the db is not mounting, shows error :
> > "either in initialization mode or shutdown mode").
> >
> > Thanks in advance for any help.
> >
> > Pramod
> >
> Hi. I'll think about it and get back to you.
Received on Fri Nov 30 2001 - 20:30:48 CET