关于Oracle

1. Install Oracle with dockerdocker pull alexeiled/docker-oracle-xe-11gdocker 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 Oraclesqlplus system/Ftit654321@172.16.0.30:1521/xe4. 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"; 

相关内容推荐