install oracle database gateway for microsoft sql server
TRANSCRIPT
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
1/13
Install Oracle Database Gateway for Microsoft SQL server
Unzip the downloaded zip file. It will create a directory namedgateways
Change the directory to gatewaysand start installer.
-bash-3.00$ cd /software/11gR2-Gateways/gateways/
-bash-3.00$ ./runInstaller
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
2/13
Click Next
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
3/13
Select name for the Oracle Home. The Path defaults to Oracle Home. No need to change the same.
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
4/13
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
5/13
Select Oracle Database Gateway for Microsoft SQL Serverand click Next
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
6/13
Provide any existing Microsoft SQL Server details where you are planning to connect. It actually writes
this in a config file and does not really verify.
This can be changed later also in the configuration file. Click Next
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
7/13
Click Install
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
8/13
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
9/13
Once it prompts with above screen, open another shell and run the script as root
root@host # /app/oracle/product/11.2.0/dbhome_1/root.sh
Running Oracle 11g root.sh script
The following environment variables are set as:
ORACLE_OWNER= ora11g
ORACLE_HOME= /app/oracle/product/11.2.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file dbhome already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying dbhome to /usr/local/bin
The file oraenv already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying oraenv to /usr/local/bin
The file coraenv already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying coraenv to /usr/local/bin
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
10/13
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
Click Exitto Finish the installation.
Configure Oracle Database Gateway for Microsoft SQL Server
Make sure that the MS SQL database details are correct in the dg4msql parameter file.
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
11/13
-bash-3.00$ more $ORACLE_HOME/dg4msql/admin/initdg4msql.ora
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server
#
# HS init parameters
#
HS_FDS_CONNECT_INFO=[SERVER127]:4076//NewCDP16
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
-bash-3.00$ cd $ORACLE_HOME/network/admin
Append following in existing listener.ora. Change the name, path and port as required.
LISTENER_dg4mssql=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ) (PORT = ))
)
)
)
SID_LIST_LISTENER_dg4mssql=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4msql)
(ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1)
(ENV=LD_LIBRARY_PATH=/app/oracle/product/11.2.0/dbhome_1/dg4msql/driver/lib:/app/oracle/pro
duct/11.2.0/dbhome_1/lib)
(PROGRAM=dg4msql)
)
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
12/13
-
8/10/2019 Install Oracle Database Gateway for Microsoft SQL Server
13/13