Two Oracle versions (9i, 10g) on same Win2003 server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Two Oracle versions (9i, 10g) on same Win2003 server

  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Two Oracle versions (9i, 10g) on same Win2003 server

    Hi,
    I need to install Oracle 9i and 10g on same machine running windows 2003 server.
    How to configure the listener on both Oracle installation to make two databases on different versions live together. (Has it be one listener or two? What about ports? Are there some spacial configs?).


    Also how to make a hot backup on above data bases without archive (Dev environment).

    Thanks a lot.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    one listener

    and cold backups are your only option

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by davey23uk View Post
    one listener
    I'm not a Windows guy so my question may sound silly... can't poster have two OH -one for Ora9i the other for Ora10g - and just setup one listener per instance pointing each one to a different port?
    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
    Sep 2002
    Location
    England
    Posts
    7,333
    why have two listeners when one will suffice?

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by davey23uk View Post
    why have two listeners when one will suffice?
    Having one listener per instance would allow for...

    1) Be sure no user hits a specific database -by stopping listener - when doing light maintenance on just one of the databases.

    2) Monitor network traffic on each instance.

    3) In case a listener gets spinning it wouldn't affect both instances, just the one tied to the affected listener.

    4) Most important, because I like to have a listener(*) per instance.

    (*) at least one.
    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.

  6. #6
    Join Date
    Apr 2009
    Posts
    2
    Thanks for your reply.

    Regarding the ports ,can I use 1521 for 9i and 1522(for example) for 10g

    all the developers 9i and 10g
    which client do I need to install on users machines?

    thanks

  7. #7
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    It's all a matter of personal preferences.

    In my case I would separate listeners by Oracle Home, like 1521+ for Ora9i and 1621+ for Ora10g -just because it looks cleaner to me in case you have to add listeners in the future.
    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.

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