You need to make sure that the oracle client jar is in the classpath before connecting to this database.Īs you can see, the test is successful. It is a great GUI-based tool to connect to SQL as well as NoSQL database. I have used the DBeaver SQL client software application and a database administration tool to test the connection. Now try to connect to this database using system/oracleas User Name Password, xe as sid, 1521 as the port. SQL> select tablespace_name, file_name from dba_data_files Ĭonnecting to the Database Server From Outside Container Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production So lets begin by creating a bridge between a network socket with a TCP listener on port 6000 (the default port of the X window system) and the X window server on my OS X host, that we. Last Successful login time: Sun 23:36:41 +00:00 Our end goal is to create a connection between the docker container that runs a graphical application and the X window system on our OS X host operating system.
$ORACLE_HOME/bin/sqlplus system/ //localhost:1521/xe I am disabling the web console port as I will not be using it.
#Installing docker on mac os x how to#
We will start the Oracle database server instance by using below “`docker run“` command with port 1521 opened. Replace Docker for Mac using the Docker CLI and Docker-Machine with Virtualbox, How to Install Docker Desktop on macOS Using HomeBrew, Docker installation for Win10 and macOS m1 chip. We can use either SQLPLUS or any other JDBC client to connect to the database server from outside the container. The Oracle database server exposes port 1521 for Oracle client connections over SQLNet protocol and port for Oracle XML DB. This option will allow you to forward the port. Status: Downloaded newer image for quay.io/maksymbilenko/oracle-12c:latestĪs we want to connect the database from outside the container, start the container with -P or -p option. Docker pull quay.io/maksymbilenko/oracle-12c
0 kommentar(er)
