Udemy

Platform

English

Language

Other

Category

Oracle Database in Docker and ODBC configuration

Oracle Instance - access it within the container and outside container, install ODBC driver, configure DSN

Oracle Database in Docker and ODBC configuration

Students

1 hour

Content

Jun 2021

Last Update
FREE
Regular Price

SKILLSHARE
SkillShare
Unlimited access to 30 000 Premium SkillShare courses
30-DAY FREE TRIAL

What you will learn

Setup Oracle enterprise database in windows using Docker

ODBC driver configuration to connect to Oracle DB

DSN configuration


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.


Content

Introduction

Introduction

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


3699040

Udemy ID

12/12/2020

Course created date

6/17/2021

Course Indexed date
Bot
Course Submitted by