Two instances for a single database targeting Oracle 10g on windows platform
Database: Oracle 10g (Server)
Operating system: Windows XP SP2
Now, i want to create two instances for a single database, is that possible?
With RAC yes, of course that is possible....but normally working on:
Steps i followed:
1. Created one more instance with ORADIM utility.
2. The same is displayed appropriately in services.msc
3. Copy/pasted the init.ora file and updated the new copy/pasted db_name to 'ORCL2' where in by default the original init.ora file had db_name as 'ORCL'
Instance ORCL2 is not recongized.....