☑ Setup Oracle enterprise database in windows using Docker
☑ ODBC driver configuration to connect to Oracle DB
☑ DSN configuration
In this course, you will learn the complete configuration of the Oracle Database Enterprise edition in Docker. Starting from Installing and configuring the Docker desktop. There are 2 types of backends for the docker desktop to run. One is the Hyper-V and the other is the WSL2 backend. In this course, the Hyper-V backend is enabled.
The 2 versions of Oracle instances are created in docker, one with port mapping and the other without that. The other applications or tools can connect to the oracle instance only if the port mapping is enabled for that container. The steps are explained to install Oracle ODBC driver in windows. The ODBC Driver for Oracle enables an application to access data in an Oracle database through the ODBC interface. Any application, it can be java or DOTnet application, wants to connect to Oracle instance and do the database operations, can use DSN to connect to Database. The steps to configure DSN in windows are explained here.
The external tool SQL developer is used to connect the databases hosted in Docker. Performed the SQL operations in the SQL editor. Created a new user in the Oracle instance and the same user is used to connect to the Oracle instance from ODBC data source and from SQL developer. Modified the user password and verified.
Introduction - Docker Desktop
Introduction - Oracle Database Enterprise Image
Install Oracle Enterprise in Docker
Installation without -P parameter
Connect and operate from outside container
How to create a new user for the Oracle Instance
Configure ODBC Driver for Oracle in Windows
Download and extract the needed from Oracle
Install ODBC Driver and Verify
Create Data Source Name (DSN)
Configure tnsnames.ora in Windows
Create a new DSN for oracle and Test connection
How to Uninstall the Oracle Driver
How it is stored in registry after installation
Uninstall Oracle Driver