Oracle Accreditation Program: Increase your productivity by using Oracle's Accreditation Program - our new framework to accelerate your knowledge of our Oracle products and Support framework.
root@testdb unixODBC-2.3.0# ls acinclude.m4 config.h.in COPYING DRVConfig install-sh ltmain.sh mkinstalldirs README.INTERIX stamp-h1 aclocal.m4 config.log cur exe Interix m4 NEWS README.OSX vms AUTHORS config.status depcomp extras libltdl Makefile odbcinst README.QNX vmsbuild.com ChangeLog config.sub doc include libtool Makefile.am README README.SOLARIS ylwrap config.guess configure DriverManager ini log Makefile.in README.AIX README.VMS config.h configure.in Drivers INSTALL lst missing README.CYGWIN samples. In COPYING DRVConfig install - sh ltmain.
Sh mkinstalldirs README. INTERIX stamp - h1 aclocal.
Log cur exe Interix m4 NEWS README. OSX vms AUTHORS config. Status depcomp extras libltdl Makefile odbcinst README. QNX vmsbuild.
Com ChangeLog config. Sub doc include libtool Makefile. Am README README. SOLARIS ylwrap config.
Guess configure DriverManager ini log Makefile. In Drivers INSTALL lst missing README. CYGWIN samples Now install by using the below command prompt with root login. # make install Note: If you find the this error “ configure: error: C compiler cannot create executables in oracle linux” Need some require rpm package for gcc, cpp etc. Cpp x8664 4.4.7-18.el6 base 3.7 M gcc-c x8664 4.4.7-18.el6 base 4.7 M libgcc i686 4.4.7-18.el6 base 115 k libgcc x8664 4.4.7-18.el6 base 103 k libgomp x8664 4.4.7-18.el6 base 134 k libstdc i686 4.4.7-18.el6 base 303 k libstdc x8664 4.4.7-18.el6 base 295 k libstdc-devel i686 4.4.7-18.el6 base 1.6 M libstdc-devel x8664 4.4.7-18.el6 base 1.6 M Reference Link: INSTALLATION OF MICROSOFT ODBC DRIVER 11 FOR SQL SERVER Download Microsoft ODBC Driver 11g for SQL Server for RedHat Linux directly from Microsoft below link: Example: Extract the files to a directory and install.
root@testdb msodbcsql-11.0.2270.0#./install.sh verify Microsoft ODBC Driver 11 for SQL Server Installation Script Copyright Microsoft Corp. Starting install for Microsoft ODBC Driver 11 for SQL Server Checking for 64 bit Linux compatible OS. OK Checking required libs are installed. OK unixODBC utilities (odbcconfig and odbcinst) installed.
OK unixODBC Driver Manager version 2.3.0 installed. OK unixODBC Driver Manager configuration correct. OK.
Microsoft ODBC Driver 11 for SQL Server already installed. NOT FOUND Install log created at /tmp/msodbcsql.11649/install.log.
![Oracle Oracle](/uploads/1/2/5/3/125349907/195224890.gif)
root@testdb msodbcsql-11.0.2270.0#./install.sh install CTL+C Enter YES to accept the license or anything else to terminate the installation: YES Enter YES to accept the license or anything else to terminate the installation: YES Checking for 64 bit Linux compatible OS. OK Checking required libs are installed.
OK unixODBC utilities (odbcconfig and odbcinst) installed. OK unixODBC Driver Manager version 2.3.0 installed. OK unixODBC Driver Manager configuration correct.
OK. Microsoft ODBC Driver 11 for SQL Server already installed. NOT FOUND Microsoft ODBC Driver 11 for SQL Server files copied. OK Symbolic links for bcp and sqlcmd created. OK Microsoft ODBC Driver 11 for SQL Server registered. INSTALLED Install log created at /tmp/msodbcsql.6.5933/install.log. root@testdb admin# cat initmirdb.ora # This is a sample agent init file that contains the HS parameters that are # needed for the Database Gateway for ODBC # # HS init parameters # HSFDSCONNECTINFO = mirdb HSFDSTRACELEVEL = 0 HSFDSSHAREABLENAME = /usr/lib64/libodbc.so HSLANGUAGE = AMERICANAMERICA.WE8MSWIN1252 HSKEEPREMOTECOLUMNSIZE = LOCAL HSNLSLENGTHSEMANTICS = CHAR HSNLSNCHAR = UCS2 # # ODBC specific environment variables # set ODBCINI= /etc/odbc.ini # Environment variables required for the non-Oracle system # #set =.
oracle @ testdb admin $ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 30-JAN-2018 16:00:49 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.120.123)(PORT=1521))) STATUS of the LISTENER ———————— Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 – Production Start Date 30-JAN-2018 15:58:02 Uptime 0 days 0 hr. 47 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/ogg-test1/listener/alert/log.xml Listening Endpoints Summary (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.120.123)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=8087))(Presentation=HTTP)(Session=RAW)) Services Summary Service “primXDB” has 1 instance(s). Instance “testdb”, status READY, has 1 handler(s) for this service Service “testdb” has 1 instance(s). Instance “testdb”, status READY, has 1 handler(s) for this service The command completed successfully oracle@testdbadmin$ lsnrctl status LISTENERmirdb LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 30-JAN-2018 16:00:59 Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) STATUS of the LISTENER ———————— Alias LISTENERmirdb Version TNSLSNR for Linux: Version 11.2.0.4.0 – Production Start Date 30-JAN-2018 15:59:32 Uptime 0 days 0 hr. 26 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/ogg-test1/listenermirdb/alert/log.xml Listening Endpoints Summary (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Services Summary Service “mirdb” has 1 instance(s). Instance “mirdb”, status UNKNOWN, has 1 handler(s) for this service The command completed successfully. 2 This above table created in SQL Server & fetch from Oracle Database Important Note on SQL Server: Connect with the “sa” user & create one database with “mirdb”, Perform some DDL/DML Operation & verify from the Oracle Database Hence tested & verified in our test env This entry was posted on Wednesday, January 31st, 2018 at 2:50 pm and is filed under. You can follow any responses to this entry through the feed. Both comments and pings are currently closed.
2 Responses to “Creation of dblink from Oracle to SQL Server”. Says: Your house is valueble for me. Says: Its like you read my mind!
You seem to know so much about this, such as you wrote the e book in it or something. I think that you just can do with a few percent to pressure the message house a bit, however other than that, this is fantastic blog. An excellent read. I will certainly be back.