yycx/oracle11 repository overview

⁠Info

基于jaspeen/oracle-11g⁠，参考经验⁠，已安装Oracle11g(11.2.0.4)版本。

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> 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、修改管理员密码

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、创建表空间

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;