Link between Oracle and SQL server [message #403430] |
Fri, 15 May 2009 09:55 |
srini_thiru
Messages: 133 Registered: May 2008
|
Senior Member |
|
|
Hi,
I was supposed to create a database link between oracle and SQL server. The steps i followed to create a link are as follows,
1. Setup the ODBC connection on the local Oracle database using the Windows ODBC Data Source Administrator
2. Test the ODBC drivers to ensure that connectivity is made to the SQL Server database.
3. Ensure that your global_names parameter is set to False.
4. TNSNAMES is
test= (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)
(HOST=localhost)
(PORT=1521)
)
(CONNECT_DATA = (SERVICE_NAME=TEST)
)
(HS = OK)
)
5. After this listener has to be changed.
I don't what i have to add in LISTENER.ORA FILE for this TEST sid.
Already we have one listener named LISTENER running in the server. We have 4 databases in the server.
Please share your thoughts.
Seenu.
|
|
|
|