Re: Changing to a new db with same SID
Date: 1 Dec 2001 03:19:25 -0800
Message-ID: <6616e304.0112010319.768f6892_at_posting.google.com>
Hi all,
I solved the above problem. I had tried creating a new init.ora file so that the new db ontrolfiles would be pointed at. But this did not work out. Now I tried with creating a new instance using ORADIM , mounted the db and opened it which worked perfectly well.
Thanks for help.
Pramod.
twinsxu_at_yahoo.com (Daniel) wrote in message news:<e0e46f5b.0111301130.36367fa7_at_posting.google.com>...
> 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 Sat Dec 01 2001 - 12:19:25 CET