How I can create and to keep two active instances???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How I can create and to keep two active instances???

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Talking

    How I can create and to keep two active instances and of course two databases of the personal Oracle in mine machine, to test replication of oracle?

  2. #2
    Join Date
    Feb 2002
    Posts
    267
    hi,

    on unix create 2 instance with two different sid's.

    open different terminals and set the sid's and create different databases for each sid.

    when u want to start a particular instance set the appropriate sid (ORACLE_SID=test) and start the d/b.
    U can start both the d/b at the same time on single machine.

    Note that ORACLE_HOME is same for both the d/b ie., u r using same oracle s/w installation for both the instances.



  3. #3
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Wink

    Sonia,

    Good day.
    I am using Personal Oracle 8i as already it had said
    previously. Therefore the operational system is the
    WINDOWS (in this case windows 2000).
    Exactly thus, Sonia, grateful for the attention.






  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Just run the Database Configuration Assistent to create a new instance. This will set up the relevant services and create the database.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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