IBM Support

How to connect Rational System Architect to Oracle

White paper


This document describes how to connect IBM Rational System Architect application with Oracle as the backend DBMS. This document will also help you to understand the Oracle configuration files such as TNSNAMES.ora, Listener.ora, and Sqlnet.Ora and services related to connection setup.


Rational System Architect provides extensive capabilities to perform enterprise architecture, business process modeling, UML modeling, and relational data modeling and so on. These modeling capabilities are performed within a real-time environment that is based on System Architect’s repository with a customizable MetaModel. The work that you do in System Architect is housed in a database (also known as an encyclopedia) and these encyclopedias are stored on a SQL Server, SQL Server Express, or Oracle database, depending on the configuration chosen to deploy.

This document can be used as a reference for users who would like to understand how to setup and configure Rational System Architect with Oracle as back-end DBMS along with basic understanding of the configuration files.

Connecting Rational System Architect to Oracle.pdf

Connecting Rational System Architect to Oracle.pdf


All source code and/or binaries attached to this document are referred to here as "the Program". IBM is not providing program services of any kind for the Program. IBM is providing the Program on an "AS IS" basis without warranty of any kind. IBM WILL NOT BE LIABLE FOR ANY ACTUAL, DIRECT, SPECIAL, INCIDENTAL, OR INDIRECT DAMAGES OR FOR ANY ECONOMIC CONSEQUENTIAL DAMAGES (INCLUDING LOST PROFITS OR SAVINGS), EVEN IF IBM, OR ITS RESELLER, HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

Document information

More support for: Rational System Architect
General Information

Software version:,, 11.4

Operating system(s): Windows

Reference #: 7020705

Modified date: 21 January 2011