How to integrate multiple Oracle devices into Envision that have same SID

3 years ago

Originally Published: 2008-09-22

Article Number

000052019

Applies To

In order to configure oracle client to integrate with ODBC data source, you need to select Local Net Service Name Configuration in the Oracle Net Configuration Assistant

In the oracle configuration assistant, the service name refers to the SID of the database, while the Net Service name is referring to the data source name in the Micrsoft ODBC data source

In the oracle configuration assistant you can configure to connect to multiple database

An illustration of the definitions is show below

System Name	Host Name	IP Address	Remark	DBA Notes
A	server1	10.3.73.161	AIX	version=9.2.0.5.0; SID=PROD; port=1521
B	server2	10.252.26.73	AIX	version=10.2.0.2.0; SID=PROD; port=1524

Note that both of the database have the same SID, i.e: the service name

Issue

You have multiple oracle servers to monitor. However, they all have the same SID, i.e: the service name you see in the Oracle Net Configuration Assistant

Resolution

To ensure the Microsoft ODBC data source to able to identify both of your database probably, you need to have a distinct Net Service name when you configure in the Net configuration assistant. This is referring to step 2p of the RSA envision Device configuration guide for Oracle, A suggestion for the name would be the same as the system name of your databases. (i.e: A or B from above example).

Then when you create the ODBC data source in ODBC data source administrator, it will ask you for the Data source Name (Step 2Y). Use the Net service name (A or B) to distinguish the 2 connections. Note that for the Server field, use the same as Data source name (A or B).

Don't see what you're looking for?

Related Articles

Trending Articles