第一步下载

主要是preinstall 以及 zip包的处理

具体地址不放了, 开放时间大概是 2024.7.29 左右

需要注意 这个是 exadata 的安装介质

安装方式比较繁琐 并且因为使用了 银河麒麟的操作系统

难度是double. 

本次耗时 2h 从下午六点左右开始到八点安装完成

感谢 惜分飞大神和方神的帮助.

复制

安装preinstall

cat > etc/oracle-release <<EOF
CentOS Linux release 8.0
EOF

然后
yum install ksh* libaio* libnsl*  -y
rpm -ivh  oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm --nodeps --force

复制

创建目录

mkdir -p u01/app/oracle/product/23/db_1
chown -R oracle:oinstall u01/app/
chmod -R 775 u01/app/

mkdir -p home/oracle/etc
chown -R oracle:oinstall home/oracle/etc
chmod -R 775 home/oracle/etc

mkdir -p home/data
chown -R oracle:oinstall home/data
chmod -R 775 home/data

复制

修改环境变量

cat >/etc/profile.d/oracle.sh <<EOF
export ORACLE_SID=ora23ai    #数据库database.rsp中的SID 
export ORACLE_BASE=/u01/app/oracle                   #BASE目录
export ORACLE_HOME=/u01/app/oracle/product/23/db_1   #oracle安装包的目录
export PATH=/u01/app/oracle/product/23/db_1/bin:/u01/app/oracle/product/23/db_1/OPatch:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/lib/usr/lib:/usr/local/lib
export TEMP=/tmp
export TMP=/tmp
export LC_ALL=en_US.UTF-8
export LANG=en_US.UTF-8
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

set -o vi
stty erase ^h

if [ -t 0 ]; then
   stty intr ^C
fi
umask 022
EOF

cat >/home/oracle/.bashrc <<EOF
export ORACLE_SID=ORA23ai    #数据库database.rsp中的SID 
export ORACLE_BASE=/u01/app/oracle                   #BASE目录
export ORACLE_HOME=/u01/app/oracle/product/23/db_1   #oracle安装包的目录
export PATH=/u01/app/oracle/product/23/db_1/bin:/u01/app/oracle/product/23/db_1/OPatch:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/lib/usr/lib:/usr/local/lib
export TEMP=/tmp
export TMP=/tmp
export LC_ALL=en_US.UTF-8
export LANG=en_US.UTF-8
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
EOF

复制

安装过程

scp V1043785-01.zip u01/app/oracle/product/23/db_1/
cd u01/app/oracle/product/23/db_1/
unzip V1043785-01.zip
chown -R oracle:oinstall u01/app/
chmod -R 775 u01/app/
切换到 oracle用户

scp  u01/app/oracle/product/23/db_1/install/response/db_install.rsp  home/oracle/etc/
scp u01/app/oracle/product/23/db_1/assistants/netca/netca.rsp  home/oracle/etc/
scp u01/app/oracle/product/23/db_1/assistants/dbca/dbca.rsp home/oracle/etc/

复制

修改配置文件

cat > home/oracle/etc/db_install.rsp <<EOF
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v23.0.0
oracle.install.option=INSTALL_DB_SWONLY 
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/23/db_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=dba
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba
oracle.install.db.rootconfig.executeRootScript=
oracle.install.db.rootconfig.configMethod=
oracle.install.db.rootconfig.sudoPath=
oracle.install.db.rootconfig.sudoUserName=
oracle.install.db.CLUSTER_NODES=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=ORA23ai
oracle.install.db.config.starterdb.SID=ORA23ai
oracle.install.db.ConfigureAsContainerDB=
oracle.install.db.config.PDBName=
oracle.install.db.config.starterdb.characterSet=ZHS16GBK
oracle.install.db.config.starterdb.memoryOption=
oracle.install.db.config.starterdb.memoryLimit=
oracle.install.db.config.starterdb.installExampleSchemas=
oracle.install.db.config.starterdb.password.ALL=xxxxxxxxxxxx
oracle.install.db.config.starterdb.password.SYS=xxxxxxxxxxxx
oracle.install.db.config.starterdb.password.SYSTEM=xxxxxxxxxxxx
oracle.install.db.config.starterdb.password.DBSNMP=xxxxxxxxxxxx
oracle.install.db.config.starterdb.password.PDBADMIN=xxxxxxxxxxxx
oracle.install.db.config.starterdb.managementOption=
oracle.install.db.config.starterdb.omsHost=
oracle.install.db.config.starterdb.omsPort=
oracle.install.db.config.starterdb.emAdminUser=
oracle.install.db.config.starterdb.emAdminPassword=
oracle.install.db.config.starterdb.enableRecovery=
oracle.install.db.config.starterdb.storageType=
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
EOF

复制

执行安装

chown oracle:oinstall home/oracle/ -R
chown oracle:oinstall u01/ -R
mkdir -p oradata/ORA23ai/audit
chown oracle:oinstall oradata/ORA123ai/audit -R

su - oracle
cd   u01/app/oracle/product/23/db_1
rm -rf u01/app/oraInventory/*
export CV_ASSUME_DISTID=RHEL7.6
mkdir -p u01/temp
export TMP=/u01/temp
export TMPDIR=/u01/temp

./runInstaller -silent -responseFile home/oracle/etc/db_install.rsp -ignorePrereq -J"-Doracle.install.db.validate.supportedOSCheck=false"


exit  到 root用户执行如下命令
mkdir -p u01/app/oracle/admin/orcl/adump
mkdir -p u01/app/oracle/fast_recovery_area

/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/23/db_1/root.sh

复制

创建数据库

su - oracle 
mkdir -p u01/app/oracle/data
cd u01/app/oracle/data
chown oracle:oinstall u01/app/ -R

注意 需要生成叫苦脚本 修改参数再进行相关操作
dbca -silent -generateScripts  -templateName General_Purpose.dbc \
 -gdbname ora23ai -sid ora23ai  \
 -characterSet ZHS16GBK -datafileDestination u01/app/oracle/data  \
 -memoryPercentage 50 -emConfiguration LOCAL

注意路径为 
/u01/app/oracle/admin/ora23ai/scripts

需要注意 至少要改三个文件 三个 .ora的都要增加这个参数

_exadata_feature_on=true

执行脚本: sh ora23ai.sh

复制

进行验证

[oracle@oracle23ai scripts]$ sqlplus / as sysdba

SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Thu Sep 5 19:47:53 2024
Version 23.5.0.24.07

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


Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.5.0.24.07

SQL> select * from v$version
  2  ;

BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
    CON_ID
----------
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
d Engineered Systems
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
d Engineered Systems
Version 23.5.0.24.07

BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
    CON_ID
----------
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
d Engineered Systems


复制

创建pdb

# oracle用户下
mkdir -p /u01/app/oracle/data/ora23aipdb01

进入 sqlplus
sqlplus / as sysdba

create pluggable database ora23aipdb01 admin user ora23aipdb01 identified by xxxxxxxxxxxx file_name_convert=('/u01/app/oracle/data/ORA23AI/pdbseed','/u01/app/oracle/data/ora23aipdb01');

show pdbs

alter pluggable database all open ;


CREATE TRIGGER open_all_pdbs
   AFTER STARTUP ON DATABASE
BEGIN
   EXECUTE IMMEDIATE 'alter pluggable database all open';
END open_all_pdbs;
/
复制