In Oracle, how does one set access to multiple SQL Server databases? Suppose we want to access the default pubs and Northwind databases in SQL Server at the same time in Oracle.
1. on a windows machine with Oracle9i Standard Edition or Oracle9i Enterprise Edition installed (IP: 192.168.0.2), You must select the Transparent Gateway (Oracle Transparent Gateway) to access the Microsoft SQL Server database: initpubs is newly written under ORACLE9I_HOME \ tg4msql \ admin. ora and initnorthwind. ora configuration file.
The content of initpubs. ora is as follows:
HS_FDS_CONNECT_INFO="SERVER=SQLSERVER_HOSTNMAE;DATABASE=pubs" HS_DB_NAME=pubsHS_FDS_TRACE_LEVEL=OFF HS_FDS_RECOVERY_ACCOUNT=RECOVER HS_FDS_RECOVERY_PWD=RECOVER
|
The content of initnorthwind. ora is as follows:
HS_FDS_CONNECT_INFO="SERVER=sqlserver_hostname;DATABASE=Northwind" HS_DB_NAME=Northwind HS_FDS_TRACE_LEVEL=OFF HS_FDS_RECOVERY_ACCOUNT=RECOVER HS_FDS_RECOVERY_PWD=RECOVER
|
The contents of listener. ora under $ ORACLE9I_HOME \ network \ admin are as follows:
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = test9) (ORACLE_HOME = d:\oracle\ora92) (SID_NAME = test9) ) (SID_DESC= (SID_NAME=pubs) (ORACLE_HOME=d:\Oracle\Ora92) (PROGRAM=tg4msql) ) (SID_DESC= (SID_NAME=northwind) (ORACLE_HOME=d:\Oracle\Ora92) (PROGRAM=tg4msql) ) )
|
Restart the TNSListener service on the gateway-enabled Windows machine (IP: 192.168.0.2) (when you add an accessible SQL Server database following this step, the TNSListener service must be restarted ).
[Content navigation] |
Page 1: Configure Oracle to Access Multiple SQL servers at the same time |
Page 1: Configure Oracle to Access Multiple SQL servers at the same time |
Page 1: Configure Oracle to Access Multiple SQL servers at the same time |
|