Re: Exchanging product and test database on NT - how Do I change SID?

"Harald Buesching" <harald.buesching.hb_at_germany.agfa.com> wrote in message news:3bd6f795.0204230842.3c5aaab7_at_posting.google.com...
> Hello!
>
> We are running 8.0.5.2.6 on NT.
> The blocksize of the test-system (16384 bytest) would mean some
> performance speedup.
> To exchange the functions, I have to change the SID and rename the
> INIT(<SID>) files.
> How do I exchange the SID on a server, which has 4 databases?
>
> I looked in the registry at .../software/oracle and found one
> ORACLE_SID.
> But it was neither the production nor the test SID.
>
> Rebuilding the database, which would be a solution, won't be
> tolerated, because the server should be 99% online.
>
> Any help is welcome.
>
> Greetings Harald Buesching.

Changing the block size to 16k is, following previous discussions on this group not to buy you much, unless you have a true datawarehouse, and even in that case it is questionable, unless you exclusively have full table scans.

You need to stop the databases, stopping the services involved also, then run an oradim -delete <service> in a *dos box* (if you do this interactively you will delete the database.
Then perform magic by renaming the controlfiles and the init.ora and recreate the service.

Of course, this might involve some reading the manual.

I'm not sure, assuming it is a *test* database, why it should be available 99.9%
Obviously locating the test database on the same server as the production database is a bad idea, as is continuing to run 8.0.5, which was desupported several years ago. Is Agfa that poor, it can't afford to upgrade to a current release?

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address