yycx/oracle11

Info

基于https://hub.docker.com/r/jaspeen/oracle-11g%EF%BC%8C%E5%8F%82%E8%80%83%E7%BB%8F%E9%AA%8C%EF%BC%8C%E5%B7%B2%E5%AE%89%E8%A3%85Oracle11g(11.2.0.4)%E7%89%88%E6%9C%AC%E3%80%82

docker run -itd --privileged --name oracle11g -p 1521:1521 -p 49190:8080 -v "filepath\install":/install -v "filepath\dbca.rsp":/assets/dbca.rsp -v "filepath\db_install.rsp":/assets/db_install.rsp jaspeen/oracle-11g

Database located in /opt/oracle folder Port: 1521 SID: orcl

区别：

OS users:

• root/install
• oracle/install

DB users:

• SYS/5208
• system/5208
• ODBA/5208

Done（参考）:

1、解锁scott账户

sql
SQL> alter user scott account unlock;
User altered.
SQL> commit;
Commit complete.
SQL> conn scott/tiger
ERROR:
ORA-28001: the password has expired
Changing password for scott
New password:    设置为了 scott
Retype new password:
Password changed
Connected.
SQL>

2、修改管理员密码

sql
alter user sys identified by 5208;

alter user system identified by 5208;

3、设置密码过期时间为永不过期

Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

4、设置密码登录尝试次数为不受限

alter profile default limit failed_login_attempts unlimited;

5、创建表空间

sql
CREATE SMALLFILE TABLESPACE "ODB" DATAFILE '/opt/oracle/app/oradata/orcl/ODB1' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

ALTER TABLESPACE "ODB" ADD DATAFILE '/opt/oracle/app/oradata/orcl/ODB2' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;

--同样设置loong表空间以及用户

6、创建用户和密码

create user ODBA identified by 5208 default tablespace ODB;

7、添加dba权限

grant connect,resource,dba to ODBA;