# Docker部署Oracle步骤
1. 安装Docker
2. 拉取Oracle镜像
3. 创建数据卷
4. 运行容器
5. 配置数据库

# 示例：拉取Oracle镜像
$ docker pull container-registry.oracle.com/database/enterprise:19.3.0.0

# 示例：创建数据卷
$ docker volume create oracle-data

# 示例：运行容器
$ docker run -d \
–name oracle-db \
-p 1521:1521 \
-p 5500:5500 \
-v oracle-data:/opt/oracle/oradata \
-e ORACLE_PWD=YourPassword123 \
container-registry.oracle.com/database/enterprise:19.3.0.0

# 查看容器状态
$ docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
1234567890ab container-registry.oracle.com/database/enterprise:19.3.0.0 “/bin/sh -c ‘exec $O…” 5 minutes ago Up 5 minutes (healthy) 0.0.0.0:1521->1521/tcp, :::1521->1521/tcp, 0.0.0.0:5500->5500/tcp, :::5500->5500/tcp oracle-db

# 连接数据库
$ sqlplus sys/YourPassword123@localhost:1521/ORCLCDB as sysdba

SQL*Plus: Release 19.0.0.0.0 – Production on Thu Apr 5 10:00:00 2026
Version 19.3.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.3.0.0.0 – Production
Version 19.3.0.0.0

SQL> SELECT status FROM v$instance;

STATUS
————-
OPEN

# Kubernetes部署Oracle步骤
1. 安装Kubernetes集群
2. 创建命名空间
3. 创建持久卷和持久卷声明
4. 创建配置文件和密钥
5. 创建部署和服务

# 示例：创建命名空间
$ kubectl create namespace oracle

# 示例：创建持久卷声明
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
name: oracle-pvc
namespace: oracle
spec:
accessModes:
– ReadWriteOnce
resources:
requests:
storage: 50Gi

# 示例：创建部署
apiVersion: apps/v1
kind: Deployment
metadata:
name: oracle-db
namespace: oracle
spec:
replicas: 1
selector:
matchLabels:
app: oracle-db
template:
metadata:
labels:
app: oracle-db
spec:
containers:
– name: oracle-db
image: container-registry.oracle.com/database/enterprise:19.3.0.0
ports:
– containerPort: 1521
– containerPort: 5500
env:
– name: ORACLE_PWD
valueFrom:
secretKeyRef:
name: oracle-secret
key: password
volumeMounts:
– name: oracle-data
mountPath: /opt/oracle/oradata
volumes:
– name: oracle-data
persistentVolumeClaim:
claimName: oracle-pvc

# 示例：创建服务
apiVersion: v1
kind: Service
metadata:
name: oracle-service
namespace: oracle
spec:
selector:
app: oracle-db
ports:
– port: 1521
targetPort: 1521
– port: 5500
targetPort: 5500
type: LoadBalancer

# 查看部署状态
$ kubectl get all -n oracle

NAME READY STATUS RESTARTS AGE
pod/oracle-db-1234567890-abcde 1/1 Running 0 10m

NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE
service/oracle-service LoadBalancer 10.96.123.45 192.168.1.100 1521:30001/TCP,5500:30002/TCP 10m

NAME READY UP-TO-DATE AVAILABLE AGE
deployment.apps/oracle-db 1/1 1 1 10m

# Docker容器管理
– 启动容器：docker start container_name
– 停止容器：docker stop container_name
– 重启容器：docker restart container_name
– 查看容器日志：docker logs container_name
– 进入容器：docker exec -it container_name bash
– 备份容器：docker commit container_name image_name
– 导出容器：docker export container_name > container.tar
– 导入容器：docker import container.tar image_name

# Kubernetes容器管理
– 查看Pod：kubectl get pods -n namespace
– 查看日志：kubectl logs pod_name -n namespace
– 进入Pod：kubectl exec -it pod_name -n namespace — bash
– 缩放部署：kubectl scale deployment deployment_name –replicas=3 -n namespace
– 滚动更新：kubectl set image deployment/deployment_name container_name=image:tag -n namespace
– 回滚：kubectl rollout undo deployment/deployment_name -n namespace

# 示例：查看容器日志
$ docker logs oracle-db

ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: YourPassword123

LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 05-APR-2026 10:00:00

Copyright (c) 1991, 2026, Oracle. All rights reserved.

Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 19.0.0.0.0 – Production
System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/7f8c1a2b3c4d/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 05-APR-2026 10:00:00
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/7f8c1a2b3c4d/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Services Summary…
Service “ORCLCDB” has 1 instance(s).
Instance “ORCLCDB”, status READY, has 1 handler(s) for this service…
Service “ORCLCDBXDB” has 1 instance(s).
Instance “ORCLCDB”, status READY, has 1 handler(s) for this service…
The command completed successfully