关于Oracle

1. Install Oracle with docker

docker pull alexeiled/docker-oracle-xe-11g

docker run -d --shm-size=2g -p 1521:1521 -p 8080:8080 alexeiled/docker-oracle-xe-11g

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

2. Install SQL Plus on Mac

1. Download the two files below from http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html. This is necessary because of Oracle licenses.

instantclient-basic-macos.x64–11.2.0.4.0.zip
instantclient-sqlplus-macos.x64–11.2.0.4.0.zip

Put the files in ~/Library/Caches/Homebrew

2. Next run the following commands

$ brew tap InstantClientTap/instantclient
$ brew install instantclient-basic
$ brew install instantclient-sqlplus

3. connect Oracle

sqlplus system/Ftit654321@172.16.0.30:1521/xe

4. Fix "the password will expire in 7 days" issue

//For seeing Full user details
SELECT profile FROM dba_users WHERE username = 'SYSTEM';

//This query is used to change the password life time to unlimited
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 

//This query is used to chagne the default password.
alter user SYSTEM identified by "system";