docker部署Oracle11g

docker部署Oracle11g

1.拉取镜像

docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

2.创建容器

docker run -d -p 1521:1521 --name oracle11g registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

4.进入容器创建用户

容器镜像系统用户root密码为 helowin

[root@localhost /]# docker exec -it oracle11g bash
[oracle@e74cdd9c494f /]$ cd /home/oracle/
[oracle@e74cdd9c494f ~]$ source .bash_profile
[oracle@e74cdd9c494f ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 28 19:02:07 2021

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> alter user system identified by system;

User altered.

SQL> alter user sys identified by system;

User altered.

SQL> create user mike identified by mikeops;

User created.

SQL> grant connect,resource,dba to mike;

Grant succeeded.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

SQL> alter system set processes=2000 scope=spfile;

System altered.

SQL> select * from dba_users t where t.username = 'MIKE';

USERNAME			  USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS			 LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE	       TEMPORARY_TABLESPACE	      CREATED
------------------------------ ------------------------------ ---------
PROFILE 		       INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
MIKE				       91

USERNAME			  USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS			 LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE	       TEMPORARY_TABLESPACE	      CREATED
------------------------------ ------------------------------ ---------
PROFILE 		       INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
OPEN

USERNAME			  USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS			 LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE	       TEMPORARY_TABLESPACE	      CREATED
------------------------------ ------------------------------ ---------
PROFILE 		       INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
USERS			       TEMP			      28-DEC-21

USERNAME			  USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS			 LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE	       TEMPORARY_TABLESPACE	      CREATED
------------------------------ ------------------------------ ---------
PROFILE 		       INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
DEFAULT 		       DEFAULT_CONSUMER_GROUP

USERNAME			  USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS			 LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE	       TEMPORARY_TABLESPACE	      CREATED
------------------------------ ------------------------------ ---------
PROFILE 		       INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------


USERNAME			  USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS			 LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE	       TEMPORARY_TABLESPACE	      CREATED
------------------------------ ------------------------------ ---------
PROFILE 		       INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G  N PASSWORD

USERNAME			  USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS			 LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE	       TEMPORARY_TABLESPACE	      CREATED
------------------------------ ------------------------------ ---------
PROFILE 		       INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------


SQL> 

5.相关命令含义

cd /home/oracle # 进入到 oracle 用户目录

source .bash_profile # 加载 oracle 环境变量

sqlplus /nolog # 登录oracle数据库

conn /as sysdba # 切换管理用户

alter user system identified by system; # 修改system用户账号密码为system

alter user sys identified by system; # 修改sys用户账号密码为system

create user mike identified by mikeops; # 创建内部管理员账号mike 密码为mikeops

grant connect,resource,dba to mike; # 将dba权限授权给内部管理员账号

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; # 修改密码规则策略为密码永不过期

alter system set processes=2000 scope=spfile; # 修改数据库最大连接数据

select * from dba_users t where t.username = ‘MIKE’; # 查看mike用户创建信息

6.使用 Navicat 连接

连接类型： Basic
主机：你的ip
端口: 1521
服务名: helowin
SID
用户名：mike
密码：mikeops