You need to make sure that the oracle client jar is in the class path before connecting to this database.Īs you can see, the test is successful. This tutorial shows how to set up a data source and connect to an Oracle database using the Database Explorer app or the command line. It is a great GUI-based tool to connect to SQL as well as NoSQL databases. I have used the DBeaver SQL client software application and a database administration tool to test the connection. If you are facing an issue related to installation of Oracle Database Instant Client on M1 something like DPI-1047: Cannot locate a 64-bit Oracle Client. Now try to connect to this database using system/oracleas Username 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 Last Successful login time: Sun 23:36:41 +00:00 Move the unzipped folders to /usr/local/oracle c. SQL*Plus: Release 12.2.0.1.0 Production on Mon May 4 00:16:46 2020Ĭopyright (c) 1982, 2016, Oracle. But create an /oracle folder in /usr/local folder instead b. $ORACLE_HOME/bin/sqlplus system/ //localhost:1521/xe I am disabling the web console port as I will not be using it. We will start the Oracle database server instance by using the below docker run command with port 1521 opened. It starts with the basics and walks you through an installation of Oracle Database 10g Release 2 from the bare metal up. If you are new to Linux and/or Oracle, this guide is for you. We can use either SQLPLUS or any other JDBC client to connect to the database server from outside the container. The guide provides a walkthrough of installing an Oracle Database 10g Release 2 database on commodity hardware for the purpose of evaluation. The Oracle database server exposes port 1521 for Oracle client connections over SQL Net 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 to the database from outside the container, start the container with -P or -p option. Docker pull quay.io/maksymbilenko/oracle-12c
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |