Oracle Database in Docker and ODBC configuration

Oracle Instance - access it within the container and outside container, install ODBC driver, configure DSN
Free tutorial
Rating: 4.3 out of 5 (14 ratings)
749 students
57min of on-demand video
English

Setup Oracle enterprise database in windows using Docker
ODBC driver configuration to connect to Oracle DB
DSN configuration

Requirements

  • Basics of Docker desktop

Description

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.

Who this course is for:

  • Application Developers and the administrators

Instructor

Integration Architect having 15+ years of experience
Prashant Naik
  • 4.1 Instructor Rating
  • 315 Reviews
  • 6,138 Students
  • 9 Courses

More than 15 years of experience in the IT industry and worked in java and middleware products. Interacted with different industry experts and implemented integration solutions for their business. I have trained students and professionals from different geographies,  and happy to deliver the best training in Integration. I have worked for different MNCs and specialized in Integration, ESB, DevOps, and java technologies. I believe in practical and quality training sessions that will empower people to deliver quality products.

Top companies trust Udemy

Get your team access to Udemy's top 15,000+ courses