Results 1 to 8 of 8
  1. #1
    Jeffrey Boulier Guest

    Question Answered: DB2 & Oracle on the same server ?

    Is it possible to run both DB2 and Oracle simultaneously on the same machine (assuming Solaris as the operating system)? Are there any ports that would conflict, and if so, could the database listeners be bound to different IP addresses?

    Yours Truly,
    Jeffrey Boulier

  2. Best Answer
    Posted by Fuzzy

    "
    Is it possible to run both DB2 and Oracle simultaneously on the same machine (assuming Solaris as the operating system)? Are there any ports that would conflict, and if so, could the database listeners be bound to different IP addresses?
    Yep, not a problem. There'll be no port conflicts unless you configure it that way. (the defaults are safe ... )

    Ciao Fuzzy
    "


  3. #2
    Blair Kenneth Adam Guest
    Yes, this is possible. Ensure that settings for all Solaris kernel configuration parameters (documented in the DB2 Quick Beginnings manual) use the sum of the DB2 and Oracle recommendations. I read somewhere (maybe in this newsgroup) that the manner of binding IP addresses to ports is different between DB2 and Oracle. Perhaps a comm. expert who has used can explain.

  4. #3
    Leonard F Clark Guest
    We have a pretty vanila install of UDB and Oracle on Solaris 7 on a Sun E5500 (and 450) and there were no problems and no tweaks needed. The Oracle is 8.1.6; the UDB is 5.1, I think.

    Len

  5. #4
    Dennis Flinn Guest
    Is it possible to run both DB2 and Oracle simultaneously on the same machine (assuming Solaris as the operating system)? Are there any ports that would conflict, and if so, could the database listeners be bound to different IP addresses?
    Jeffrey:

    In Oracle you have to configure a listener file usually found in $ORACLE_HOME/network/admin/listener.ora. In that file you define the port which the the listener will bound to - I think the default is like 1520 or 1521 you then identify the instances(Oracle instances which are not the same thing as a UDB instance) which will use the listener..

    Dennis

  6. #5
    Blair Kenneth Adam Guest
    In Oracle you have to configure a listener file usually found in $ORACLE_HOME/network/admin/listener.ora. In that file you define the port which the the listener will bound to - I think the default is like 1520 or 1521 you then identify the instances(Oracle instances which are not the same thing as a UDB instance) which will use the listener..
    Thanks. In DB2, you define the ports in /etc/services Typical entries look like this:
    Code:
    db2cDB2 50000/tcp #connection port for the DB2 instance DB2 db2iDB2
    50001/tcp #interrupt port for the DB2 instance DB2 db2cDB2CTLSV 50002/tcp
    #connection port for the DB2 instance DB2CTLSV
    db2iDB2CTLSV 50003/tcp #interrupt port for the DB2 instance DB2CTLSV

  7. #6
    Daniel A. Morgan Guest
    Can't speak to the DB2 listener. But the Oracle listener is not bound to an IP address: It is bound to a port. The default port is 2481.

    Daniel A. Morgan

  8. #7
    Gert van der Kooij Guest
    Code:
    db2cDB2 50000/tcp #connection port for the DB2 instance DB2 db2iDB2
    50001/tcp #interrupt port for the DB2 instance DB2 db2cDB2CTLSV 50002/tcp
    #connection port for the DB2 instance DB2CTLSV
    db2iDB2CTLSV 50003/tcp #interrupt port for the DB2 instance DB2CTLSV
    Also the administration instance db2das00 (to enable remote administration) is bound on port 523, AFAIK this can't be changed. All ports on 'normal' instances can be configured the way you need it.

  9. #8
    Fuzzy Guest
    Is it possible to run both DB2 and Oracle simultaneously on the same machine (assuming Solaris as the operating system)? Are there any ports that would conflict, and if so, could the database listeners be bound to different IP addresses?
    Yep, not a problem. There'll be no port conflicts unless you configure it that way. (the defaults are safe ... )

    Ciao Fuzzy

Posting Permissions

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