This topic describes hosting the SDB Merge Tool web application on a web server using an IIS Manager.
Configure IIS settings for Microsoft Windows Server 2022 or 2019
To configure the IIS settings for Microsoft Windows Server 2022 or 2019, follow the steps below:
-
Open the Microsoft Windows 2022 or 2019 Server Manager as an administrator.
-
Select Local Server.
-
Select Add Roles and Features from the Tasks list to go to the Add Roles and Features wizard.
-
Select Installation Type > Role-based or feature-based installation.
-
Select Next.
-
On the Server Selection window, select Next.
-
Select Web Server (IIS) from the Roles list.
-
Select Add Features on the Add Roles and Features wizard, and then select Next.
-
Select HTTP Activation under the node .NET Framework 4.X Features > WCF Services in the Select Features window.
-
Select Add Features on the Add Roles and Features wizard, and then select Next.
-
Select Restart the destination server automatically, and then select Yes to restart if required by the system.
-
Select Install to complete the IIS installation.
-
When the features are installed, select Close.
For more information on configuring IIS, see Configure IIS Settings for Windows Server 2019.
Install the Oracle Client
Install the Oracle Client V982658-01.
-
Open the Client folder and double-click setup.exe.
-
Select Administrator and select Next.
-
On the Select Product Languages window, select English, and then select Next.
-
On the Oracle Home User Selection window, select Use Windows Built-in Account, and then select Next.
-
Select Next.
If you want to change the Oracle base or software location, select Browse and select another folder path.
-
On the Summary window, select Install.
-
When the installation is complete, select Close.
-
Change the registry setting NLS_LANG for the Oracle Client home to AMERICAN_AMERICA.AL32UTF8 (where AL32UTF8 is the character set of the database).
Register a 19c Oracle.DataAccess.dll and Oracle.DataAccess.EntityFramework.dll
After you install the Oracle Client, you must manually register the Oracle.DataAccess.dll and Oracle.DataAccess.EntityFramework.dll to a Global Assembly Cache (GAC).
-
Run Command Prompt as an administrator.
-
Enter the command to access the ODP.NET folder, which is in the Oracle installation location:
Example: >CD <Oracle installation folder>\product\19.0.0\client_1\ODP.NET\bin\4
-
Enter the following command for the Oracle.DataAccess.dll:
oraprovcfg /action:gac /providerpath: <Oracle installation folder>\product\19.0.0\client_1\ODP.NET\bin\4\Oracle.DataAccess.dll
-
Enter the following command for the Oracle.DataAccess.EntityFramework.dll:
oraprovcfg /action:gac /providerpath<Oracle installation folder>\product\19.0.0\client_1\ODP.NET\bin\4\EF6\Oracle.DataAccess.EntityFramework.dll
-
Installation steps
-
Run Command Prompt as an administrator.
-
By default, an application pool for web applications is set to DefaultAppPool. You must create a new application pool for SDBMerge during the first-time installation.
Use the command below to create the new application pool:
%systemroot%\system32\inetsrv\APPCMD add apppool /name:SDBMerge
-
Run the following command to replace SDBInstallDirectory with your installation path:
%systemroot%\system32\inetsrv\APPCMD add app /site.name:"Default Web Site" /path:"/SDBMerge" /physicalPath:"<SDBInstallDirectory>\SDBMerge" /applicationPool:SDBMerge
To delete the SDBMerge application from IIS, run the following command:
%systemroot%\system32\inetsrv\APPCMD delete app "Default Web Site/SDBMerge"
-
Ensure you have the Read and Write permissions for IIS_IUSRS in the Exports folder under <SDBInstallDirectory>\SDBMerge.
-
Ensure you have the Read and Write permissions for IIS_IUSRS in the Logs folder under <SDBInstallDirectory>\SDBMerge.
The SDB Merge Tool is a web-based tool, and it can be accessed using the web URL after hosting successfully.
Default URL: http://<servername>/SDBMerge/Index.html. The servername specifies the computer on which the web application is hosted.