WIN10 system uses Docker to install Oracle and log on through Navicat for Oracle

First, install Docker

Linux system can be directly used for Docker installation;

Win7 system Installation Dokcer is actually implemented through Boot2docker installation of a virtualbox under Windows;

Boot2docker support for WIN10 systems is not very friendly, the good news is that there is now a dedicated Docker installation package for WIN10: Docker-tollbox;

Docker-tollbox:https://www.docker.com/products/docker-tollbox

DockerToolbox.exe after the download is complete, click Install package to install directly, tick the installation to restart the computer, the installation process will pop up the "Universal Serial Bus Controller" installation prompt, select Trust and install

The desktop appears with three icons after the installation is complete:

　　

In the cmd command, enter the command to verify the Docker version:

Docker-v

Ii. using Docker to install various mirrors

This article demonstrates only the download installation of Oracle, and other images can be queried for related documents

1. Start Docker

Double-click the Docker Quickstart Terminal.exe icon:

The following run information appears:

　　

Wait for the virtual machine to start and assign the IP, after successful startup as follows:

2. Download the image

　　

Docker Pull wnameless/oracle-xe-11g

3. Launch the Oracle XE container, map the 8080 port of the Oracle XE management interface in the container to the 9090 port of the native, and map the 1521 port of Oracle XE to the native 1521 port.

Dokcer run-d-P 9090:8080-p 1521:1521 wnameless/oracle-xe-11g

If you accidentally terminate the service, reopen Docker input below to view your container status

Docker Ps-a

　　

Status exited indicates that the current container is in a stopped state, Names:reverent_booth is a container name

Run the following command to restart the container:

Docker start Reverent_booth

4. Installation information provided by this container

hostname:localhost Port:1521SID:XEusername:system/syspassword:oracle

5. Management Interface Access

Url:http://Localhost:9090/apexworkspace:internalusername:adminpassword:oracle

　　

Three, port mapping

Once the above operation is complete, only the ORACL service can be accessed on the virtual machine, and now we need some settings for access directly on our WIN10 system.

1. Open VirtualBox

　　

2. Select the virtual machine where Docker is located, click the Settings button

　　

3. Select "Network"--"NIC 1"--"advanced"--"Port forwarding"

　　

4. Add the following forwarding rules, click "OK"

　　

5. Now we can start the Oracle management operation on this machine.

Four, XE management page

1. Login Http://localhost:9090/apex

　　

2. After successful login, you can switch the language of the page to Chinese

　　　

V. Using NAVICAT for Oracle to manage Oracle databases

1. Download and install Navicat for Oracle

Http://rj.baidu.com/soft/detail/24310.html?ald

If you need to crack it, find the hack plugin yourself.

　　

　　

2. Install Oracle Instantclient, install 32-bit or 64-bit Oracle client based on the Navicat match you installed, the download link provided above is 32-bit, so we also install the 32-bit Oracle Instantclient

1): http://www.oracle.com/technetwork/cn/database/features/instant-client/index-097480.html

After extracting the downloaded content and putting it into any directory, I put it directly on the C-drive for easy configuration:

　　

2) Download and install Sqlplus

: http://www.oracle.com/technetwork/database/features/instant-client/sqlplus-cloud-3080557.html

Place the extracted files of the downloaded Sqlplus compressed package into the same directory as the Oracle Instantclient:

　　　

3) Open Nvicat, "Tools"-"Options"-"OCI", configure the OCI library to C:\instantclient_12_2\oci.dll,sql*plus set to C:\instantclient_12_2\ Sqlplus.exe

3. Establish a connection

1) Connection Name any

2) connection type: Basic

3) host name or Ip:localhost

4) Port: 1521

5) Sid:xe

6) User name: System

7) Password: Oracle

　　

WIN10 system uses Docker to install Oracle and log on through Navicat for Oracle