1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Suggestions b4 installing 11g on Servr 2003 with 10g already

Discussion in 'Installation - Windows' started by Popeye.Tom, May 8, 2012.

  1. Popeye.Tom

    Popeye.Tom Active Member

    Messages:
    27
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Left Hand Coast, USA
    Hi,

    Are there any pitfalls I need to be aware of before installing 11gR2 onto Windows Server 2003 with 10g (10.2.0.5.0) already installed? I've searched the forum and found threads on multiple installations in Linux, Solaris and AIX, but not on on Windows Server.

    The databases will not be run simultaneously. I've looked at the documentation in the 11g Administrator's Guide on Managing Multiple Database Instances on a Single Server. This is not what I'm trying to do. Caging and allocating resources is not going to be an issue. I intend to turn the Oracle Services for 10g to Manual and stop them. Install 11.2 into it's own Oracle Home. This is on a test server.

    I have a program called Windchill that uses Oracle. I have an existing test environment version of Windchill running 10g.

    I want to test the latest release and version of Windchill, this requires 11g. I will not be running both at the same time, one or the other. I will start the Ora services for the version that I need depending the version of Windchill that I intend to start.

    Are there any issues or configuration notes that I should be aware of before installing 11gR2 Enterprise Edition on my test server or the 11gR2 Client on the Windchill test server? I intend to configure both on the same ports for the TNS listener and on the Windchill server the Tomcat and Apache will be configured to use default ports; so both cannot be running simultaneously.

    Both servers are running:
    Windows Server 2003 R2
    Standard x64 Edition, SP2

    Thank you
    P.T.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    As long as your server meets the minimum resource requirements for 11.2 (it should) and you won't be running both at the same time you should be fine with a garden-variety installation. Do be certain to make set both groups of services to MANUAL so autostart won't occur on reboot. You can also set up batch scripts to start and stop the required services; include a stop for the 10g services in the 11g startup batch file and include a stop for the 11g services in the 10g batch. An example of an 11g startup batch file is shown below:

    net stop OracleService10gdb
    net stop OracleOraDB10g_homeTNSListener
    net start OracleService11gdb
    net start OracleOraDB11g_homeTNSListener

    Change stop to start and start to stop (and reverse the order of the commands) to set up a 10g startup batch file.
     
    Popeye.Tom likes this.
  3. Popeye.Tom

    Popeye.Tom Active Member

    Messages:
    27
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Left Hand Coast, USA
    Resolved!: Suggestions b4 installing 11g

    Thank you David! I thought I'd be OK, but wanted to confirm. I really appreciate the reply.

    I should be fine on resources, the Oracle server is a dedicated machine that currently has one 4 core Xeon and 8G RAM. Both can be increased, but for the number of users in Windchill, I think we'll be good for a bit.

    I was going to stop start the services manually, but that's a great suggestion on the batch files - just drop them on the desktop with the Apache and Tomcat shortcuts for each version of Windchill. Then I'll not forget as I stop the listener and web server for one and start it for the other to also swap out the Oracle server.

    Cheers,
    PT