# 检查Linux系统硬件信息（在所有节点执行）
# 检查内存大小
# free -h
total used free shared buff/cache available
Mem: 63G 1.2G 58G 1.1G 3.3G 60G
Swap: 31G 0B 31G

# 检查CPU核心数
# nproc
16

# 检查磁盘空间
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 200G 6.8G 193G 4% /
devtmpfs 32G 0 32G 0% /dev
tmpfs 32G 0 32G 0% /dev/shm
tmpfs 32G 13M 32G 1% /run
tmpfs 32G 0 32G 0% /sys/fs/cgroup
/dev/sda1 497M 119M 379M 24% /boot

# 网络规划
# 节点1：fgedudb01
# 公共IP：192.168.1.51/24
# VIP：192.168.1.55/24
# 私有IP：172.16.1.51/24

# 节点2：fgedudb02
# 公共IP：192.168.1.52/24
# VIP：192.168.1.56/24
# 私有IP：172.16.1.52/24

# 节点3：fgedudb03
# 公共IP：192.168.1.53/24
# VIP：192.168.1.57/24
# 私有IP：172.16.1.53/24

# 配置网络接口（在所有节点执行）
# vi /etc/sysconfig/network-scripts/ifcfg-eth0
TYPE=Ethernet
BOOTPROTO=static
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
NAME=eth0
DEVICE=eth0
ONBOOT=yes
IPADDR=192.168.1.51
NETMASK=255.255.255.0
GATEWAY=192.168.1.1
DNS1=192.168.1.2

# vi /etc/sysconfig/network-scripts/ifcfg-eth1
TYPE=Ethernet
BOOTPROTO=static
DEFROUTE=no
IPV4_FAILURE_FATAL=no
NAME=eth1
DEVICE=eth1
ONBOOT=yes
IPADDR=172.16.1.51
NETMASK=255.255.255.0

# 重启网络服务
# systemctl restart network

# 配置主机名（在所有节点执行）
# hostnamectl set-hostname fgedudb01.fgedu.net.cn

# 配置HOSTS文件（在所有节点执行）
# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

# Public Network
192.168.1.51 fgedudb01.fgedu.net.cn fgedudb01
192.168.1.52 fgedudb02.fgedu.net.cn fgedudb02
192.168.1.53 fgedudb03.fgedu.net.cn fgedudb03

# Virtual IP
192.168.1.55 fgedudb01-vip.fgedu.net.cn fgedudb01-vip
192.168.1.56 fgedudb02-vip.fgedu.net.cn fgedudb02-vip
192.168.1.57 fgedudb03-vip.fgedu.net.cn fgedudb03-vip

# Private Network
172.16.1.51 fgedudb01-priv.fgedu.net.cn fgedudb01-priv
172.16.1.52 fgedudb02-priv.fgedu.net.cn fgedudb02-priv
172.16.1.53 fgedudb03-priv.fgedu.net.cn fgedudb03-priv

# SCAN IP
192.168.1.60 fgedudb-scan.fgedu.net.cn
192.168.1.61 fgedudb-scan.fgedu.net.cn
192.168.1.62 fgedudb-scan.fgedu.net.cn

# 安装必要的RPM包（在所有节点执行）
# yum install -y binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libxcb libX11 libXau libXi libXtst make sysstat xorg-x11-xauth xorg-x11-utils

# 配置内核参数（在所有节点执行）
# vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 16777216
kernel.shmmax = 34359738368
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2

# 应用内核参数
# sysctl -p

# 配置PAM限制（在所有节点执行）
# vi /etc/security/limits.conf
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle soft memlock 33554432
oracle hard memlock 67108864

# 配置Selinux（在所有节点执行）
# vi /etc/selinux/config
SELINUX=disabled

# 临时禁用Selinux
# setenforce 0

# 关闭防火墙（在所有节点执行）
# systemctl stop firewalld
# systemctl disable firewalld

# 关闭NetworkManager（在所有节点执行）
# systemctl stop NetworkManager
# systemctl disable NetworkManager

# 安装依赖包（在所有节点执行）
# yum install -y gcc-c++ libXrender libXext libX11 fontconfig libXft libXi

# 安装GNOME桌面环境（在所有节点执行）
# yum groupinstall -y “Server with GUI”

# 配置大页内存（在所有节点执行）
# vi /etc/sysctl.conf
vm.nr_hugepages = 16384

# 关闭透明大页（在所有节点执行）
# vi /etc/rc.local
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag

# 给rc.local添加执行权限
# chmod +x /etc/rc.d/rc.local

# 关闭NUMA（在所有节点执行）
# vi /etc/default/grub
在GRUB_CMDLINE_LINUX行添加：numa=off transparent_hugepage=never

# 生成新的grub配置文件
# grub2-mkconfig -o /boot/grub2/grub.cfg

# 配置时间同步（在所有节点执行）
# yum install -y ntp
# systemctl enable ntpd
# systemctl start ntpd

# 配置TMPFS（在所有节点执行）
# vi /etc/fstab
添加：tmpfs /dev/shm tmpfs defaults,size=32g 0 0

# 挂载TMPFS
# mount -o remount /dev/shm

# 安装iscsi客户端（在所有节点执行）
# yum install -y iscsi-initiator-utils

# 启动iscsi服务（在所有节点执行）
# systemctl enable iscsid
# systemctl start iscsid

# 发现iscsi目标（在所有节点执行）
# iscsiadm -m discovery -t st -p 192.168.1.100

# 登录iscsi目标（在所有节点执行）
# iscsiadm -m node –login

# 验证共享磁盘（在所有节点执行）
# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sda 8:0 0 200G 0 disk
├─sda1 8:1 0 500M 0 part /boot
└─sda2 8:2 0 199.5G 0 part /
sdb 8:16 0 200G 0 disk
└─sdb1 8:17 0 200G 0 part
sdc 8:32 0 200G 0 disk
└─sdc1 8:33 0 200G 0 part
sdd 8:48 0 200G 0 disk
└─sdd1 8:49 0 200G 0 part
sde 8:64 0 500G 0 disk
└─sde1 8:65 0 500G 0 part
sdf 8:80 0 500G 0 disk
└─sdf1 8:81 0 500G 0 part
sdg 8:96 0 500G 0 disk
└─sdg1 8:97 0 500G 0 part

# 配置ASMLib（在所有节点执行）
# yum install -y kmod-oracleasm oracleasm-support oracleasm-lib

# 配置ASMLib（在所有节点执行）
# oracleasm configure -i
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets (‘[]’). Hitting without typing an
answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration:

done

# 启动ASMLib服务（在所有节点执行）
# systemctl enable oracleasm
# systemctl start oracleasm

# 标记ASM磁盘（在节点1执行）
# oracleasm createdisk OCRVOTE1 /dev/sdb1
# oracleasm createdisk OCRVOTE2 /dev/sdc1
# oracleasm createdisk OCRVOTE3 /dev/sdd1
# oracleasm createdisk DATADISK1 /dev/sde1
# oracleasm createdisk DATADISK2 /dev/sdf1
# oracleasm createdisk DATADISK3 /dev/sdg1
# oracleasm createdisk ARCHDISK1 /dev/sdh1
# oracleasm createdisk ARCHDISK2 /dev/sdi1
# oracleasm createdisk ARCHDISK3 /dev/sdj1

# 列出ASM磁盘（在所有节点执行）
# oracleasm listdisks
ARCHDISK1
ARCHDISK2
ARCHDISK3
DATADISK1
DATADISK2
DATADISK3
OCRVOTE1
OCRVOTE2
OCRVOTE3

# 创建Oracle安装所需的组（在所有节点执行）
# groupadd -g 54321 oinstall
# groupadd -g 54322 dba
# groupadd -g 54323 oper
# groupadd -g 54324 asmdba
# groupadd -g 54325 asmoper
# groupadd -g 54326 asmadmin
# groupadd -g 54327 racdba

# 创建Grid用户（在所有节点执行）
# useradd -u 54321 -g oinstall -G asmadmin,asmdba,asmoper,dba,racdba grid

# 创建Oracle用户（在所有节点执行）
# useradd -u 54322 -g oinstall -G dba,oper,asmdba,racdba oracle

# 设置密码（在所有节点执行）
# passwd grid
New password:
Retype new password:

# passwd oracle
New password:
Retype new password:

# 创建Oracle安装目录和数据目录（在所有节点执行）
# mkdir -p /oracle/app/grid/product/12.2.0/grid
# mkdir -p /oracle/app/oracle/product/12.2.0/db_1
# mkdir -p /oracle/app/oraInventory
# mkdir -p /oracle/backup

# 设置目录权限（在所有节点执行）
# chown -R grid:oinstall /oracle/app/grid
# chown -R oracle:oinstall /oracle/app/oracle
# chown -R grid:oinstall /oracle/app/oraInventory
# chmod -R 775 /oracle

# Oracle 12cR2 Grid Infrastructure Linux 64位安装包
# linuxx64_12201_grid_home.zip

# Oracle 12cR2 Database Linux 64位安装包
# linuxx64_12201_database.zip

# 下载完成后，将安装包上传到节点1的/backup目录
# mkdir -p /backup/oracle/12cR2

# 解压Grid安装包（在所有节点执行）
# unzip -o /backup/oracle/12cR2/linuxx64_12201_grid_home.zip -d /oracle/app/grid/product/12.2.0/grid

# 解压Database安装包（在所有节点执行）
# unzip -o /backup/oracle/12cR2/linuxx64_12201_database.zip -d /oracle/app/oracle/product/12.2.0/db_1

# 配置Grid用户环境变量（在所有节点执行）
# vi /home/grid/.bash_profile
# Oracle Grid Infrastructure Settings
ORACLE_BASE=/oracle/app/grid
ORACLE_HOME=/oracle/app/grid/product/12.2.0/grid
ORACLE_SID=+ASM1
PATH=$PATH:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
DISPLAY=:0.0

# 在节点2和节点3上修改ORACLE_SID
# 节点2：ORACLE_SID = +ASM2
# 节点3：ORACLE_SID = +ASM3

# 使环境变量生效（在所有节点执行）
# source /home/grid/.bash_profile

# 以Grid用户登录到节点1，启动Grid Infrastructure安装向导
$ cd /oracle/app/grid/product/12.2.0/grid
$ ./runInstaller

图形化安装步骤：
步骤1：配置安全更新 – 取消勾选”I wish to receive security updates via My Oracle Support” – 点击”Next”

步骤2：选择安装选项 – 选择”Configure Grid Infrastructure for a New Cluster” – 点击”Next”

步骤3：选择集群类型 – 选择”Advanced Cluster Configuration” – 点击”Next”

步骤4：指定集群名称和SCAN名称 –
Cluster Name: fgedudb-cluster
SCAN Name: fgedudb-scan.fgedu.net.cn
SCAN Port: 1521
点击”Next”

步骤5：添加集群节点 –
点击”Add”添加节点2和节点3
节点2：Node Name: fgedudb02, Virtual Host Name: fgedudb02-vip
节点3：Node Name: fgedudb03, Virtual Host Name: fgedudb03-vip
点击”Next”

步骤6：选择网络接口 –
Public Interface: 选择公共网络接口（192.168.1.0/24）
Private Interface: 选择私有网络接口（172.16.1.0/24）
点击”Next”

步骤7：选择存储选项 – 选择”Configure Oracle ASM” – 点击”Next”

步骤8：指定ASM磁盘组 –
磁盘组名称：OCRVOTE
冗余级别：Normal
选择磁盘：OCRVOTE1, OCRVOTE2, OCRVOTE3
点击”Next”

步骤9：指定ASM密码 –
选择”Use same passwords for these accounts”
输入密码：Grid123
点击”Next”（可能会提示密码不符合复杂度要求，点击”Yes”继续）

步骤10：指定故障转移和存储联系人 – 点击”Next”

步骤11：指定安装位置 –
Oracle Base: /oracle/app/grid
Software Location: /oracle/app/grid/product/12.2.0/grid
点击”Next”

步骤12：选择配置类型 – 点击”Next”

步骤13：执行先决条件检查 –
检查完成后，点击”Next”

步骤14：安装产品 –
点击”Finish”开始安装

步骤15：执行配置脚本 –
安装过程中会提示在所有节点执行脚本，以root用户执行：
# /oracle/app/oraInventory/orainstRoot.sh
# /oracle/app/grid/product/12.2.0/grid/root.sh
执行完成后，点击”OK”继续

步骤16：完成安装 –
安装完成后，点击”Close”

# 以Grid用户登录到节点1，启动ASM Configuration Assistant
$ asmca

图形化配置步骤：
步骤1：选择”Disk Groups” – 点击”Create”

步骤2：创建数据磁盘组 –
磁盘组名称：DGFGDATA01
冗余级别：Normal
选择磁盘：DATADISK1, DATADISK2, DATADISK3
点击”OK”

步骤3：创建归档磁盘组 –
磁盘组名称：DGFGARCH
冗余级别：Normal
选择磁盘：ARCHDISK1, ARCHDISK2, ARCHDISK3
点击”OK”

步骤4：完成配置 – 点击”Exit”

# 验证ASM磁盘组（在所有节点执行）
$ asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 199808 133144 66602 33271 0 Y OCRVOTE/
MOUNTED NORMAL N 512 4096 1048576 499520 332736 166506 83115 0 N DGFGDATA01/
MOUNTED NORMAL N 512 4096 1048576 199808 133144 66602 33271 0 N DGFGARCH/

# 配置Oracle用户环境变量（在所有节点执行）
# vi /home/oracle/.bash_profile
# Oracle Database Settings
ORACLE_BASE=/oracle/app/oracle
ORACLE_HOME=/oracle/app/oracle/product/12.2.0/db_1
ORACLE_SID=fgedudb1
PATH=$PATH:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
DISPLAY=:0.0

# 在节点2和节点3上修改ORACLE_SID
# 节点2：ORACLE_SID = fgedudb2
# 节点3：ORACLE_SID = fgedudb3

# 使环境变量生效（在所有节点执行）
$ source /home/oracle/.bash_profile

# 以Oracle用户登录到节点1，启动Oracle数据库安装向导
$ cd /oracle/app/oracle/product/12.2.0/db_1
$ ./runInstaller

图形化安装步骤：
步骤1：配置安全更新 – 取消勾选”I wish to receive security updates via My Oracle Support” – 点击”Next”

步骤2：选择安装选项 – 选择”Install database software only” – 点击”Next”

步骤3：选择数据库安装类型 – 选择”Real Application Clusters database installation” – 点击”Next”

步骤4：选择集群节点 – 选择所有节点（fgedudb01, fgedudb02, fgedudb03） – 点击”Next”

步骤5：选择产品语言 – 选择”Simplified Chinese”和”English” – 点击”Next”

步骤6：选择数据库版本 – 选择”Enterprise Edition” – 点击”Next”

步骤7：指定安装位置 –
Oracle Base: /oracle/app/oracle
Oracle Home: /oracle/app/oracle/product/12.2.0/db_1
点击”Next”

步骤8：指定数据库安装选项 – 点击”Next”

步骤9：执行先决条件检查 –
检查完成后，点击”Next”

步骤10：安装产品 –
点击”Finish”开始安装

步骤11：执行配置脚本 –
安装过程中会提示在所有节点执行脚本，以root用户执行：
# /oracle/app/oracle/product/12.2.0/db_1/root.sh
执行完成后，点击”OK”继续

步骤12：完成安装 –
安装完成后，点击”Close”

# 以Oracle用户登录到节点1，启动Database Configuration Assistant
$ dbca

图形化配置步骤：
步骤1：选择操作 – 选择”Create a Database” – 点击”Next”

步骤2：选择创建模式 – 选择”Advanced Mode” – 点击”Next”

步骤3：选择数据库类型 – 选择”Real Application Clusters (RAC) database” – 点击”Next”

步骤4：选择集群节点 – 选择所有节点（fgedudb01, fgedudb02, fgedudb03） – 点击”Next”

步骤5：选择配置类型 – 选择”General Purpose or Transaction Processing” – 点击”Next”

步骤6：指定数据库标识符 –
Global Database Name: fgedudb
SID Prefix: fgedudb
勾选”Create as Container database”
Pluggable database name: fgedupdb
点击”Next”

步骤7：指定配置选项 –
Memory: 选择”Use Automatic Memory Management”，设置为每个节点物理内存的70%
Character Sets: 选择”Use Unicode (AL32UTF8)”
Database Sample Schemas: 勾选”Create database with sample schemas”
点击”Next”

步骤8：指定管理选项 –
选择”Use Database Control for database management”
勾选”Enable Email Notification”（可选）
点击”Next”

步骤9：指定数据库存储选项 – 选择”Automatic Storage Management (ASM)” –
选择磁盘组：DGFGDATA01
点击”Next”

步骤10：指定快速恢复区 –
快速恢复区：DGFGARCH
快速恢复区大小：100GB
点击”Next”

步骤11：指定数据库方案密码 –
选择”Use the same password for all accounts”
输入密码：Oracle123
点击”Next”（可能会提示密码不符合复杂度要求，点击”Continue”继续）

步骤12：执行先决条件检查 –
检查完成后，点击”Next”

步骤13：创建数据库 –
点击”Finish”开始创建数据库

步骤14：完成创建 –
数据库创建完成后，点击”Close”

# 以Oracle用户执行Net Configuration Assistant（在节点1执行）
$ netca

# 选择”Listener Configuration” – 点击”Next”
# 选择”Reconfigure” – 点击”Next”
# 选择监听程序名称（LISTENER） – 点击”Next”
# 选择协议（TCP） – 点击”Next”
# 指定端口号（默认1521） – 点击”Next”
# 完成配置

# 验证监听程序状态（在所有节点执行）
$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 – Production on 03-APR-2026 04:00:00

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fgedudb01-vip.fgedu.net.cn)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 – Production
Start Date 03-APR-2026 03:00:00
Uptime 0 days 1 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/grid/product/12.2.0/grid/network/admin/listener.ora
Listener Log File /oracle/app/grid/diag/tnslsnr/fgedudb01/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fgedudb01-vip.fgedu.net.cn)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fgedudb01-vip.fgedu.net.cn)(PORT=7077)))
Services Summary…
Service “fgedudb” has 3 instance(s).
Instance “fgedudb1”, status READY, has 1 handler(s) for this service…
Instance “fgedudb2”, status READY, has 1 handler(s) for this service…
Instance “fgedudb3”, status READY, has 1 handler(s) for this service…
Service “fgedudbXDB” has 3 instance(s).
Instance “fgedudb1”, status READY, has 1 handler(s) for this service…
Instance “fgedudb2”, status READY, has 1 handler(s) for this service…
Instance “fgedudb3”, status READY, has 1 handler(s) for this service…
Service “fgedupdb” has 3 instance(s).
Instance “fgedudb1”, status READY, has 1 handler(s) for this service…
Instance “fgedudb2”, status READY, has 1 handler(s) for this service…
Instance “fgedudb3”, status READY, has 1 handler(s) for this service…
The command completed successfully

# 验证SCAN监听状态（在任意节点执行）
$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node fgedudb01
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node fgedudb02
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node fgedudb03

# 连接到CDB（在任意节点执行）
$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 3 04:00:00 2026

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics and Real Application Testing options

SQL>

# 检查PDB状态
SQL> SHOW pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 FGEDUPDB READ WRITE NO

# 连接到PDB
SQL> ALTER SESSION SET container = fgedupdb;
Session altered.

# 连接到CDB
SQL> ALTER SESSION SET container = CDB$ROOT;
Session altered.

# 配置PDB自动启动
SQL> ALTER PLUGGABLE DATABASE fgedupdb SAVE STATE;
Pluggable database altered.

# 验证配置
SQL> SELECT con_name, state FROM dba_pdb_saved_states;

CON_NAME STATE
—————————— ————–
FGEDUPDB OPEN

# 检查当前归档模式
SQL> SELECT log_mode FROM v$database;

LOG_MODE
————
NOARCHIVELOG

# 关闭数据库实例
SQL> SHUTDOWN IMMEDIATE;

# 启动数据库到mount状态
SQL> STARTUP MOUNT;

# 启用归档模式
SQL> ALTER DATABASE ARCHIVELOG;

# 打开数据库
SQL> ALTER DATABASE OPEN;

# 验证归档模式
SQL> SELECT log_mode FROM v$database;

LOG_MODE
————
ARCHIVELOG

# 查看当前密码策略
SQL> SELECT * FROM dba_profiles WHERE resource_name = ‘PASSWORD_LIFE_TIME’;

PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
—————————— ——————————– ————- ——————————
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180

# 修改密码有效期为无限
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.

# 验证修改
SQL> SELECT * FROM dba_profiles WHERE resource_name = ‘PASSWORD_LIFE_TIME’;

PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
—————————— ——————————– ————- ——————————
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED

# 查看当前审计状态
SQL> SHOW PARAMETER audit_trail;

NAME TYPE VALUE
———————————— ———– ——————————
audit_trail string DB

# 关闭审计功能
SQL> ALTER SYSTEM SET audit_trail = NONE SCOPE = SPFILE;
System altered.

# 重启数据库使配置生效
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

# 查看当前内存配置
SQL> SHOW PARAMETER memory;

# 调整SGA和PGA大小
SQL> ALTER SYSTEM SET sga_target = 48G SCOPE = SPFILE;
SQL> ALTER SYSTEM SET pga_aggregate_target = 16G SCOPE = SPFILE;

# 重启数据库使配置生效
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

# 连接到RMAN（在任意节点执行）
$ rman target /

Recovery Manager: Release 12.2.0.1.0 – Production on Wed Apr 3 04:00:00 2026

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

connected to target database: FGEDUDB (DBID=1234567890)

RMAN>

# 配置控制文件自动备份
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

# 配置备份保留策略
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

# 执行全库备份到ASM归档磁盘组
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

# 验证集群状态（在任意节点执行）
$ crsctl status cluster -all

CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
Node fgedudb01:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
CRS-4532: Cluster Synchronization Services is online
CRS-4534: OHASD is online
CRS-4535: D ataBase resource is online
Node fgedudb02:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
CRS-4532: Cluster Synchronization Services is online
CRS-4534: OHASD is online
CRS-4535: D ataBase resource is online
Node fgedudb03:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
CRS-4532: Cluster Synchronization Services is online
CRS-4534: OHASD is online
CRS-4535: D ataBase resource is online

# 验证ASM实例状态（在所有节点执行）
$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 3 04:00:00 2026

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> SELECT instance_name, status FROM v$instance;

INSTANCE_NAME STATUS
—————- ————
+ASM1 STARTED

# 验证数据库实例状态（在所有节点执行）
$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 3 04:00:00 2026

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics and Real Application Testing options

SQL> SELECT instance_name, status FROM v$instance;

INSTANCE_NAME STATUS
—————- ————
fgedudb1 OPEN

# 使用sqlplus通过SCAN连接测试
$ sqlplus system/Oracle123@fgedudb-scan.fgedu.net.cn:1521/fgedudb

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 3 04:00:00 2026

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics and Real Application Testing options

SQL>

# 使用sqlplus通过SCAN连接PDB测试
$ sqlplus system/Oracle123@fgedudb-scan.fgedu.net.cn:1521/fgedupdb

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 3 04:00:00 2026

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics and Real Application Testing options

SQL>

# 验证表空间（存储在ASM中）
SQL> SELECT tablespace_name, status FROM dba_tablespaces;

# 访问Enterprise Manager
https://fgedudb01:5500/em
# 使用sys用户和密码登录