BMC Software, Inc., Confidential and Proprietary Information
Accessing Databases on Unsupported Operating System Platforms 9-3
checks the tnsnames.ora file. Upon finding the service name for Oracle
Instance #2 in the
tnsnames.ora file, SQL*NET connects and extracts
objects from Oracle Instance #2 by the
patroldb process on Host_1. The
following procedures provide details on accessing remote database
instances.
Accessing an Oracle Database Instance
To access a remote Oracle instance, you must perform the following
steps, using SQL*NET as the communications protocol.
Step 1 Define a service name in the tnsnames.ora file on the remote instance’s
host.
Step 2 Follow the steps in “Connecting to a Database Server on an Unsupported
Platform” on page 9-5.
Note
If you are using SQL*NET to access a database that is remote to the
PATROL Database Administration server processes, the
filedelete
(datafile_name) command in your script will not work.
Accessing a Sybase Database Instance
To access a remote Sybase instance, you must perform the following
steps, using the DB-Library as the communications protocol.
Step 1 Define a service name in the interfaces file on the remote instance’s
host.
Step 2 Follow the steps in “Connecting to a Database Server on an Unsupported
Platform” on page 9-5.
