more quick actions
minimize quick actions
Topic starter
Hello everyone,
I had to work with Oracle on a fresh install, so I thought I could share my experience.
Here you can find a deep walkthrough of the elements you need to work with PcVue.
First, you need to download 3 installers: The server, the ADO.net provider and a GUI client for easy testing
[list=1]
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: and 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'
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.
The full installation steps should go like this :
Use The same local disk as your previous oracle home installation
The next step will configure your TNS connection, that PcVue will use :
Connection alias : The Oracle TNS connection name that will need to be selected in Oracle SQL Connection
configuration.
Port number is 1521 by default, no need to change it
Database host name : The machine name that hosts the Oracle database
Database service name : For the Express Edition that we just installed, it gets ‘XE’ by default
Once the requirement check is done, you can now finish the installation setup.
You have an ADO.NET provider fully setup and can try to connect with PcVue, using TNS. 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 !
Kévin LEMAIRE
Posted : 27/03/2023 2:03 pm
Thanks Kevin, very useful every time we have to work on Oracle.
The deployment of Oracle seems to be easier since the lastest versions.
Posted : 28/03/2023 2:45 pm