【YUNBEE云贝-ORACLE】Linux x86-64 安装Oracle 23AI指南

#!/bin/bash
# 安装Oracle数据库23c的示例脚本

# 定义Oracle软件包的下载URL
ORACLE_YUM_REPO_URL="http://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-ee-23c-1.0-1.x86_64.rpm"

# 安装必要的软件包和依赖
sudo yum install -y oracle-database-preinstall-23c

# 创建Oracle安装目录
sudo mkdir -p /u01/app/oracle
sudo chown -R oracle:oinstall /u01
sudo chmod -R 775 /u01

# 下载并安装Oracle数据库软件包
sudo yum install -y ${ORACLE_YUM_REPO_URL}

# 配置环境变量
echo "export ORACLE_HOME=/u01/app/oracle/product/23c/dbhome_1" >> ~oracle/.bashrc
echo "export PATH=\$PATH:\$ORACLE_HOME/bin" >> ~oracle/.bashrc
source ~oracle/.bashrc

# 设置Oracle实例
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbName yunbee_db \
-sid yunbee_db \
-createAsContainerDatabase false \
-characterSet AL32UTF8 \
-sysPassword Yunbee123 \
-systemPassword Yunbee123 \
-createSysDBA true

# 完成安装后的配置
sqlplus / as sysdba <<EOF
ALTER SYSTEM SET processes=1000 SCOPE=SPFILE;
ALTER SYSTEM SET sessions=1105 SCOPE=SPFILE;
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;
EXIT;
EOF