Installing TimeControl 6 on a 64 bit server with Oracle 11g+

We’ve encountered an unusual condition when clients are installing TimeControl 6 on a 64 bit server with the very latest Oracle 11g.  Most 64 bit installations go forward without incident but, if you are installing your TimeControl on a 64 bit server and you are using Oracle 11g or later
Because TimeControl’s architecture now includes elements that are both in 64 bit and 32 bit.  When TimeControl is installed on a 64 bit server and the Oracle 11g or higher driver is installed, you will need to do some specific configuration in order to have the TimeControl Transaction Server (TTS) (in .Net) connect through the 64bit Oracle supplied driver and the TimeControl Administration Transaction Server (ATS) connect through the 32bith Oracle supplied driver.
Do this you will need to create multiple Oracle homes by installing Oracle 32bit and Oracle 64 bit client. For more information on installing and configuring multiple homes please refer to Oracle documentation.
First, install both the:
*
Oracle 32 bit Client Software (minimum Runtime installation) and the; * Oracle 64 bit Client Software (minimum Runtime installation)
image
Next, create an environment variable called TNS_ADMIN to point to the location of your tnsnames.ora file. For more information on creating environment variables, refer to your Oracle documentation.
image
Now update your tnsnames.ora file to have the connection information for your Oracle data.

Now you’re ready to install TimeControl or run the TimeControl database configuration tool.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.