docker oracle install

 

https://hub.docker.com/r/9fevrier/oracle-11g
Informations

Oracle directory : /opt/oracle
Data directory : /app/oracle/data
SID : orcl
Login/password : system / oracle
System root : root / C%3hUMd@2#
System Oracle user : oracle / oracle
Start listener : lsnrctl start
Start database : sqlplus / as sysdba then startup
Start the container

docker run --name oracle_11g -d -t -p 1521:1521 -p 2222:2222 9fevrier/oracle-11g:15.08.21  /usr/bin/supervisord -c /etc/supervisord.conf

Tags
15.08.22
CentOS 6.6 + Oracle 11g r2
SSH port 22

### 查看容器id
docker ps -a
### 进入容器
docker exec -it oracle_11g /bin/bash

### 切换用户名
su - oracle
### 设置参数
export ORACLE_SID=orcl
export ORACLE_HOME="/opt/oracle/product/11.2.0/dbhome_1"
export PATH="${PATH}:${ORACLE_HOME}/bin"

### 启动监听
lsnrctl start
lsnrctl status
### 启动oracle实例
sqlplus / as sysdba
shutdown immediate;
startup;
select * from user_tables where rownum<10;

 

韩顺平oracle
https://www.bilibili.com/video/BV1sW41187S2?p=9

sqlplus / as sysdba

# 导入HR示例数据库

链接：https://pan.baidu.com/s/1hgTmKdPIPGsGsp-zHGUITw

提取码：sjg7

@D:\Oracle11g\product\11.2.0\dbhome_1\demo\schema\human_resources/hr_main.sql
select username,account_status from dba_users order by username
alter user hr account unlock;

导入scott示例数据库

@/opt/oracle/product/11.2.0/dbhome_1/rdbms/admin/utlsampl.sql