在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 11GR2 单机 ASM（231017）过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://w
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 11GR2 单机 ASM（231017）过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
参考：
在 Oracle Linux 8 （openEuler 22.03 LTS SP3）安装 11GR2 单机 ASM 数据库，需要安装 19.14 版本之后的 Grid 软件补丁，然后再安装 11GR2 数据：
✨ 偷懒可以直接下载本文安装包合集：openEuler 22.03 LTS SP3（华为欧拉）一键安装 Oracle 11GR2 单机 ASM（231017）安装包合集（包含补丁！！！）
++==📢注意：Oracle 11GR2 单机 ASM 安装主机名不能有大写字符，否则安装失败！==++
1# 主机版本2[root@openeuler01 soft]# cat /etc/openeuler-release 3openEuler release 22.03 (LTS-SP3)45# 网络信息6[root@openeuler01 soft]# ip a72: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 10008 link/ether 00:0c:29:51:f8:ca brd ff:ff:ff:ff:ff:ff9 inet 192.168.6.130/24 brd 192.168.6.255 scope global noprefixroute ens3310 valid_lft forever preferred_lft forever11 inet6 fe80::6bae:9840:87e5:b777/64 scope link noprefixroute 12 valid_lft forever preferred_lft forever1314# 挂载本地 ISO 镜像15[root@openeuler01 soft]# mount | grep iso | grep -v "/run/media"16/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)17[root@openeuler01 soft]# df -h|grep /mnt18/dev/sr0 18G 18G 0 100% /mnt1920# starwind 共享磁盘挂载（有存储就不需要使用 starwind，直接存储上划盘挂载就可）21yum install -y iscsi-initiator-utils*22systemctl start iscsid.service23systemctl enable iscsid.service24iscsiadm -m discovery -t st -p 192.168.6.18825## 挂载 ASM 磁盘26iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.6.188-lucifer -p 192.168.6.188 -l27## 配置开机自动挂载28iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.6.188-lucifer -p 192.168.6.188 --op update -n node.startup -v automatic2930[root@openeuler01 ~]# lsblk 31NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS32sda 8:0 0 100G 0 disk 33├─sda1 8:1 0 1G 0 part /boot34└─sda2 8:2 0 99G 0 part 35 ├─openeuler-root 253:0 0 91G 0 lvm /36 └─openeuler-swap 253:1 0 8G 0 lvm [SWAP]37sdb 8:16 0 10G 0 disk 38sdc 8:32 0 50G 0 disk 39sr0 11:0 1 17.1G 0 rom /mnt4041# 安装包存放在 /soft 目录下42[root@openeuler01 ~]# cd /soft/43[root@openeuler01 soft]# ll44-rwx------ 1 root root 2889184573 2月 26 13:37 LINUX.X64_193000_grid_home.zip45-rwxr-xr-x 1 root root 192199 2月 26 13:35 OracleShellInstall46-rwx------ 1 root root 1395582860 2月 26 13:36 p13390677_112040_Linux-x86-64_1of7.zip47-rwx------ 1 root root 1151304589 2月 26 13:36 p13390677_112040_Linux-x86-64_2of7.zip48-rwx------ 1 root root 8684 2月 26 13:36 p33991024_11204220118_Generic.zip49-rwx------ 1 root root 562188912 2月 26 13:36 p35574075_112040_Linux-x86-64.zip50-rwx------ 1 root root 86183099 2月 26 13:36 p35685663_112040_Linux-x86-64.zip51-rwx------ 1 root root 3153297056 2月 26 13:37 p35940989_190000_Linux-x86-64.zip52-rwx------ 1 root root 128433424 2月 26 13:36 p6880880_112000_Linux-x86-64.zip53-rwx------ 1 root root 127774864 2月 26 13:36 p6880880_190000_Linux-x86-64.zip54-rwxr-xr-x 1 root root 321590 2月 26 13:31 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数（安装过程若失败，脚本支持重复执行安装）：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -n openeuler `# hostname prefix`\3-gp oracle `# grid password`\4-op oracle `# oracle password`\5-lf ens33 `# local ip ifname`\6-dd /dev/sdc `# rac data asm disk`\7-o lucifer `# dbname`\8-ds AL32UTF8 `# database character`\9-ns AL16UTF16 `# national character`\10-redo 100 `# redo size`\11-dp oracle `# sys/system password`\12-gpa 35940989 `# grid PSU/RU`\13-opa 35574075 `# db PSU/RU`\14-jpa 35685663 `# OJVM PSU/RU`\15-opd Y `# optimize db`\16-giv 19 `# grid version`默认使用专业版脚本。脚本下载：ora100.com/shell-install
选择需要安装的模式以及版本，即可开始安装：
1 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██2 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██3 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██4░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██5░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██6░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██7 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███8 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 910请选择安装模式 [单机(si)/单机ASM(sa)/集群(rac)] : sa1112数据库安装模式: standalone 1314请选择数据库版本 [11/12/19/21] : 111516数据库版本: 11 1718OracleShellInstall 开始安装(安装过程可查看日志：/soft/print_ora_install_20240329150802.log） 19正在检查操作系统是否符合安装条件......已完成 (耗时: 0 秒)20正在去除密码复杂度配置......已完成 (耗时: 0 秒)21正在配置 YUM 源......已完成 (耗时: 1 秒)22正在获取操作系统信息......已完成 (耗时: 1 秒)23正在配置 Swap......已完成 (耗时: 0 秒)24正在配置防火墙......已完成 (耗时: 3 秒)25正在配置 selinux......已完成 (耗时: 1 秒)26正在配置 nsyctl......已完成 (耗时: 1 秒)27正在安装依赖包......已完成 (耗时: 281 秒)28正在配置主机名和 /etc/hosts......已完成 (耗时: 1 秒)29正在创建用户和组......已完成 (耗时: 2 秒)30正在创建安装目录......已完成 (耗时: 1 秒)31正在配置 Avahi-daemon 服务......已完成 (耗时: 5 秒)32正在配置透明大页 && NUMA && 磁盘 IO 调度器......已完成 (耗时: 1 秒)33正在配置操作系统参数 sysctl......已完成 (耗时: 1 秒)34正在配置 RemoveIPC......已完成 (耗时: 2 秒)35正在配置用户限制 limit......已完成 (耗时: 1 秒)36正在配置 shm 目录......已完成 (耗时: 0 秒)37正在安装 rlwrap 插件......已完成 (耗时: 16 秒)38正在配置用户环境变量......已完成 (耗时: 1 秒)39正在解压 Grid 安装包以及补丁......已完成 (耗时: 185 秒)40正在解压 Oracle 安装包以及补丁......已完成 (耗时: 82 秒)41正在安装 Grid 软件以及补丁......已完成 (耗时: 1690 秒)42正在安装 Oracle 软件以及补丁......已完成 (耗时: 1419 秒)43正在创建数据库......已完成 (耗时: 955 秒)44正在优化数据库......已完成 (耗时: 27 秒)4546恭喜！Oracle 单机 ASM 安装成功 (耗时: 4684 秒)，现在是否重启主机：[Y/N] Y4748正在重启主机......默认使用专业版脚本。脚本下载：ora100.com/shell-install
1[root@openeuler:/root]$ cat /soft/print_ora_install_20240329150802.log 23#==============================================================# 4配置本地 YUM 源 5#==============================================================# 67[openEuler]8name=openEuler9baseurl=file:////mnt10enabled=111gpgcheck=112gpgkey=file:////mnt/RPM-GPG-KEY-openEuler1314#==============================================================# 15获取 ASM 磁盘 UUID && 格式化磁盘头 16#==============================================================# 17格式化 DATA 磁盘：/dev/sdc 1819DATA磁盘组的磁盘UUID： 2f218dae15b551c5d 2021#==============================================================# 22打印系统信息 23#==============================================================# 2425服务器时间: 2627Fri Mar 29 03:08:08 PM CST 20242829操作系统版本: 3031NAME="openEuler"32VERSION="22.03 (LTS-SP3)"33ID="openEuler"34VERSION_ID="22.03"35PRETTY_NAME="openEuler 22.03 (LTS-SP3)"36ANSI_COLOR="0;31"373839内核信息: 4041Linux version 5.10.0-182.0.0.95.oe2203sp3.x86_64 (root@dc-64g.compass-ci) (gcc_old (GCC) 10.3.1, GNU ld (GNU Binutils) 2.37) #1 SMP Sat Dec 30 13:10:36 CST 20234243服务器属性: 4445vmware4647cpu信息: 4849$2型号名称 ：Intel(R) Xeon(R) CPU E5-2630 v2 @ 2.60GHz 50$2物理 CPU 个数 ：8 51$2每个物理 CPU 的逻辑核数 ：1 52$2系统的 CPU 线程数 ：8 5354内存信息: 5556 total used free shared buff/cache available57Mem: 7433 525 121 8 7103 690858Swap: 8187 0 818759 total used free shared buff/cache available60Mem: 7.3Gi 525Mi 121Mi 8.7Mi 6.9Gi 6.7Gi61Swap: 8.0Gi 268Ki 8.0Gi6263挂载信息: 6465/dev/mapper/openeuler-root / ext4 defaults 1 166UUID=07e6a80f-f2f4-42f8-a1ad-df05bd354960 /boot ext4 defaults 1 267/dev/mapper/openeuler-swap none swap defaults 0 06869目录信息: 7071Filesystem Size Used Avail Use% Mounted on72devtmpfs 4.0M 0 4.0M 0% /dev73tmpfs 3.7G 0 3.7G 0% /dev/shm74tmpfs 1.5G 8.8M 1.5G 1% /run75tmpfs 4.0M 0 4.0M 0% /sys/fs/cgroup76/dev/mapper/openeuler-root 90G 11G 74G 13% /77tmpfs 3.7G 0 3.7G 0% /tmp78/dev/sda1 974M 174M 733M 20% /boot79/dev/sr0 18G 18G 0 100% /mnt8081#==============================================================# 82禁用防火墙 83#==============================================================# 8485○ firewalld.service - firewalld - dynamic firewall daemon86 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)87 Active: inactive (dead)88 Docs: man:firewalld(1)8990Mar 29 14:49:36 openEuler01 systemd[1]: Starting firewalld - dynamic firewall daemon...91Mar 29 14:49:38 openEuler01 systemd[1]: Started firewalld - dynamic firewall daemon.92Mar 29 15:08:10 openEuler01 systemd[1]: Stopping firewalld - dynamic firewall daemon...93Mar 29 15:08:11 openEuler01 systemd[1]: firewalld.service: Deactivated successfully.94Mar 29 15:08:11 openEuler01 systemd[1]: Stopped firewalld - dynamic firewall daemon.9596#==============================================================# 97禁用 SELinux 98#==============================================================# 99100SELinux status: enabled101SELinuxfs mount: /sys/fs/selinux102SELinux root directory: /etc/selinux103Loaded policy name: targeted104Current mode: permissive105Mode from config file: disabled106Policy MLS status: enabled107Policy deny_unknown status: allowed108Memory protection checking: actual (secure)109Max kernel policy version: 33110111#==============================================================# 112配置 nsysctl.conf 113#==============================================================# 114115NOZEROCONF=yes116117#==============================================================# 118YUM 静默安装依赖包 119#==============================================================# 120121bc-1.07.1-12.oe2203sp3.x86_64122binutils-2.37-24.oe2203sp3.x86_64123package compat-libcap1 is not installed124gcc-10.3.1-49.oe2203sp3.x86_64125gcc-c++-10.3.1-49.oe2203sp3.x86_64126package elfutils-libelf is not installed127package elfutils-libelf-devel is not installed128glibc-2.34-143.oe2203sp3.x86_64129glibc-devel-2.34-143.oe2203sp3.x86_64130libaio-0.3.113-9.oe2203sp3.x86_64131libaio-devel-0.3.113-9.oe2203sp3.x86_64132libgcc-10.3.1-49.oe2203sp3.x86_64133libstdc++-10.3.1-49.oe2203sp3.x86_64134libstdc++-devel-10.3.1-49.oe2203sp3.x86_64135libxcb-1.15-1.oe2203sp3.x86_64136libX11-1.7.2-8.oe2203sp3.x86_64137libXau-1.0.10-1.oe2203sp3.x86_64138libXi-1.8-2.oe2203sp3.x86_64139libXrender-0.9.10-12.oe2203sp3.x86_64140make-4.3-4.oe2203sp3.x86_64141net-tools-2.10-3.oe2203sp3.x86_64142smartmontools-7.2-2.oe2203sp3.x86_64143sysstat-12.5.4-9.oe2203sp3.x86_64144e2fsprogs-1.46.4-24.oe2203sp3.x86_64145package e2fsprogs-libs is not installed146unzip-6.0-50.oe2203sp3.x86_64147openssh-clients-8.8p1-23.oe2203sp3.x86_64148readline-8.1-3.oe2203sp3.x86_64149readline-devel-8.1-3.oe2203sp3.x86_64150psmisc-23.5-2.oe2203sp3.x86_64151ksh-2020.0.0-10.oe2203sp3.x86_64152nfs-utils-2.5.4-15.oe2203sp3.x86_64153tar-1.34-5.oe2203sp3.x86_64154package device-mapper-multipath is not installed155avahi-0.8-18.oe2203sp3.x86_64156ntp-4.2.8p15-13.oe2203sp3.x86_64157chrony-4.1-6.oe2203sp3.x86_64158libXtst-1.2.4-1.oe2203sp3.x86_64159libXrender-devel-0.9.10-12.oe2203sp3.x86_64160fontconfig-devel-2.13.94-3.oe2203sp3.x86_64161policycoreutils-3.3-8.oe2203sp3.x86_64162package policycoreutils-python is not installed163libcap-devel-2.61-6.oe2203sp3.x86_64164xorg-x11-utils-7.5-31.oe2203sp3.x86_64165xorg-x11-xauth-1.1.2-1.oe2203sp3.x86_64166glibc-compat-2.17-2.34-143.oe2203sp3.x86_64167elfutils-0.185-18.oe2203sp3.x86_64168elfutils-devel-0.185-18.oe2203sp3.x86_64169libnsl2-devel-2.0.0-5.oe2203sp3.x86_64170package librdmacm is not installed171libnsl-2.34-143.oe2203sp3.x86_64172package libibverbs is not installed173package compat-openssl10 is not installed174policycoreutils-python-utils-3.3-8.oe2203sp3.noarch175176#==============================================================# 177配置主机名 178#==============================================================# 179180 Static hostname: openeuler181 Icon name: computer-vm182 Chassis: vm183 Machine ID: 141e08aec07949dbb1be4d025526e6de184 Boot ID: 07e7a034d0d248988b39171ec1f10f2c185 Virtualization: vmware186Operating System: openEuler 22.03 (LTS-SP3)187 Kernel: Linux 5.10.0-182.0.0.95.oe2203sp3.x86_64188 Architecture: x86-64189 Hardware Vendor: VMware, Inc.190 Hardware Model: VMware Virtual Platform191192#==============================================================# 193配置 /etc/hosts 文件 194#==============================================================# 195196197#==============================================================# 198创建用户和组 199#==============================================================# 200201127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4202::1 localhost localhost.localdomain localhost6 localhost6.localdomain6203192.168.6.130 openeuler204oracle 用户： 205206uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba),54328(asmoper),54329(asmadmin)207208grid 用户： 209210uid=11012(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba),54328(asmoper),54329(asmadmin)211212213#==============================================================# 214配置 Avahi-daemon 服务 215#==============================================================# 216217○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack218 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)219 Active: inactive (dead)220TriggeredBy: ○ avahi-daemon.socket221222#==============================================================# 223配置透明大页 && NUMA && 磁盘 IO 调度器 224#==============================================================# 225226args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"227-resume=/dev/mapper/openeuler-swap228-args="ro229args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"230-rhgb231-crashkernel=512M232233#==============================================================# 234配置 sysctl.conf 235#==============================================================# 236237kernel.sysrq = 0238net.ipv4.ip_forward = 0239net.ipv4.conf.all.send_redirects = 0240net.ipv4.conf.default.send_redirects = 0241net.ipv4.conf.all.accept_source_route = 0242net.ipv4.conf.default.accept_source_route = 0243net.ipv4.conf.all.accept_redirects = 0244net.ipv4.conf.default.accept_redirects = 0245net.ipv4.conf.all.secure_redirects = 0246net.ipv4.conf.default.secure_redirects = 0247net.ipv4.icmp_echo_ignore_broadcasts = 1248net.ipv4.icmp_ignore_bogus_error_responses = 1249net.ipv4.conf.all.rp_filter = 1250net.ipv4.conf.default.rp_filter = 1251net.ipv4.tcp_syncookies = 1252kernel.dmesg_restrict = 1253net.ipv6.conf.all.accept_redirects = 0254net.ipv6.conf.default.accept_redirects = 0255fs.aio-max-nr = 1048576256fs.file-max = 6815744257kernel.shmall = 2097152258kernel.shmmax = 7795097599259kernel.shmmni = 4096260kernel.sem = 250 32000 100 128261net.ipv4.ip_local_port_range = 9000 65500262net.core.rmem_default = 262144263net.core.rmem_max = 4194304264net.core.wmem_default = 262144265net.core.wmem_max = 1048576266vm.min_free_kbytes = 30449267net.ipv4.conf.ens33.rp_filter = 1268vm.swappiness = 10269kernel.panic_on_oops = 1270kernel.randomize_va_space = 2271kernel.numa_balancing = 0272273#==============================================================# 274配置 RemoveIPC 275#==============================================================# 276277[Login]278RemoveIPC=no279280#==============================================================# 281配置 /etc/security/limits.conf 和 /etc/pam.d/login 282#==============================================================# 283284查看 /etc/security/limits.conf： 285286oracle soft nofile 1024287oracle hard nofile 65536288oracle soft stack 10240289oracle hard stack 32768290oracle soft nproc 2047291oracle hard nproc 16384292oracle hard memlock unlimited293oracle soft memlock unlimited294grid soft nofile 1024295grid hard nofile 65536296grid soft stack 10240297grid hard stack 32768298grid soft nproc 2047299grid hard nproc 16384300301查看 /etc/pam.d/login 文件： 302303auth substack system-auth304auth include postlogin305account required pam_nologin.so306account include system-auth307password include system-auth308session required pam_selinux.so close309session required pam_loginuid.so310session required pam_selinux.so open311session required pam_namespace.so312session optional pam_keyinit.so force revoke313session include system-auth314session include postlogin315-session optional pam_ck_connector.so316session required pam_limits.so317session required /lib64/security/pam_limits.so318319#==============================================================# 320配置 /dev/shm 321#==============================================================# 322323/dev/mapper/openeuler-root / ext4 defaults 1 1324UUID=07e6a80f-f2f4-42f8-a1ad-df05bd354960 /boot ext4 defaults 1 2325/dev/mapper/openeuler-swap none swap defaults 0 0326tmpfs /dev/shm tmpfs size=7612400k 0 0327328#==============================================================# 329安装 rlwrap 插件 330#==============================================================# 331332成功安装 rlwrap： rlwrap 0.44 333334#==============================================================# 335Root 用户环境变量 336#==============================================================# 337338if [ -f ~/.bashrc ]; then339 . ~/.bashrc340fi341PATH=$PATH:$HOME/bin342export PATH343alias so='su - oracle'344export PS1="[`whoami`@`hostname`:"'$PWD]$ '345alias sg='su - grid'346alias crsctl='/u01/app/19.3.0/grid/bin/crsctl'347alias srvctl='/u01/app/19.3.0/grid/bin/srvctl'348349#==============================================================# 350Oracle 用户环境变量，实例名：lucifer 351#==============================================================# 352353[ -f ~/.bashrc ] && . ~/.bashrc354umask 022355export TMP=/tmp356export TMPDIR=$TMP357export NLS_LANG=AMERICAN_AMERICA.AL32UTF8358export ORACLE_BASE=/u01/app/oracle359export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db360export ORACLE_TERM=xterm361export TNS_ADMIN=$ORACLE_HOME/network/admin362export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib363export ORACLE_SID=lucifer364export PATH=/usr/sbin:$PATH365export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH366export PERL5LIB=$ORACLE_HOME/perl/lib367alias sas='sqlplus / as sysdba'368alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'369alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'370alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'371export PS1="[`whoami`@`hostname`:"'$PWD]$ '372export CV_ASSUME_DISTID=OL7373alias sqlplus='rlwrap sqlplus'374alias rman='rlwrap rman'375alias adrci='rlwrap adrci'376377#==============================================================# 378Grid 用户环境变量 379#==============================================================# 380381[ -f ~/.bashrc ] && . ~/.bashrc382umask 022383export TMP=/tmp384export TMPDIR=$TMP385export NLS_LANG=AMERICAN_AMERICA.AL32UTF8386export ORACLE_BASE=/u01/app/grid387export ORACLE_HOME=/u01/app/19.3.0/grid388export ORACLE_TERM=xterm389export TNS_ADMIN=$ORACLE_HOME/network/admin390export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib391export ORACLE_SID=+ASM392export PATH=/usr/sbin:$PATH393export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH394alias sas='sqlplus / as sysasm'395export PS1="[`whoami`@`hostname`:"'$PWD]$ '396export CV_ASSUME_DISTID=OL7397alias sqlplus='rlwrap sqlplus'398alias asmcmd='rlwrap asmcmd'399alias adrci='rlwrap adrci'400401#==============================================================# 402配置 multipath 多路径 403#==============================================================# 404405406#==============================================================# 407配置 UDEV 绑盘 408#==============================================================# 409410KERNEL=="dm-*",ENV{DM_UUID}=="mpath-2f218dae15b551c5d",SYMLINK+="asm_data_1",OWNER="grid",GROUP="asmadmin",MODE="0660"411mpatha (2e87e4f535c397171) dm-2 ROCKET,IMAGEFILE412size=10G features='0' hwhandler='0' wp=rw413`-+- policy='service-time 0' prio=1 status=active414 `- 3:0:0:0 sdb 8:16 active ready running415asm_data_1 (2f218dae15b551c5d) dm-3 ROCKET,IMAGEFILE416size=50G features='0' hwhandler='0' wp=rw417`-+- policy='service-time 0' prio=1 status=active418 `- 3:0:0:1 sdc 8:32 active ready running419UDEV 配置完成! 420/dev/asm_data_1421422#==============================================================# 423静默解压缩 Grid 软件包 424#==============================================================# 425426正在静默解压缩 Grid 软件包，请稍等： 427428静默解压 Grid 软件安装包： /soft/LINUX.X64_193000_grid_home.zip 429430静默解压 OPatch 软件补丁包： /soft/p6880880_190000_Linux-x86-64.zip 431432静默解压 Grid 软件补丁包： /soft/p35940989_190000_Linux-x86-64.zip 433434#==============================================================# 435静默解压 Oracle 软件包 436#==============================================================# 437438正在静默解压缩 Oracle 软件包，请稍等： 439静默解压 Oracle 软件安装包： /soft/p13390677_112040_Linux-x86-64_1of7.zip,/soft/p13390677_112040_Linux-x86-64_2of7.zip 440441静默解压 Oracle 软件补丁包： /soft/p35574075_112040_Linux-x86-64.zip 442443静默解压 Oracle 软件补丁包：/soft/p33991024_11204220118_Generic.zip 444445静默解压 OJVM 软件补丁包： /soft/p35685663_112040_Linux-x86-64.zip 446447#==============================================================# 448Grid 安装静默文件 449#==============================================================# 450451INVENTORY_LOCATION=/u01/app/oraInventory452oracle.install.option=HA_CONFIG453ORACLE_BASE=/u01/app/grid454oracle.install.asm.OSDBA=asmdba455oracle.install.asm.OSOPER=asmoper456oracle.install.asm.OSASM=asmadmin457oracle.install.crs.config.gpnp.configureGNS=false458oracle.install.crs.config.useIPMI=false459oracle.install.asm.SYSASMPassword=oracle460oracle.install.asm.diskGroup.name=DATA461oracle.install.asm.diskGroup.redundancy=EXTERNAL462oracle.install.asm.diskGroup.disks=/dev/asm_data_1463oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm*464oracle.install.asm.monitorPassword=oracle465oracle.install.crs.config.ClusterConfiguration=STANDALONE466oracle.install.crs.config.configureAsExtendedCluster=false467oracle.install.crs.configureGIMR=false468oracle.install.asm.storageOption=ASM469oracle.install.asm.diskGroup.AUSize=4470oracle.install.asm.configureAFD=false471oracle.install.crs.config.ignoreDownNodes=false472oracle.install.config.managementOption=NONE473oracle.install.crs.rootconfig.executeRootScript=false474oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0475oracle.install.crs.config.scanType=LOCAL_SCAN476477#==============================================================# 478静默安装 Grid 软件 479#==============================================================# 480481Preparing the home to patch...482Applying the patch /soft/35940989...483Successfully applied the patch.484The log can be found at: /tmp/GridSetupActions2024-03-29_03-18-02PM/installerPatchActions_2024-03-29_03-18-02PM.log485Launching Oracle Grid Infrastructure Setup Wizard...486487[WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.488 CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].489 ACTION: Provide a password that conforms to the Oracle recommended standards.490[WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.491 CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].492 ACTION: Provide a password that conforms to the Oracle recommended standards.493The response file for this session can be found at:494 /u01/app/19.3.0/grid/install/response/grid_2024-03-29_03-18-02PM.rsp495496You can find the log of this install session at:497 /tmp/GridSetupActions2024-03-29_03-18-02PM/gridSetupActions2024-03-29_03-18-02PM.log498499As a root user, execute the following script(s):500 1. /u01/app/oraInventory/orainstRoot.sh501 2. /u01/app/19.3.0/grid/root.sh502503Execute /u01/app/19.3.0/grid/root.sh on the following nodes: 504[openeuler]505506507508Successfully Setup Software.509As install user, execute the following command to complete the configuration.510 /u01/app/19.3.0/grid/gridSetup.sh -executeConfigTools -responseFile /soft/grid.rsp [-silent]511512513Moved the install session logs to:514 /u01/app/oraInventory/logs/GridSetupActions2024-03-29_03-18-02PM515516#==============================================================# 517执行 root 脚本 518#==============================================================# 519520Changing permissions of /u01/app/oraInventory.521Adding read,write permissions for group.522Removing read,write,execute permissions for world.523524Changing groupname of /u01/app/oraInventory to oinstall.525The execution of the script is complete.526Check /u01/app/19.3.0/grid/install/root_openeuler_2024-03-29_15-42-53-525578127.log for the output of root script527528#==============================================================# 529Grid 软件版本 530#==============================================================# 531532533SQL*Plus: Release 19.0.0.0.0 - Production534Version 19.22.0.0.0535536537#==============================================================# 538Grid 补丁信息 539#==============================================================# 54054136115038;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36115038)54235967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)54335956421;ACFS RELEASE UPDATE 19.22.0.0.0 (35956421)54435943157;Database Release Update : 19.22.0.0.240116 (35943157)54533575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)546547OPatch succeeded.548549550#==============================================================# 551Grid 资源检查 552#==============================================================# 553554--------------------------------------------------------------------------------555Name Target State Server State details 556--------------------------------------------------------------------------------557Local Resources558--------------------------------------------------------------------------------559ora.DATA.dg560 ONLINE ONLINE openeuler STABLE561ora.LISTENER.lsnr562 ONLINE ONLINE openeuler STABLE563ora.asm564 ONLINE ONLINE openeuler Started,STABLE565ora.ons566 OFFLINE OFFLINE openeuler STABLE567--------------------------------------------------------------------------------568Cluster Resources569--------------------------------------------------------------------------------570ora.cssd571 1 ONLINE ONLINE openeuler STABLE572ora.diskmon573 1 OFFLINE OFFLINE STABLE574ora.evmd575 1 ONLINE ONLINE openeuler STABLE576--------------------------------------------------------------------------------577578579#==============================================================# 580Oracle 安装静默文件 581#==============================================================# 582583oracle.install.option=INSTALL_DB_SWONLY584UNIX_GROUP_NAME=oinstall585INVENTORY_LOCATION=/u01/app/oraInventory586ORACLE_BASE=/u01/app/oracle587oracle.install.db.InstallEdition=EE588oracle.install.db.DBA_GROUP=dba589oracle.install.db.OPER_GROUP=oper590oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0591SELECTED_LANGUAGES=en,zh_CN592ORACLE_HOME=/u01/app/oracle/product/11.2.0/db593DECLINE_SECURITY_UPDATES=true594oracle.installer.autoupdates.option=SKIP_UPDATES595596#==============================================================# 597静默安装数据库软件 598#==============================================================# 599600Starting Oracle Universal Installer...601602Checking Temp space: must be greater than 120 MB. Actual 3716 MB Passed603Checking swap space: must be greater than 150 MB. Actual 8175 MB Passed604Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-03-29_03-46-17PM. Please wait ...You can find the log of this install session at:605 /u01/app/oraInventory/logs/installActions2024-03-29_03-46-17PM.log606607Prepare in progress.608.................................................. 9% Done.609610Prepare successful.611612Copy files in progress.613.................................................. 14% Done.614.................................................. 20% Done.615.................................................. 26% Done.616.................................................. 31% Done.617.................................................. 36% Done.618.................................................. 41% Done.619.................................................. 47% Done.620.................................................. 52% Done.621.................................................. 57% Done.622.................................................. 63% Done.623.................................................. 68% Done.624.................................................. 73% Done.625.................................................. 78% Done.626.................................................. 83% Done.627..............................628Copy files successful.629630Link binaries in progress.631..........632Link binaries successful.633634Setup files in progress.635.................................................. 88% Done.636.................................................. 94% Done.637638Setup files successful.639The installation of Oracle Database 11g was successful.640Please check '/u01/app/oraInventory/logs/silentInstall2024-03-29_03-46-17PM.log' for more details.641642Execute Root Scripts in progress.643644As a root user, execute the following script(s):645 1. /u01/app/oracle/product/11.2.0/db/root.sh646647648.................................................. 100% Done.649650Execute Root Scripts successful.651Successfully Setup Software.652653#==============================================================# 654执行 root 脚本 655#==============================================================# 656657Changing permissions of /u01/app/oraInventory.658Adding read,write permissions for group.659Removing read,write,execute permissions for world.660661Changing groupname of /u01/app/oraInventory to oinstall.662The execution of the script is complete.663Check /u01/app/oracle/product/11.2.0/db/install/root_openeuler_2024-03-29_15-50-27.log for the output of root script664665#==============================================================# 666Oracle 软件安装补丁 667#==============================================================# 668669Oracle Interim Patch Installer version 11.2.0.3.44670Copyright (c) 2024, Oracle Corporation. All rights reserved.671672PREREQ session673674Oracle Home : /u01/app/oracle/product/11.2.0/db675Central Inventory : /u01/app/oraInventory676 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc677OPatch version : 11.2.0.3.44678OUI version : 11.2.0.4.0679Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_15-50-32PM_1.log680681Invoking prereq "checkconflictagainstohwithdetail"682683Prereq "checkConflictAgainstOHWithDetail" passed.684685OPatch succeeded.686Oracle Interim Patch Installer version 11.2.0.3.44687Copyright (c) 2024, Oracle Corporation. All rights reserved.688689690Oracle Home : /u01/app/oracle/product/11.2.0/db691Central Inventory : /u01/app/oraInventory692 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc693OPatch version : 11.2.0.3.44694OUI version : 11.2.0.4.0695Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_15-50-36PM_1.log696697Verifying environment and performing prerequisite checks...698OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075 25869727 26609445 26392168 26925576 27338049 27734982 28204707 28729262 29141056 29497421 29913194 30298532 30670774 31103343 31537677 31983472 32328626 32758711 33128584 33477185 33711103 34057724 34386237 34677698 34998337 35269283 35574075 699700Do you want to proceed? [y|n]701Y (auto-answered by -silent)702User Responded with: Y703All checks passed.704705Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.706(Oracle Home = '/u01/app/oracle/product/11.2.0/db')707708709Is the local system ready for patching? [y|n]710Y (auto-answered by -silent)711User Responded with: Y712Backing up files...713Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db'714715Patching component oracle.rdbms, 11.2.0.4.0...716717Patching component oracle.rdbms.rsf, 11.2.0.4.0...718719Patching component oracle.sdo, 11.2.0.4.0...720721Patching component oracle.sysman.agent, 10.2.0.4.5...722723Patching component oracle.xdk, 11.2.0.4.0...724725Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...726727Patching component oracle.sdo.locator, 11.2.0.4.0...728729Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...730731Patching component oracle.xdk.rsf, 11.2.0.4.0...732733Patching component oracle.rdbms.rman, 11.2.0.4.0...734Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/db'735736Patching component oracle.rdbms, 11.2.0.4.0...737738Patching component oracle.rdbms.rsf, 11.2.0.4.0...739740Patching component oracle.ldap.rsf, 11.2.0.4.0...741742Patching component oracle.rdbms.crs, 11.2.0.4.0...743744Patching component oracle.precomp.common, 11.2.0.4.0...745746Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...747748Patching component oracle.rdbms.deconfig, 11.2.0.4.0...749750Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...751752Patching component oracle.rdbms.rman, 11.2.0.4.0...753Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/db'754755Patching component oracle.rdbms.rsf, 11.2.0.4.0...756757Patching component oracle.rdbms, 11.2.0.4.0...758759Patching component oracle.precomp.common, 11.2.0.4.0...760761Patching component oracle.rdbms.rman, 11.2.0.4.0...762763Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...764765Patching component oracle.rdbms.deconfig, 11.2.0.4.0...766Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/db'767768Patching component oracle.precomp.common, 11.2.0.4.0...769770Patching component oracle.sysman.console.db, 11.2.0.4.0...771772Patching component oracle.rdbms.rsf, 11.2.0.4.0...773774Patching component oracle.rdbms.rman, 11.2.0.4.0...775776Patching component oracle.rdbms, 11.2.0.4.0...777778Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...779780Patching component oracle.ordim.client, 11.2.0.4.0...781782Patching component oracle.ordim.jai, 11.2.0.4.0...783Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/db'784ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.785786Patching component oracle.precomp.common, 11.2.0.4.0...787788Patching component oracle.ovm, 11.2.0.4.0...789790Patching component oracle.xdk, 11.2.0.4.0...791792Patching component oracle.rdbms.util, 11.2.0.4.0...793794Patching component oracle.rdbms, 11.2.0.4.0...795796Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...797798Patching component oracle.xdk.parser.java, 11.2.0.4.0...799800Patching component oracle.oraolap, 11.2.0.4.0...801802Patching component oracle.rdbms.rsf, 11.2.0.4.0...803804Patching component oracle.xdk.rsf, 11.2.0.4.0...805806Patching component oracle.rdbms.rman, 11.2.0.4.0...807808Patching component oracle.rdbms.deconfig, 11.2.0.4.0...809Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/db'810811Patching component oracle.rdbms.dv, 11.2.0.4.0...812813Patching component oracle.rdbms.oci, 11.2.0.4.0...814815Patching component oracle.precomp.common, 11.2.0.4.0...816817Patching component oracle.sysman.agent, 10.2.0.4.5...818819Patching component oracle.xdk, 11.2.0.4.0...820821Patching component oracle.sysman.common, 10.2.0.4.5...822823Patching component oracle.rdbms, 11.2.0.4.0...824825Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...826827Patching component oracle.xdk.parser.java, 11.2.0.4.0...828829Patching component oracle.sysman.console.db, 11.2.0.4.0...830831Patching component oracle.xdk.rsf, 11.2.0.4.0...832833Patching component oracle.rdbms.rsf, 11.2.0.4.0...834835Patching component oracle.sysman.common.core, 10.2.0.4.5...836837Patching component oracle.rdbms.rman, 11.2.0.4.0...838839Patching component oracle.rdbms.deconfig, 11.2.0.4.0...840Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0/db'841842Patching component oracle.sysman.console.db, 11.2.0.4.0...843844Patching component oracle.rdbms, 11.2.0.4.0...845846Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...847848Patching component oracle.rdbms.rsf, 11.2.0.4.0...849Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0/db'850851Patching component oracle.sysman.agent, 10.2.0.4.5...852853Patching component oracle.rdbms.rsf, 11.2.0.4.0...854855Patching component oracle.rdbms.rman, 11.2.0.4.0...856857Patching component oracle.rdbms, 11.2.0.4.0...858Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0/db'859ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.860861Patching component oracle.sysman.agent, 10.2.0.4.5...862863Patching component oracle.ovm, 11.2.0.4.0...864865Patching component oracle.xdk, 11.2.0.4.0...866867Patching component oracle.rdbms, 11.2.0.4.0...868869Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...870871Patching component oracle.xdk.parser.java, 11.2.0.4.0...872873Patching component oracle.sysman.console.db, 11.2.0.4.0...874875Patching component oracle.xdk.rsf, 11.2.0.4.0...876877Patching component oracle.rdbms.rsf, 11.2.0.4.0...878879Patching component oracle.sysman.oms.core, 10.2.0.4.5...880Applying sub-patch '22502456' to OH '/u01/app/oracle/product/11.2.0/db'881ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.882883Patching component oracle.precomp.common, 11.2.0.4.0...884885Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...886887Patching component oracle.rdbms.olap, 11.2.0.4.0...888889Patching component oracle.oraolap, 11.2.0.4.0...890891Patching component oracle.rdbms.rsf, 11.2.0.4.0...892893Patching component oracle.rdbms.rman, 11.2.0.4.0...894895Patching component oracle.rdbms, 11.2.0.4.0...896897Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...898Applying sub-patch '23054359' to OH '/u01/app/oracle/product/11.2.0/db'899900Patching component oracle.rdbms.dv, 11.2.0.4.0...901902Patching component oracle.rdbms, 11.2.0.4.0...903904Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...905906Patching component oracle.rdbms.rsf, 11.2.0.4.0...907Applying sub-patch '24006111' to OH '/u01/app/oracle/product/11.2.0/db'908909Patching component oracle.sqlplus.ic, 11.2.0.4.0...910911Patching component oracle.sqlplus, 11.2.0.4.0...912913Patching component oracle.rdbms.rsf, 11.2.0.4.0...914915Patching component oracle.rdbms, 11.2.0.4.0...916917Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...918Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0/db'919920Patching component oracle.precomp.common, 11.2.0.4.0...921922Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...923924Patching component oracle.sqlplus.ic, 11.2.0.4.0...925926Patching component oracle.sqlplus, 11.2.0.4.0...927928Patching component oracle.rdbms.rsf, 11.2.0.4.0...929930Patching component oracle.rdbms, 11.2.0.4.0...931932Patching component oracle.rdbms.util, 11.2.0.4.0...933934Patching component oracle.ordim.client, 11.2.0.4.0...935936Patching component oracle.ordim.jai, 11.2.0.4.0...937938Patching component oracle.ordim.server, 11.2.0.4.0...939Applying sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0/db'940ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.941942Patching component oracle.ldap.rsf, 11.2.0.4.0...943944Patching component oracle.oracore.rsf, 11.2.0.4.0...945946Patching component oracle.rdbms, 11.2.0.4.0...947948Patching component oracle.rdbms.rsf, 11.2.0.4.0...949950Patching component oracle.rdbms.rman, 11.2.0.4.0...951Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/db'952953Patching component oracle.oracore.rsf, 11.2.0.4.0...954955Patching component oracle.rdbms, 11.2.0.4.0...956Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0/db'957ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.958959Patching component oracle.network.rsf, 11.2.0.4.0...960961Patching component oracle.ldap.client, 11.2.0.4.0...962963Patching component oracle.sysman.agent, 10.2.0.4.5...964965Patching component oracle.xdk, 11.2.0.4.0...966967Patching component oracle.rdbms, 11.2.0.4.0...968969Patching component oracle.network.listener, 11.2.0.4.0...970971Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...972973Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...974975Patching component oracle.xdk.parser.java, 11.2.0.4.0...976977Patching component oracle.xdk.rsf, 11.2.0.4.0...978979Patching component oracle.rdbms.rsf, 11.2.0.4.0...980981Patching component oracle.rdbms.rman, 11.2.0.4.0...982Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0/db'983984Patching component oracle.rdbms, 11.2.0.4.0...985986Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...987988Patching component oracle.rdbms.rman, 11.2.0.4.0...989990Patching component oracle.rdbms.rsf, 11.2.0.4.0...991Applying sub-patch '27338049' to OH '/u01/app/oracle/product/11.2.0/db'992993Patching component oracle.assistants.server, 11.2.0.4.0...994995Patching component oracle.rdbms.rsf, 11.2.0.4.0...996997Patching component oracle.rdbms, 11.2.0.4.0...998999Patching component oracle.rdbms.rman, 11.2.0.4.0...10001001Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...1002Applying sub-patch '27734982' to OH '/u01/app/oracle/product/11.2.0/db'10031004Patching component oracle.ctx, 11.2.0.4.0...10051006Patching component oracle.rdbms.rsf, 11.2.0.4.0...10071008Patching component oracle.ctx.rsf, 11.2.0.4.0...10091010Patching component oracle.rdbms, 11.2.0.4.0...10111012Patching component oracle.rdbms.rman, 11.2.0.4.0...1013Applying sub-patch '28204707' to OH '/u01/app/oracle/product/11.2.0/db'1014Applying changes to emctl script on the home: /u01/app/oracle/product/11.2.0/db ...10151016Patching component oracle.rdbms, 11.2.0.4.0...10171018Patching component oracle.oracore.rsf, 11.2.0.4.0...10191020Patching component oracle.rdbms.rsf, 11.2.0.4.0...10211022Patching component oracle.ldap.rsf, 11.2.0.4.0...10231024Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...10251026Patching component oracle.network.rsf, 11.2.0.4.0...10271028Patching component oracle.sysman.agent, 10.2.0.4.5...10291030Patching component oracle.sysman.console.db, 11.2.0.4.0...10311032Patching component oracle.ldap.security.osdt, 11.2.0.4.0...10331034Patching component oracle.ldap.owm, 11.2.0.4.0...10351036Patching component oracle.sqlplus.rsf, 11.2.0.4.0...10371038Patching component oracle.ctx, 11.2.0.4.0...1039Applying sub-patch '28729262' to OH '/u01/app/oracle/product/11.2.0/db'1040INFO: Script isn't applicable to this port!10411042Patching component oracle.rdbms, 11.2.0.4.0...10431044Patching component oracle.rdbms.rsf, 11.2.0.4.0...10451046Patching component oracle.rdbms.util, 11.2.0.4.0...10471048Patching component oracle.ldap.rsf, 11.2.0.4.0...10491050Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...10511052Patching component oracle.network.rsf, 11.2.0.4.0...10531054Patching component oracle.rdbms.rman, 11.2.0.4.0...10551056Patching component oracle.ctx, 11.2.0.4.0...1057Applying sub-patch '29141056' to OH '/u01/app/oracle/product/11.2.0/db'10581059Patching component oracle.rdbms, 11.2.0.4.0...10601061Patching component oracle.rdbms.rman, 11.2.0.4.0...10621063Patching component oracle.oracore.rsf, 11.2.0.4.0...10641065Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10661067Patching component oracle.rdbms.rsf, 11.2.0.4.0...1068Applying sub-patch '29497421' to OH '/u01/app/oracle/product/11.2.0/db'10691070Patching component oracle.rdbms, 11.2.0.4.0...10711072Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10731074Patching component oracle.rdbms.rman, 11.2.0.4.0...10751076Patching component oracle.rdbms.rsf, 11.2.0.4.0...10771078Patching component oracle.ldap.rsf, 11.2.0.4.0...10791080Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...10811082Patching component oracle.oracore.rsf, 11.2.0.4.0...10831084Patching component oracle.ctx, 11.2.0.4.0...1085Applying sub-patch '29913194' to OH '/u01/app/oracle/product/11.2.0/db'10861087Patching component oracle.rdbms, 11.2.0.4.0...10881089Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10901091Patching component oracle.rdbms.rsf, 11.2.0.4.0...10921093Patching component oracle.network.rsf, 11.2.0.4.0...10941095Patching component oracle.ldap.rsf, 11.2.0.4.0...10961097Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...10981099Patching component oracle.rdbms.util, 11.2.0.4.0...1100Applying sub-patch '30298532' to OH '/u01/app/oracle/product/11.2.0/db'1101ApplySession: Optional component(s) [ oracle.rdbms.tg4tera, 11.2.0.4.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.11021103Patching component oracle.rdbms.rsf, 11.2.0.4.0...11041105Patching component oracle.rdbms, 11.2.0.4.0...11061107Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...11081109Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...11101111Patching component oracle.ldap.rsf, 11.2.0.4.0...11121113Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...1114Applying sub-patch '30670774' to OH '/u01/app/oracle/product/11.2.0/db'11151116Patching component oracle.rdbms.rsf, 11.2.0.4.0...11171118Patching component oracle.rdbms, 11.2.0.4.0...11191120Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...11211122Patching component oracle.network.rsf, 11.2.0.4.0...11231124Patching component oracle.ldap.rsf, 11.2.0.4.0...11251126Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...11271128Patching component oracle.swd.oui, 11.2.0.4.0...11291130Patching component oracle.ctx, 11.2.0.4.0...1131Applying sub-patch '31103343' to OH '/u01/app/oracle/product/11.2.0/db'11321133Patching component oracle.rdbms, 11.2.0.4.0...11341135Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...11361137Patching component oracle.rdbms.rsf, 11.2.0.4.0...1138Applying sub-patch '31537677' to OH '/u01/app/oracle/product/11.2.0/db'11391140Patching component oracle.rdbms, 11.2.0.4.0...11411142Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...11431144Patching component oracle.rdbms.rsf, 11.2.0.4.0...11451146Patching component oracle.rdbms.dv, 11.2.0.4.0...11471148Patching component oracle.rdbms.rman, 11.2.0.4.0...11491150Patching component oracle.ldap.rsf, 11.2.0.4.0...11511152Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...11531154Patching component oracle.oracore.rsf, 11.2.0.4.0...11551156Patching component oracle.rdbms.util, 11.2.0.4.0...11571158Patching component oracle.dbdev, 11.2.0.4.0...11591160Patching component oracle.ctx, 11.2.0.4.0...11611162Patching component oracle.buildtools.rsf, 11.2.0.4.0...1163Applying sub-patch '31983472' to OH '/u01/app/oracle/product/11.2.0/db'11641165Patching component oracle.rdbms.rsf, 11.2.0.4.0...11661167Patching component oracle.rdbms, 11.2.0.4.0...11681169Patching component oracle.ctx, 11.2.0.4.0...1170Applying sub-patch '32328626' to OH '/u01/app/oracle/product/11.2.0/db'11711172Patching component oracle.rdbms, 11.2.0.4.0...11731174Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...11751176Patching component oracle.rdbms.rsf, 11.2.0.4.0...11771178Patching component oracle.rdbms.dv, 11.2.0.4.0...11791180Patching component oracle.rdbms.rman, 11.2.0.4.0...11811182Patching component oracle.ldap.rsf, 11.2.0.4.0...11831184Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...1185Applying sub-patch '32758711' to OH '/u01/app/oracle/product/11.2.0/db'11861187Patching component oracle.rdbms, 11.2.0.4.0...11881189Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...11901191Patching component oracle.ctx, 11.2.0.4.0...11921193Patching component oracle.network.rsf, 11.2.0.4.0...1194Applying sub-patch '33128584' to OH '/u01/app/oracle/product/11.2.0/db'11951196Patching component oracle.rdbms, 11.2.0.4.0...11971198Patching component oracle.rdbms.rsf, 11.2.0.4.0...11991200Patching component oracle.ctx, 11.2.0.4.0...1201Applying sub-patch '33477185' to OH '/u01/app/oracle/product/11.2.0/db'12021203Patching component oracle.rdbms, 11.2.0.4.0...12041205Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...12061207Patching component oracle.rdbms.rsf, 11.2.0.4.0...12081209Patching component oracle.network.rsf, 11.2.0.4.0...12101211Patching component oracle.rdbms.dv, 11.2.0.4.0...1212Applying sub-patch '33711103' to OH '/u01/app/oracle/product/11.2.0/db'1213ApplySession: Optional component(s) [ oracle.rdbms.tg4tera, 11.2.0.4.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.4.0 ] , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.12141215Patching component oracle.rdbms.rsf, 11.2.0.4.0...12161217Patching component oracle.rdbms, 11.2.0.4.0...12181219Patching component oracle.rdbms.rsf, 11.2.0.4.0...12201221Patching component oracle.network.rsf, 11.2.0.4.0...12221223Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...12241225Patching component oracle.rdbms.hs_common, 11.2.0.4.0...12261227Patching component oracle.buildtools.rsf, 11.2.0.4.0...12281229Patching component oracle.buildtools.rsf, 11.2.0.4.0...1230Applying sub-patch '34057724' to OH '/u01/app/oracle/product/11.2.0/db'1231ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.12321233Patching component oracle.rdbms, 11.2.0.4.0...12341235Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...12361237Patching component oracle.rdbms.rsf, 11.2.0.4.0...12381239Patching component oracle.network.rsf, 11.2.0.4.0...12401241Patching component oracle.ldap.rsf, 11.2.0.4.0...12421243Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...12441245Patching component oracle.swd.oui.core, 11.2.0.4.0...1246Applying sub-patch '34386237' to OH '/u01/app/oracle/product/11.2.0/db'1247ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.12481249Patching component oracle.rdbms, 11.2.0.4.0...12501251Patching component oracle.rdbms.rsf, 11.2.0.4.0...12521253Patching component oracle.network.rsf, 11.2.0.4.0...12541255Patching component oracle.swd.oui.core, 11.2.0.4.0...12561257Patching component oracle.ctx, 11.2.0.4.0...1258Applying sub-patch '34677698' to OH '/u01/app/oracle/product/11.2.0/db'1259ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.12601261Patching component oracle.rdbms, 11.2.0.4.0...12621263Patching component oracle.rdbms.rsf, 11.2.0.4.0...12641265Patching component oracle.javavm.containers, 11.2.0.4.0...1266Applying sub-patch '34998337' to OH '/u01/app/oracle/product/11.2.0/db'1267ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.12681269Patching component oracle.rdbms, 11.2.0.4.0...12701271Patching component oracle.rdbms.rsf, 11.2.0.4.0...1272Applying sub-patch '35269283' to OH '/u01/app/oracle/product/11.2.0/db'1273ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.12741275Patching component oracle.rdbms, 11.2.0.4.0...12761277Patching component oracle.network.rsf, 11.2.0.4.0...12781279Patching component oracle.rdbms.rsf, 11.2.0.4.0...12801281Patching component oracle.dbdev, 11.2.0.4.0...1282Applying sub-patch '35574075' to OH '/u01/app/oracle/product/11.2.0/db'1283ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.12841285Patching component oracle.rdbms, 11.2.0.4.0...12861287Patching component oracle.rdbms.rsf, 11.2.0.4.0...12881289Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...12901291Patching component oracle.network.rsf, 11.2.0.4.0...12921293Patching component oracle.rdbms.rsf, 11.2.0.4.0...12941295Patching component oracle.sysman.oms.core, 10.2.0.4.5...12961297Patching component oracle.marvel, 11.2.0.4.0...12981299Patching component oracle.javavm.containers, 11.2.0.4.0...13001301Patching component oracle.dbjava.ucp, 11.2.0.4.0...13021303Patching component oracle.owb.rsf, 11.2.0.4.0...13041305Patching component oracle.sysman.ccr, 10.3.8.1.0...13061307Patching component oracle.sysman.ccr.client, 10.3.2.1.0...13081309Patching component oracle.sysman.common, 10.2.0.4.5...13101311Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...13121313Patching component oracle.javavm.containers, 11.2.0.4.0...1314Composite patch 35574075 successfully applied.1315Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_15-50-36PM_1.log13161317OPatch succeeded.13181319#==============================================================# 1320Oracle 软件安装补丁 33991024 1321#==============================================================# 13221323Oracle Interim Patch Installer version 11.2.0.3.441324Copyright (c) 2024, Oracle Corporation. All rights reserved.13251326PREREQ session13271328Oracle Home : /u01/app/oracle/product/11.2.0/db1329Central Inventory : /u01/app/oraInventory1330 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1331OPatch version : 11.2.0.3.441332OUI version : 11.2.0.4.01333Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-06-56PM_1.log13341335Invoking prereq "checkconflictagainstohwithdetail"13361337Prereq "checkConflictAgainstOHWithDetail" passed.13381339OPatch succeeded.1340Oracle Interim Patch Installer version 11.2.0.3.441341Copyright (c) 2024, Oracle Corporation. All rights reserved.134213431344Oracle Home : /u01/app/oracle/product/11.2.0/db1345Central Inventory : /u01/app/oraInventory1346 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1347OPatch version : 11.2.0.3.441348OUI version : 11.2.0.4.01349Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-06-59PM_1.log13501351Verifying environment and performing prerequisite checks...1352OPatch continues with these patches: 33991024 13531354Do you want to proceed? [y|n]1355Y (auto-answered by -silent)1356User Responded with: Y1357All checks passed.13581359Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1360(Oracle Home = '/u01/app/oracle/product/11.2.0/db')136113621363Is the local system ready for patching? [y|n]1364Y (auto-answered by -silent)1365User Responded with: Y1366Backing up files...1367Applying interim patch '33991024' to OH '/u01/app/oracle/product/11.2.0/db'13681369Patching component oracle.rdbms.rsf, 11.2.0.4.0...13701371Patching component oracle.buildtools.rsf, 11.2.0.4.0...13721373Patching component oracle.has.db, 11.2.0.4.0...1374Patch 33991024 successfully applied.1375Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-06-59PM_1.log13761377OPatch succeeded.13781379Oracle 执行 relink： 13801381writing relink log to: /u01/app/oracle/product/11.2.0/db/install/relink.log13821383#==============================================================# 1384OJVM 补丁安装 1385#==============================================================# 13861387Oracle Interim Patch Installer version 11.2.0.3.441388Copyright (c) 2024, Oracle Corporation. All rights reserved.13891390PREREQ session13911392Oracle Home : /u01/app/oracle/product/11.2.0/db1393Central Inventory : /u01/app/oraInventory1394 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1395OPatch version : 11.2.0.3.441396OUI version : 11.2.0.4.01397Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-09-01PM_1.log13981399Invoking prereq "checkconflictagainstohwithdetail"14001401Prereq "checkConflictAgainstOHWithDetail" passed.14021403OPatch succeeded.1404Oracle Interim Patch Installer version 11.2.0.3.441405Copyright (c) 2024, Oracle Corporation. All rights reserved.140614071408Oracle Home : /u01/app/oracle/product/11.2.0/db1409Central Inventory : /u01/app/oraInventory1410 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1411OPatch version : 11.2.0.3.441412OUI version : 11.2.0.4.01413Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-09-04PM_1.log14141415Verifying environment and performing prerequisite checks...1416OPatch continues with these patches: 35685663 14171418Do you want to proceed? [y|n]1419Y (auto-answered by -silent)1420User Responded with: Y1421All checks passed.14221423Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1424(Oracle Home = '/u01/app/oracle/product/11.2.0/db')142514261427Is the local system ready for patching? [y|n]1428Y (auto-answered by -silent)1429User Responded with: Y1430Backing up files...1431Applying interim patch '35685663' to OH '/u01/app/oracle/product/11.2.0/db'1432ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.14331434Patching component oracle.javavm.server, 11.2.0.4.0...14351436Patching component oracle.precomp.common, 11.2.0.4.0...14371438Patching component oracle.rdbms, 11.2.0.4.0...14391440Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...14411442Patching component oracle.javavm.client, 11.2.0.4.0...14431444Patching component oracle.dbjava.jdbc, 11.2.0.4.0...14451446Patching component oracle.dbjava.ic, 11.2.0.4.0...1447Patch 35685663 successfully applied.1448Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_16-09-04PM_1.log14491450OPatch succeeded.14511452#==============================================================# 1453Oracle 软件版本 1454#==============================================================# 145514561457SQL*Plus: Release 11.2.0.4.0 Production145814591460#==============================================================# 1461Oracle 补丁信息 1462#==============================================================# 1463146435685663;OJVM PATCH SET UPDATE 11.2.0.4.231017146533991024;11204CERT ON OL8: LINKING ERRORS DURING 11204 FOR DB INSTALL ON OL8.2146635574075;Database Patch Set Update : 11.2.0.4.231017 (35574075)14671468OPatch succeeded.146914701471#==============================================================# 1472静默建库命令：lucifer 1473#==============================================================# 14741475dbca -silent -createDatabase \1476-templateName General_Purpose.dbc \1477-responseFile NO_VALUE \1478-gdbname lucifer \1479-sid lucifer \1480-sysPassword oracle \1481-systemPassword oracle \1482-redoLogFileSize 100 \1483-diskGroupName DATA \1484-storageType ASM \1485-characterSet AL32UTF8 \1486-nationalCharacterSet AL16UTF16 \1487-emConfiguration NONE \1488-automaticMemoryManagement false \1489-totalMemory 3716 \1490-databaseType OLTP 14911492#==============================================================# 1493创建数据库实例：lucifer 1494#==============================================================# 14951496Copying database files14971% complete14983% complete149910% complete150017% complete150124% complete150231% complete150335% complete1504Creating and starting Oracle instance150537% complete150642% complete150747% complete150852% complete150953% complete151056% complete151158% complete1512Registering database with Oracle Restart151364% complete1514Completing Database Creation151568% complete151671% complete151775% complete151876% complete151977% complete152078% complete152179% complete152280% complete152381% complete152482% complete152592% complete1526100% complete1527Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.15281529#==============================================================# 1530配置 OMF && 优化 RMAN 1531#==============================================================# 153215331534Recovery Manager: Release 11.2.0.4.0 - Production on Fri Mar 29 16:25:42 202415351536Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.15371538connected to target database: LUCIFER (DBID=4020786356)15391540RMAN> 1541using target database control file instead of recovery catalog1542new RMAN configuration parameters:1543CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_fdcdb1.f';1544new RMAN configuration parameters are successfully stored15451546RMAN> 1547RMAN configuration parameters for database with db_unique_name LUCIFER are:1548CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_fdcdb1.f';15491550RMAN> 15511552Recovery Manager complete.15531554NAME TYPE VALUE1555------------------------------------ ----------- ------------------------------1556db_create_file_dest string +DATA15571558#==============================================================# 1559配置 Oracle 数据库控制文件复用 1560#==============================================================# 156115621563数据库控制文件： 156415651566NAME1567----------------------------------------------------------------------------------------------------1568+DATA/lucifer/controlfile/current.262.11649030931569+DATA/lucifer/controlfile/current.261.116490309315701571#==============================================================# 1572配置在线重做日志 1573#==============================================================# 15741575数据库在线重做日志文件： 157615771578 THREAD# GROUP# MEMBER size(M)1579---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------1580 1 1 +DATA/lucifer/onlinelog/group_1.263.1164903097 1001581 1 1 +DATA/lucifer/onlinelog/group_1.264.1164903103 1001582 1 2 +DATA/lucifer/onlinelog/group_2.265.1164903105 1001583 1 2 +DATA/lucifer/onlinelog/group_2.266.1164903107 1001584 1 3 +DATA/lucifer/onlinelog/group_3.267.1164903109 1001585 1 3 +DATA/lucifer/onlinelog/group_3.268.1164903111 1001586 1 11 +DATA/lucifer/onlinelog/group_11.271.1164903945 1001587 1 11 +DATA/lucifer/onlinelog/group_11.272.1164903949 1001588 1 12 +DATA/lucifer/onlinelog/group_12.273.1164903951 1001589 1 12 +DATA/lucifer/onlinelog/group_12.274.1164903953 1001590 1 13 +DATA/lucifer/onlinelog/group_13.275.1164903957 1001591 1 13 +DATA/lucifer/onlinelog/group_13.276.1164903957 1001592 1 14 +DATA/lucifer/onlinelog/group_14.277.1164903961 1001593 1 14 +DATA/lucifer/onlinelog/group_14.278.1164903963 1001594 1 15 +DATA/lucifer/onlinelog/group_15.279.1164903963 1001595 1 15 +DATA/lucifer/onlinelog/group_15.280.1164903965 10015961597#==============================================================# 1598配置 Oracle 数据库开机自启 1599#==============================================================# 160016011602#==============================================================# 1603配置 RMAN 备份任务 1604#==============================================================# 16051606## OracleBegin160700 02 * * * /home/oracle/scripts/del_arch_lucifer.sh1608#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0_lucifer.sh1609#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1_lucifer.sh16101611#==============================================================# 1612优化数据库参数 1613#==============================================================# 16141615数据库参数： 161616171618NAME SID SPVALUE VALUE1619-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------1620_b_tree_bitmap_plans * FALSE FALSE1621_datafile_write_errors_crash_instance * FALSE FALSE1622audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump1623audit_trail * NONE DB1624compatible * 11.2.0.4.0 11.2.0.4.01625control_file_record_keep_time * 31 311626db_block_size * 8192 81921627db_create_file_dest * +DATA +DATA1628db_file_multiblock_read_count * 1281629db_files * 5000 2001630db_name * lucifer lucifer1631db_recovery_file_dest * +DATA +DATA1632db_recovery_file_dest_size * 4857004032 48570040321633db_writer_processes * 11634deferred_segment_creation * FALSE FALSE1635diagnostic_dest * /u01/app/oracle /u01/app/oracle1636dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)1637enable_ddl_logging * TRUE FALSE1638event * 10949 trace name context forever,level 11639event * 28401 trace name context forever,level 11640fast_start_parallel_rollback * LOW1641log_archive_dest_1 * location=+DATA location=+DATA1642log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf1643max_dump_file_size * unlimited1644open_cursors * 1000 3001645optimizer_index_caching * 01646optimizer_mode * ALL_ROWS1647parallel_force_local * FALSE1648parallel_max_servers * 64 641649pga_aggregate_target * 1246756864 7790919681650processes * 2000 1501651remote_login_passwordfile * EXCLUSIVE EXCLUSIVE1652resource_limit * TRUE FALSE1653resource_manager_plan * force:1654sec_case_sensitive_logon * FALSE TRUE1655session_cached_cursors * 300 501656sessions * 2481657sga_max_size * 4988076032 31205621761658sga_target * 4988076032 31205621761659spfile * +DATA/lucifer/spfilelucifer.ora1660statistics_level * TYPICAL1661undo_retention * 10800 90016621663#==============================================================# 1664配置 glogin.sql 1665#==============================================================# 16661667define _editor=vi1668set serveroutput on size 10000001669set pagesize 99991670set long 999991671set trimspool on1672col name format a801673set termout off1674define gname=idle1675column global_name new_value gname1676select lower(user) || '@' || substr( global_name, 1, decode( dot, 0, length(global_name), dot-1) ) global_name from (select global_name, instr(global_name,'.') dot from global_name );1677ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';1678set sqlprompt '&gname _DATE> '1679set termout on