[root@localhost ~]# docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES ee92e88fea08 truevoly/oracle-12c "/entrypoint.sh " 6 minutes ago Up 6 minutes 0.0.0.0:1521->1521/tcp, :::1521->1521/tcp, 0.0.0.0:2122->22/tcp, :::2122->22/tcp, 0.0.0.0:9090->8080/tcp, :::9090->8080/tcp oracle12c //进入容器内部 [root@localhost ~]# docker exec -it ee92e88fea08 /bin/bash //切换成oracle用户 root@ee92e88fea08:/# su oracle //进入sqlplus oracle@ee92e88fea08:/$ $ORACLE_HOME/bin/sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 1 03:15:37 2021
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production //设置密码有效期为无限制 SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered. //解锁system用户 SQL> alter user SYSTEM account unlock;
User altered. //创建一个账号为test_lx的用户密码设置为test_lx SQL> create user test_lx identified by test_lx;
User created. //为这个用户赋予管理员的权限 SQL> grant dba to test_lx;