Knowledge Base

First, you need to download 3 installers: The server, the ADO.net provider and a GUI client for easy testing

1. Oracle Database 21c Express Edition for Windows x64
2. ODAC 21c
3. SQL Developer – Windows 64-bit with JDK 17 included. you will use as an external client, just like SSMS

Oracle XE installation steps :
– Unzip the OracleXE213_Win64.zip archive and run setup.exe
– Follow the installation steps, Change the  installation path to run on a different hard drive than C:

Choose a strong password for the SYSTEM user account that you will use later:

Once the installation completes, you can test your new installation directly by running SQL Developer and try to connect as SYSTEM, with the newly configured service name ‘XE’. There is no installation phase to use SQL Developer, simply unzip it and run sqldeveloper.exe, you should see something like:

You can use it just to check if connection is possible by addings a new Oracle connection and cancel if it is a succes:

If it doesn’t work, verify the files listener.ora and tnsnames.ora in the following directory: D:\Oracle\homes\OraDB21Home1\network\admin\
They maybe contain a bad hostname or IP.

Your Oracle instance already runs smoothly but PcVue and UDC cannot reach it yet. You have to install the ADO.NET provider that will configure the Machine.Config and add a new connection method for the database, through TNS names.
Unzip ODAC21 and start a command line as an administrator from this location:
install.bat all D:\Oracle myhome true true D:\Oracle\homes\OraDB21Home1\network\admin

Use The same local disk as your previous oracle home installation (D:\Oracle in this case). No need to use double quote in this case because there is no space, and it is the same for the directory of tnsnames.ora file.

You may get some message indicating file not found, but don’t worry, reboot and configure a SQL connection from PcVue (with SV Dbconnect service running).

You have an ADO.NET provider fully setup and can try to connect with PcVue, using EZ Connect. Your Sql connection should be
configured like this :

You will now be able to fully use SQL read and write queries with Oracle, have fun !