# 示例：拉取Oracle 26ai镜像
$ docker pull oracle/database:26ai-enterprise

# 示例：创建Docker网络
$ docker network create oracle-network

# 示例：启动Oracle 26ai容器
$ docker run -d \
–name oracle26ai \
–network oracle-network \
-p 1521:1521 \
-p 5500:5500 \
-e ORACLE_PWD=Oracle123 \
-e ORACLE_SID=ORCL \
-e ORACLE_PDB=PDB1 \
-v oracle-data:/opt/oracle/oradata \
oracle/database:26ai-enterprise

# 示例：查看容器状态
$ docker ps -a

# 示例：查看容器日志
$ docker logs oracle26ai

# 示例：进入容器
$ docker exec -it oracle26ai bash

# 示例：连接数据库
$ sqlplus sys/Oracle123@localhost:1521/ORCL as sysdba

# 示例：创建用户
SQL> CREATE USER scott IDENTIFIED BY tiger;
SQL> GRANT CONNECT, RESOURCE TO scott;

# 示例：停止容器
$ docker stop oracle26ai

# 示例：启动容器
$ docker start oracle26ai

# 示例：删除容器
$ docker rm -f oracle26ai

# 示例：查看数据卷
$ docker volume ls

# 示例：删除数据卷
$ docker volume rm oracle-data

# 示例：docker-compose.yml文件
version: ‘3.8’
services:
oracle26ai:
image: oracle/database:26ai-enterprise
container_name: oracle26ai
ports:
– “1521:1521”
– “5500:5500”
environment:
– ORACLE_PWD=Oracle123
– ORACLE_SID=ORCL
– ORACLE_PDB=PDB1
volumes:
– oracle-data:/opt/oracle/oradata
networks:
– oracle-network
restart: unless-stopped

volumes:
oracle-data:

networks:
oracle-network:
driver: bridge

# 示例：启动服务
$ docker-compose up -d

# 示例：查看服务状态
$ docker-compose ps

# 示例：查看服务日志
$ docker-compose logs oracle26ai

# 示例：停止服务
$ docker-compose down

# 示例：启动服务（重新创建）
$ docker-compose up -d –force-recreate

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

# 示例：创建存储类
apiVersion: storage.k8s.io/v1
kind: StorageClass
metadata:
name: oracle-storage
namespace: oracle
provisioner: kubernetes.io/aws-ebs
parameters:
type: gp2
reclaimPolicy: Retain
allowVolumeExpansion: true

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

# 示例：部署Oracle 26ai
apiVersion: apps/v1
kind: Deployment
metadata:
name: oracle26ai
namespace: oracle
spec:
replicas: 1
selector:
matchLabels:
app: oracle26ai
template:
metadata:
labels:
app: oracle26ai
spec:
containers:
– name: oracle26ai
image: oracle/database:26ai-enterprise
ports:
– containerPort: 1521
– containerPort: 5500
env:
– name: ORACLE_PWD
value: “Oracle123”
– name: ORACLE_SID
value: “ORCL”
– name: ORACLE_PDB
value: “PDB1”
volumeMounts:
– name: oracle-data
mountPath: /opt/oracle/oradata
volumes:
– name: oracle-data
persistentVolumeClaim:
claimName: oracle-pvc

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

# 示例：部署到Kubernetes
$ kubectl apply -f storage-class.yaml -n oracle
$ kubectl apply -f pvc.yaml -n oracle
$ kubectl apply -f deployment.yaml -n oracle
$ kubectl apply -f service.yaml -n oracle

# 示例：查看部署状态
$ kubectl get pods -n oracle
$ kubectl get services -n oracle

# 示例：查看日志
$ kubectl logs deployment/oracle26ai -n oracle

# 示例：连接数据库
$ sqlplus sys/Oracle123@$(kubectl get service oracle26ai -n oracle -o jsonpath='{.status.loadBalancer.ingress[0].ip}’):1521/ORCL as sysdba

# 示例：安装Helm
$ curl https://raw.githubusercontent.com/helm/helm/master/scripts/get-helm-3 | bash

# 示例：添加Oracle Chart仓库
$ helm repo add oracle https://oracle.github.io/helm-charts
$ helm repo update

# 示例：创建values.yaml文件
image:
repository: oracle/database
tag: 26ai-enterprise

environment:
ORACLE_PWD: Oracle123
ORACLE_SID: ORCL
ORACLE_PDB: PDB1

persistence:
enabled: true
storageClass: oracle-storage
size: 50Gi

service:
type: LoadBalancer
ports:
listener:
port: 1521
em:
port: 5500

# 示例：部署Chart
$ helm install oracle26ai oracle/oracle-database -n oracle -f values.yaml

# 示例：查看部署状态
$ helm status oracle26ai -n oracle
$ kubectl get pods -n oracle

# 示例：升级部署
$ helm upgrade oracle26ai oracle/oracle-database -n oracle -f values.yaml

# 示例：删除部署
$ helm uninstall oracle26ai -n oracle

# 示例：与AWS S3集成

# 1. 安装s3fs
$ yum install s3fs-fuse

# 2. 配置S3访问
$ echo “your-access-key:your-secret-key” > ~/.passwd-s3fs
$ chmod 600 ~/.passwd-s3fs

# 3. 挂载S3存储
$ mkdir /mnt/s3
$ s3fs your-bucket /mnt/s3 -o passwd_file=~/.passwd-s3fs -o url=https://s3.amazonaws.com

# 4. 配置Oracle使用S3存储
SQL> ALTER SYSTEM SET db_recovery_file_dest = ‘/mnt/s3/fast_recovery_area’ SCOPE=SPFILE;
SQL> ALTER SYSTEM SET db_recovery_file_dest_size = 10G SCOPE=SPFILE;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

# 示例：与Azure Blob Storage集成

# 1. 安装blobfuse
$ wget https://packages.microsoft.com/config/rhel/7/packages-microsoft-prod.rpm
$ sudo rpm -Uvh packages-microsoft-prod.rpm
$ sudo yum install blobfuse

# 2. 配置Blob Storage访问
$ mkdir -p ~/blobfuse
$ echo “accountName=your-account-name
accountKey=your-account-key
containerName=your-container-name” > ~/blobfuse/fuse_connection.cfg
$ chmod 600 ~/blobfuse/fuse_connection.cfg

# 3. 挂载Blob Storage
$ mkdir /mnt/blobfuse
$ blobfuse /mnt/blobfuse –config-file=~/blobfuse/fuse_connection.cfg

# 4. 配置Oracle使用Blob Storage
SQL> ALTER SYSTEM SET db_recovery_file_dest = ‘/mnt/blobfuse/fast_recovery_area’ SCOPE=SPFILE;
SQL> ALTER SYSTEM SET db_recovery_file_dest_size = 10G SCOPE=SPFILE;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

# 示例：与Google Cloud Storage集成

# 1. 安装gcsfuse
$ echo “deb https://packages.cloud.google.com/apt gcsfuse-$(lsb_release -c -s) main” | sudo tee /etc/apt/sources.list.d/gcsfuse.list
$ curl https://packages.cloud.google.com/apt/doc/apt-key.gpg | sudo apt-key add –
$ sudo apt-get update
$ sudo apt-get install gcsfuse

# 2. 配置GCS访问
$ gcloud auth login

# 3. 挂载GCS存储
$ mkdir /mnt/gcs
$ gcsfuse your-bucket /mnt/gcs

# 4. 配置Oracle使用GCS存储
SQL> ALTER SYSTEM SET db_recovery_file_dest = ‘/mnt/gcs/fast_recovery_area’ SCOPE=SPFILE;
SQL> ALTER SYSTEM SET db_recovery_file_dest_size = 10G SCOPE=SPFILE;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;