Mac 安装Oracle

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

docker pull oracleinanutshell/oracle-xe-11g

docker run -d -p 49161:1521 -e ORACLE_ALLOW_REMOTE=true oracleinanutshell/oracle-xe-11g

docker exec -it 容器id  /bin/bash

su oracle
cd $ORACLE_HOME
bin/sqlplus / as sysdba

# /u01/app/oracle/oracle_test/ 路径必须存在
create tablespace trunk datafile '/u01/app/oracle/oracle_test/trunk.dbf' size 200M;

create user cox identified by cox123456 default tablespace trunk;

grant connect,resource to cox;
grant dba to cox;//授予dba权限后，这个用户能操作所有用户的表

hostname: localhost
port: 49161
sid: xe
username: system
password: oracle