dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2003
    Posts
    20

    Wink steps for running 2 instances

    Hi,
    I have oracle 8i and 9i server with linux and win2k. I would like to run 2 instances on both 8i/9i linux/win2k. Can anyone guide me the steps needed to achieve this?
    Thanking you,
    Suresh.H.T

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    U know how to create a DB right.

    Jus follow same steps if u wanted another DB.

    Any problems post here.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    You could also use the 'database configuration assistant' to create another database.

    Check this out for 8i...
    http://technet.oracle.com/docs/produ...reate.htm#1656

    Check this out for 9i...
    http://download-west.oracle.com/docs...reate.htm#1656
    HTH.

  4. #4
    Join Date
    Mar 2003
    Posts
    20
    Hi,
    Thanks for reply.
    Problem is not creating another DB.
    I am able to create the DB.But my problem is how to startup the 2 DB's.
    Let me make clear what i am doing.(one DB is running already)
    1) i have created new DB
    2) give STARTUP pfile c:\.....path of init.ora file in SVRMGRL prompt.
    3) i am getting error "Oracle already running.Shut it down first"
    I think i have to do parallel server/multi instance configuration.
    I dont know how to do it.I am doing this in oracle8i/win2k.I would like to know the procedure for 8i/9i on linux/win2k.
    Please help me.
    Thanking you
    Suresh.H.T

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    set environment variable ORACLE_SID and then got to server manager.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    what you need is RTFM

  7. #7
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    On Windows:

    at command prompt...

    c:\> set oracle_sid = db2

    Now, go to sqlplus, connect internal and give startup pfile (mentioning pfile of 2nd db).

    On Linux:

    export ORACLE_SID = db2 (depending on the shell u use, this is for bash shell of linux)
    Now, go to sqlplus, connect internal and give startup pfile (mentioning pfile of 2nd db).

    HTH.

  8. #8
    Join Date
    Mar 2003
    Posts
    20
    Hi ggnanaraj,
    Thanks a lot for solving my problem.
    Suresh.H.T

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




×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.