su -
echo 'set enable-bracketed-paste off' >>/etc/inputrc
vi /etc/yum.repos.d/rhel9-media.repo[rhel9-media-baseos]name=RHEL 9 DVD - BaseOSbaseurl=file:///mnt/cdrom/BaseOSenabled=1gpgcheck=0
[rhel9-media-appstream]name=RHEL 9 DVD - AppStreambaseurl=file:///mnt/cdrom/AppStreamenabled=1gpgcheck=0
lsblk -fmkdir -p -m 777 /mnt/cdrommount /dev/sr1 /mnt/cdrommount /dev/sr0 /mnt/cdrom
df -h
mkdir -p -m 777 /data/instmedia/mkdir -p -m 777 /data/instmedia/oracle
dnf install /data/instmedia/oracle/oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm
echo oracle | passwd oracle --stdin
mkdir -p /hub/pp1chown -R oracle:oinstall /hub/pp1chmod -R 775 /hub/pp1
Oracle Grid Infrastructure用グループ・ユーザー作成groupadd -g 55323 asmdbagroupadd -g 55324 asmopergroupadd -g 55325 asmadminuseradd -u 55322 -g oinstall -G asmadmin,asmdba,asmoper gridusermod -G dba,asmdba,asmadmin oracleecho grid | passwd -u grid --stdin -f
Oracle Grid Infrastructure用ディレクトリ作成（作らない）mkdir -p /hub/pp1/gridmkdir -p /hub/pp1/26ai/gridchmod -R 775 /hub/pp1/gridchmod -R 775 /hub/pp1/26ai/gridchown grid:oinstall /hub/pp1/gridchown grid:oinstall /hub/pp1/26ai/grid
cd /data/instmedia/oraclerpm -ivh oracleasm-support-3.1.1-5.el9.x86_64.rpm oracleasmlib-3.1.3-1.el9.x86_64.rpm
sysctl -a | grep uringecho 'kernel.io_uring_disabled = 0' > /etc/sysctl.d/oracleasmlib_io_uring.confecho '#kernel.io_uring_disabled = 1' > /etc/sysctl.d/oracleasmlib_io_uring.confecho '#kernel.io_uring_group = 55325' >> /etc/sysctl.d/oracleasmlib_io_uring.confsysctl -p /etc/sysctl.d/oracleasmlib_io_uring.confsysctl -a | grep uring
systemctl status firewalldsystemctl disable firewalld --nowsystemctl status firewalldsystemctl mask avahi-daemon.socket --nowsystemctl mask avahi-daemon.service --nowsystemctl status avahi-daemon.service avahi-daemon.socket
uname -nhostnamectl set-hostname hub3sudk1a
grubby --update-kernel=ALL --args="ipv6.disable=1"
vi /etc/security/limits.d/grid.confgrid soft nofile 1024grid hard nofile 65536grid soft nproc 16384grid hard nproc 16384grid soft stack 10240grid hard stack 32768
ens160 hostonlyens192 NATens256 pubens224 vip
nmcli c mod ens256 ipv4.addresses 192.168.2.30/24 ipv4.method manual ipv6.method ignorenmcli c mod ens224 ipv4.addresses 192.168.1.1/24 ipv4.method manual ipv6.method ignore
nmcli c mod ens256 ipv4.ignore-auto-dns yesnmcli c mod ens224 ipv4.ignore-auto-dns yesnmcli c mod ens192 ipv4.ignore-auto-dns yesnmcli c mod ens160 ipv4.ignore-auto-dns yes
nmcli con up ens256nmcli con up ens224nmcli con up ens192nmcli con up ens160
ip a
vi /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.2.30 hub3sudk1a hub3sudk1x192.168.2.31 hub3sudk1y192.168.2.32 hub3sudk1z192.168.1.1 hub3sudk1i
#nmcli c show#nmcli c show ens192 | grep dns#nmcli c show ens224 | grep dns#nmcli c show ens160 | grep dns#nmcli c mod ens224 ipv4.dns ""#nmcli c mod ens224 ipv4.ignore-auto-dns yes#nmcli c mod ens192 ipv4.ignore-auto-dns yes#nmcli c mod ens160 ipv4.ignore-auto-dns yes#nmcli c mod ens160 ipv4.dns ""#nmcli c show ens224 | grep dns#nmcli c show ens160 | grep dns#nmcli c up ens192#nmcli c up ens224#nmcli c up ens160cat /etc/resolv.conf
systemctl reboot
fdisk -l | grep 100parted /dev/sda rm 1parted /dev/sdb rm 1parted /dev/sdc rm 1parted /dev/sdd rm 1parted /dev/sde rm 1parted -s /dev/sda mklabel gptparted -s /dev/sdb mklabel gptparted -s /dev/sdc mklabel gptparted -s /dev/sdd mklabel gptparted -s /dev/sde mklabel gptparted -s /dev/sda mkpart primary 0% 100%parted -s /dev/sdb mkpart primary 0% 100%parted -s /dev/sdc mkpart primary 0% 100%parted -s /dev/sdd mkpart primary 0% 100%parted -s /dev/sde mkpart primary 0% 100%fdisk -l | grep 100
#######################################udevを使う場合#######################################
udevadm info --query=property --name=/dev/sda1 | grep ID_PART_ENTRY_UUIDudevadm info --query=property --name=/dev/sdb1 | grep ID_PART_ENTRY_UUIDudevadm info --query=property --name=/dev/sdc1 | grep ID_PART_ENTRY_UUIDudevadm info --query=property --name=/dev/sdd1 | grep ID_PART_ENTRY_UUIDudevadm info --query=property --name=/dev/sde1 | grep ID_PART_ENTRY_UUID
ID_PART_ENTRY_UUID=842eb8b6-553d-4446-b04a-f3b4095c2d28ID_PART_ENTRY_UUID=64a306f7-92f4-4022-8f5f-04268ffffe31ID_PART_ENTRY_UUID=8b330f43-a2de-4db0-8949-99a4f9ce8366ID_PART_ENTRY_UUID=96fa9185-bc88-4471-8cfe-d9722042913bID_PART_ENTRY_UUID=d1f8fcc1-70bd-47e2-aece-dd86e27515fb
vi /etc/udev/rules.d/99-oracle-asm.rulesENV{ID_PART_ENTRY_UUID}=="842eb8b6-553d-4446-b04a-f3b4095c2d28", OWNER="grid", GROUP="asmdba", MODE="0660", SYMLINK+="asm/ASMDISK01_100"ENV{ID_PART_ENTRY_UUID}=="64a306f7-92f4-4022-8f5f-04268ffffe31", OWNER="grid", GROUP="asmdba", MODE="0660", SYMLINK+="asm/ASMDISK02_100"ENV{ID_PART_ENTRY_UUID}=="8b330f43-a2de-4db0-8949-99a4f9ce8366", OWNER="grid", GROUP="asmdba", MODE="0660", SYMLINK+="asm/ASMDISK03_100"ENV{ID_PART_ENTRY_UUID}=="96fa9185-bc88-4471-8cfe-d9722042913b", OWNER="grid", GROUP="asmdba", MODE="0660", SYMLINK+="asm/ASMDISK04_100"ENV{ID_PART_ENTRY_UUID}=="d1f8fcc1-70bd-47e2-aece-dd86e27515fb", OWNER="grid", GROUP="asmdba", MODE="0660", SYMLINK+="asm/ASMDISK05_100"
systemctl reboot
ll /dev/asm/ll /dev/sd?1
#######################################ASMLibを使う場合#######################################
oracleasm versionoracleasm statusoracleasm configure -i Configuring the Oracle ASM system service.
This will configure the on-boot properties of the Oracle ASM system service. The following questions will determine whether the service is started on boot and what permissions it will have. The current values will be shown in brackets ('[]'). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will abort.
Default user to own the ASM disk devices []: grid Default group to own the ASM disk devices []: asmadmin Start Oracle ASM system service on boot (y/n) [y]: y Scan for Oracle ASM disks when starting the oracleasm service (y/n) [y]: y Maximum number of ASM disks that can be used on system [2048]: 2048 Enable iofilter if kernel supports it (y/n) [y]: y
WARNING: I/O filtering not supported with RHEL8 on x86_64
Writing Oracle ASM system service configuration: done
Configuration changes only come into effect after the Oracle ASM system service is restarted. Please run 'systemctl restart oracleasm' after making changes.
WARNING: All of your Oracle and ASM instances must be stopped prior to restarting the oracleasm service.
oracleasm configureoracleasm configure --iofilter yoracleasm configuresystemctl status oracleasmsystemctl start oracleasmoracleasm initsystemctl restart oracleasmoracleasm scandisks
systemctl reboot
oracleasm createdisk ASMDISK01 /dev/sda1oracleasm createdisk ASMDISK02 /dev/sdb1oracleasm createdisk ASMDISK03 /dev/sdc1oracleasm createdisk ASMDISK04 /dev/sdd1oracleasm createdisk ASMDISK05 /dev/sde1oracleasm listdisks
oracleasm querydisk /dev/sda1oracleasm querydisk /dev/sdb1oracleasm querydisk /dev/sdc1oracleasm querydisk /dev/sdd1oracleasm querydisk /dev/sde1
ls -l /dev/disk/by-label/
systemctl reboot
ls -l /dev/sd[a-e]1oracleasm discover
oracleasm querydisk -i ASMDISK05oracleasm discover -l
systemctl poweroffスナップショット「GIインストール前」
Oracle Grid Infrastructureインストール
su - gridunzip /data/instmedia/oracle/LINUX.X64_2326100_grid_home.zip -d /hub/pp1/26ai/gridecho $?
exityum install /hub/pp1/26ai/grid/cv/rpm/cvuqdisk-1.0.10-1.rpmsu - grid
/hub/pp1/26ai/grid/runcluvfy.sh stage -pre crsinst -n hub3sudk1a | sed -e 's/合格/\x1b[32m&\x1b[0m/g' -e 's/失敗/\x1b[31m&\x1b[0m/g'
GUIsu - gridxhost +export DISPLAY=:0export LANG=C;echo $LANG/hub/pp1/26ai/grid/gridSetup.sh
/hub/pp1/oraInventory/orainstRoot.sh/hub/pp1/26ai/grid/root.shecho $?
su -/hub/pp1/26ai/grid/bin/crsctl stop crs
systemctl poweroffスナップショット「GIインストール後」
/hub/pp1/26ai/grid/bin/crsctl stat res -t--------------------------------------------------------------------------------Name Target State Server State details--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.LISTENER.lsnr ONLINE ONLINE hub3sudk1a STABLEora.chad ONLINE ONLINE hub3sudk1a STABLEora.helper OFFLINE OFFLINE hub3sudk1a IDLE,STABLEora.net1.network ONLINE ONLINE hub3sudk1a STABLEora.ons ONLINE ONLINE hub3sudk1a STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE hub3sudk1a STABLEora.CRSDG_1.dg(ora.asmgroup) 1 ONLINE ONLINE hub3sudk1a STABLEora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE hub3sudk1a STABLEora.asm(ora.asmgroup) 1 ONLINE ONLINE hub3sudk1a Started,STABLEora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE hub3sudk1a STABLEora.cdp1.cdp 1 OFFLINE OFFLINE STABLEora.cvu 1 ONLINE ONLINE hub3sudk1a STABLEora.cvuhelper 1 OFFLINE OFFLINE STABLEora.hub3sudk1a.vip 1 ONLINE ONLINE hub3sudk1a STABLEora.rhpserver 1 OFFLINE OFFLINE STABLEora.scan1.vip 1 ONLINE ONLINE hub3sudk1a STABLE--------------------------------------------------------------------------------
cp -p /etc/sysctl.conf /etc/sysctl.conf_`date '+%Y%m%d'`bkecho 'vm.nr_hugepages = 2048' >>/etc/sysctl.confsysctl -psysctl vm.nr_hugepagesgrep -i Huge /proc/meminfo
cd /hub/pp1mkdir -p oraclechown oracle:oinstall oraclesu - oracleumaskcd /hub/pp1mkdir -p /hub/pp1/oracle/product/26ai/dbls -ld /hub/pp1/oracle/product/26ai/dbzipinfo /data/instmedia/oracle/LINUX.X64_2326100_db_home.zip | headunzip /data/instmedia/oracle/LINUX.X64_2326100_db_home.zip -d /hub/pp1/oracle/product/26ai/dbecho $?
xhost +export DISPLAY=:0export LANG=C;echo $LANGumask
/hub/pp1/oracle/product/26ai/db/runInstaller
/hub/pp1/oracle/product/26ai/db/root.shecho $?
systemctl poweroffスナップショット「DBインストール後」
GI設定export ORACLE_HOME=/hub/pp1/26ai/gridexport PATH=$PATH:/hub/pp1/26ai/grid/bin
/hub/pp1/26ai/grid/bin/crsctl config crsCRS-4622: Oracle High Availability Services autostart is enabled.
/hub/pp1/26ai/grid/bin/crsctl disable crsCRS-4621: Oracle High Availability Services autostart is disabled.
/hub/pp1/26ai/grid/bin/crsctl config crsCRS-4621: Oracle High Availability Services autostart is disabled.
su - gridexport ORACLE_HOME=/hub/pp1/26ai/gridexport PATH=$PATH:/hub/pp1/26ai/grid/bin
srvctl config listenersrvctl status listenersrvctl stop listenersrvctl modify listener -listener LISTENER -endpoints "TCP:1522"srvctl config listenersrvctl start listenersrvctl status listener
cd $ORACLE_HOME/network/admin
cp -p listener.ora listener.ora_`date '+%Y%m%d'`bkecho 'ADR_BASE_LISTENER=/hub/pp1/grid' >>listener.oradiff listener.ora_`date '+%Y%m%d'`bk listener.ora
cp -p sqlnet.ora sqlnet.ora_`date '+%Y%m%d'`bkecho 'ADR_BASE=/hub/pp1/grid' >>sqlnet.oraecho 'SQLNET.EXPIRE_TIME=10' >>sqlnet.oradiff sqlnet.ora_`date '+%Y%m%d'`bk sqlnet.ora
exitexport ORACLE_HOME=/hub/pp1/26ai/gridexport PATH=$PATH:/hub/pp1/26ai/grid/bin
crsctl stat res -tsrvctl status scan_listenersrvctl stop scan_listenersrvctl disable scan_listenersrvctl status scan_listener
srvctl status scansrvctl stop scansrvctl disable scansrvctl status scancrsctl stat res -t
ocrcheckocrconfig -showbackuploc
DG作成export ORACLE_HOME=/hub/pp1/26ai/gridexport PATH=$PATH:/hub/pp1/26ai/grid/bin
vi .modify_profileexport ORACLE_HOME=/hub/pp1/26ai/gridexport PATH=$PATH:/hub/pp1/26ai/grid/binexport ORACLE_SID=+ASM1export TNS_ADMIN=${ORACLE_HOME}/network/adminexport NLS_LANG=Japanese_Japan.AL32UTF8export ORACLE_PATH=/home/grid/sqlplusexport LANG=Ccat .modify_profile. .modify_profilesqlplus / as sysasmset lines 10000col name for a10col COMPATIBILITY for a15col DATABASE_COMPATIBILITY for a15select group_number,name,state,type,allocation_unit_size,total_mb,usable_file_mb,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;create diskgroup ARCDG_1 external redundancy disk '/dev/asm/ASMDISK02_100' attribute 'au_size'='4M';create diskgroup ARCDG_2 external redundancy disk '/dev/asm/ASMDISK03_100' attribute 'au_size'='4M';create diskgroup REDODG_1 external redundancy disk '/dev/asm/ASMDISK04_100' attribute 'au_size'='4M';create diskgroup DATADG_1 external redundancy disk '/dev/asm/ASMDISK05_100' attribute 'au_size'='4M';select group_number,name,state,type,allocation_unit_size,total_mb,usable_file_mb,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;
su - oracle
xhost +export DISPLAY=:0export LANG=C;echo $LANGumask
/hub/pp1/oracle/product/26ai/db/bin/dbca
cd /hub/pp1/oracle/adminzip -r HUB3C01.zip HUB3C01chmod 777 /hub/pp1/oracle/admin/HUB3C01.zipcp -p /hub/pp1/oracle/admin/HUB3C01.zip /tmp/tmp/HUB3C01.zip
Oracle RACインストール