Hello everyone, welcome to another QGIS Tutorial. In this article, we are going to learn more about QGIS and Oracle Spatial Database. Oracle is a popular RDBMS that mostly used by enterprise. But it also available for personal user. Not like any other RDBMS, the Oracle database setup and configuration is a bit more complicated if compared to MySQL or PostgreSQL. But don’t worry, with a little efforts you should be able to install and configure Oracle Database on your system.
Before we can connect QGIS to Oracle Database, there are some important steps we need to take care of. I have created a step by step tutorials that covers the Oracle installation on a Linux system. Please read the following article if you want to install Oracle database on your network.
- Install Oracle Database 12c on CentOS Linux
- Install Oracle Database on Windows 10
- Create Oracle ODBC Connection on Windows 10
After you have Oracle Database up and running on your network, we can start connecting QGIS to the Oracle.
Steps to Connect QGIS to Oracle Spatial Database
First, Open QGIS and then right-click on the Oracle from the QGIS left panel. Select New Connection and a new configuration window will open up as shown below
So here is the details you need to enter to the connection properties:
- Name: oracle-spatial. Or any name you like
- Database: mydb01. Change this with your actual Oracle database name
- Host: leave empty
- Username and Password for the Oracle database
Click Test Connection to ensure you can connect to the database. Finally hit OK to complete this step.
Now you should be able to open the table from the Oracle database to the QGIS.
That’s it. Now you can open and work with the Oracle Spatial database from QGIS program. I hope you enjoy the tutorial and see you in the next GIS tutorial.
Fernanda TollerFebruary 2, 2021
Fiz exatamente como falou, consigo conectar com sucesso, mas demora muito para carregar. Tem algo que eu possa fazer? Alguma sugestão?
Alias, eu já usava o banco oracle spatial com o software geomedia, mas queria usar um software livre.
Pode me ajudar?
Edwin PleijsierAugust 25, 2022
In newer versions of QGIS leaving the host emty will not work, how to fix?