kksingh 27000219NT Visits (1314)
This blog is for users who can answer a "Yes" to the following Questions:
1. Are you thinking of Migrating your existing 32 Bit System with Rational System Architect with Oracle as back end to 64 Bit Systems?
2. Are you new to Rational System Architect and planning to install the same on 64 Bit systems with Oracle as back end Database?
Here are your answers:
First of all, let us understand the architecture of Rational System Architect. Basically, Rational System Architect is a 32 bit application and expects all the connectivity to go through the 32 bit channel.
Then where is the confusion?
The confusion starts when you install Rational System Architect on a 64 bit system, for example a Microsoft Windows 2008 R2 system, and you are able to form a valid connectivity to the Oracle database from the system. Alas, you are not able to connect from Rational System Architect to the Encyclopedias.
You could face numerous errors while trying to form a valid Connection from Rational System Architect to the Oracle DB. Some of them being "Provider Cannot be found", "ora1289 Error", etcetera.
Then what’s the Solution?
Let’s get back to the point that Rational System Architect is a 32 bit Application and normally DBA installs a client driver for Oracle which is of a 64 bit system.
You will be able to connect to the Oracle database from the system (because of the 64 bit client installed from the DBA) but not form a valid connection because Rational System Architect is trying to connect using a 32 bit Client driver which is not present in the system. Hence, ensure to connect with your Oracle DBA and ask them to install the 32 bit client driver on the system.
How do users verify that the driver installed is a 32 Bit driver and If user will be able to connect from Rational System Architect with the help of a UDL (Universal Data Link) file ?
When we have created a UDL file on a 64 bit machine and try to open it, the following command ("C:\Program Files\Common Files\System\Ole DB\o
Here, both Oledb32.dll and rundll32.exe are 64 bit and will not enumerate the 32bit Dlls.
Then how to run the UDL which lists down the 32bit Dlls?
You can find the 32bit version of O
You’ll need to execute the command below from a command line or Start/Run:
Once the 32 Bit UDL test is successful, you are good to connect from Rational System Architect to the Oracle database.
The images below show examples for commands to execute UDL files and the options to select while verifying the connection:
Screen 1: Showing the Command to execute the UDL file as a 32 Bit Version UDL
Screen 2: Showing the option to select for the Oracle client driver to be selected
Screen 3: Showing the Oracle Server name:
Screen 4: Showing the successful conection
AcdntlPoet 2700019V2G Visits (1312)
Did you know you can access IBM Support social media content from the IBM Support portal?
Social Media Aggregator in Support Portal - This video shows you how to see the latest social media content about your IBM products in the Support Portal. With Support Portal's Social Media Aggregator, it is easy to see the latest posts from Twitter, product forums, user groups, blogs, and wikis. Visit the IBM Support Portal at:
kellypuffs 06000168YK Visits (1312)
This weekend, we'll be performing some critical maintenance on our systems, and as such, our technical support content will be unavailable for a period of time
What you can expect:
AcdntlPoet 2700019V2G Visits (1307)
Over the course of 10 weeks in Q4 2013, developerWorks Rational featured a modeling tip for systems engineers each week from Bruce Douglass. Undeniably, Bruce's 35 years of experience and credentials make him the perfect person to provide this information, and he does so with humor- which makes it all the more fun. We think these are some fabulous hints and tips and hope you find these tips helpful in your daily work as well:
AcdntlPoet 2700019V2G Visits (1306)
The ALM Community is planning the following ALM Office Hour events for March and April:
Is it better to deploy IBM Rational Team Concert incrementally or all at once? Agile Architecture Make sure you email, tweet, and/or blog about these excellent upcoming ALM events! Author: Fariz Saracevic (@FarizSaracevic) Lifecycle Scenario Architect
Agile Architecture Make sure you email, tweet, and/or blog about these excellent upcoming ALM events! Author: Fariz Saracevic (@FarizSaracevic) Lifecycle Scenario Architect
Make sure you email, tweet, and/or blog about these excellent upcoming ALM events!
Author: Fariz Saracevic (@FarizSaracevic) Lifecycle Scenario Architect