DBA Hub

📋Steps in this guide1/2

Heterogeneous Services (Generic Connectivity) : Oracle to Non-Oracle Database Links Using ODBC

Query non-Oracle databases using database links over ODBC.

oracle miscconfigurationintermediate
by OracleDba
16 views
1

Setup

In the following example, "SQLSERVER1" is the ODBC Data Source Name (DSN) of the non-Oracle database.
2

Troubleshooting Tip

Depending on your environment, you may have to play around with the settings in the "$ORACLE_HOME/hs/admin/initSQLSERVER1.ora" file. To make sure you are testing these changes properly, remember to use the following process. - Change the config. - Restart the listener. - Reconnect to the Oracle database. - Test the database link. Some config changes will not be visible until you reconnect to the database, so play it safe and always use this procedure. For more information see: Hope this helps. Regards Tim...

Comments (0)

Please to add comments

No comments yet. Be the first to comment!