官方說明

https://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html

http://docs.oracle.com/en/database/

https://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html

指令

sqlplus初始設定

SQL> help
SQL> show user
SQL> show all
SQL> @檔案位置\檔案名稱.SQL

http://hsinichi.pixnet.net/blog/post/5321280-oracle-database---sqlplus常用指令

http://madhero.mysinablog.com/index.php?op=ViewArticle&articleId=471173

http://meetrice.iteye.com/blog/89426

Oracle docker on GIT

https://github.com/oracle/docker-images/tree/master/OracleDatabase

https://github.com/oracle/docker-images

https://github.com/wnameless/docker-oracle-xe-11g

docker more application

docker載入Oracle

• 安裝

$ docker pull wnameless/oracle-xe-11g

主機: localhost

port: 49161

sid:xe

• 啟動

$ sudo docker run -d -p 49160:22 -p 49161:1521 wnameless/oracle-xe-11g

$ sudo ssh root@[IP位置] -p 49160
ex.$ sudo ssh root@localhost -p 49160

帳號 root 密碼 admin

$ sqlplus [使用者]@[資料庫名稱]
ex. $ sqlplus system@xe

使用者sys, system 預設密碼 oracle

http://www.esentri.com/blog/2017/05/15/create-and-use-a-docker-container-with-oracle-xe-on-macos/

• 離開sqlplus

SQL> quit

• 寫回映像檔 ???

https://hub.docker.com/r/wnameless/oracle-xe-11g/

http://bilab.pro/2017/03/20/install_oracle_on_docker/

http://wiki.jikexueyuan.com/project/docker/docker-hub/docker-hub.html

mac os下使用 Docker安装 oracle数据库

http://www.jianshu.com/p/14000d16915c

localhost連接遠端 oracle docker

https://stackoverflow.com/questions/37428209/connecting-an-oracle-db-container-and-a-java-application-container-docker

https://forums.docker.com/t/connecting-to-an-oracledb-in-a-docker-container-from-another-java-docker-container/13269