Two instances for a single database targeting Oracle 10g on windows platform
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Two instances for a single database targeting Oracle 10g on windows platform

  1. #1
    Join Date
    Jun 2007
    Posts
    3

    Two instances for a single database targeting Oracle 10g on windows platform

    Hi all,

    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.....

    Please help,

    Regards,
    - Sri

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you cannot do that and what is the point may I ask?

    thanks

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by venkata_sri
    Now, i want to create two instances for a single database, is that possible?

    With RAC yes, of course that is possible...
    So you think Oracle invested tons of money and time developing RAC just because they had nothing better to do?

    my brain! my brain! LOL
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  4. #4
    Join Date
    Nov 2001
    Posts
    335
    And do you think all these people who are buying RAC do not have any clue?
    One, who thinks that the other one who thinks that know and does not know, does not know either!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width