Re: 2 Instances (URGENT!!)

> I was thinking about same question this morning. I would like to share what I
> know with you.
>
> Basically, you can create another initSID.ora file with different SID. You also
> need to specify a database with datafiles in the different location from your
> existing database in the first instance. When you want to start second
> instance, change your ORACLE_SID to the new SID your created and run startup
> nomount. The second instance should be up. Then you can create database or
> whatever you want to do.
>
> This is just a thought and it worked in Informix database. I would like to try
> it on Oracle. If you have different thoughts, we can share each other. My email
> address is tony.yang_at_conexant.com and nhou_at_aol.com. I hope this helps.

If I understand you correctly this is a recipe for wholesale disaster. Yes you can create another initSID.ora. And you can create a new database using the command line mode for ORADIM. But if you rename anything I don't want to be anywhere near you.

Why not just create a new tablespace on your existing instance? Create a new schema in the tablespace. Then when you are satisfied everything is fine just drop the old. This has the advantage of not having to do anything dangerous and won't make your DBA or SYSADMIN want to hang you. Which as a DBA I would gladly do if anyone here tried a stunt like this. It also has the advantage of not having to recalculate memory utilization and rewriting all three initSID.ora files.

Daniel A. Morgan Received on Mon Feb 01 1999 - 19:33:09 CST