20211107_一键安装Oracle11g/19C/21C_单机版_工具分享_开放源码

1. 目标说明

本文档旨在帮助Oracle管理及维护人员标准、高效安装Oracle11G/19C/21C`
数据库，实现Oracle一键安装。

软件下载地址(x_onekey_v0.2.sh)：

https://www.modb.pro/download/229202

2. 软件规划

Oracle版本支持规划如下所示，

3. 文件系统

注：测试环境根据实际存储量调整以上目录大小,测试环境可以只安装OS不用创建其它目录,测试环境建议存储40G以上。

4. OS时区

时区选择东八区：Shanghai，Asia；

5. 上传安装文件

创建软件包目录并上传Oracle安装文件

[root@ora11g ~]# mkdir -p /soft
[root@oradb ~]# tree /soft 
/soft
|-- LINUX.X64_193000_db_home.zip              <-- 仅安装19C时需上传
|-- LINUX.X64_213000_db_home.zip              <-- 仅安装21C时需上传
|-- p13390677_112040_Linux-x86-64_1of7.zip    <-- 仅安装11G时需上传
|-- p13390677_112040_Linux-x86-64_2of7.zip    <-- 仅安装11G时需上传
|-- x_onekey_v0.2.sh
复制

4. 安装过程演示

[root@ora11g ~]# chmod a+x /soft/x_onekey_v0.2.sh 
[root@ora11g ~]# sh /soft/x_onekey_v0.2.sh
INSTANCE_NAME    STATUS
---------------- ------------
orcl             OPEN

SQL> 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ENMO                           READ WRITE NO
SQL> 
LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 08-NOV-2021 01:58:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 21.0.0.0.0 - Production
Start Date                08-NOV-2021 01:53:22
Uptime                    0 days 0 hr. 5 min. 16 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/homes/OraDB21Home1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oradb/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "c8209f27c6b16005e053362ee80ae60e" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "d0379fe8a6ab2c6ee055bbdcb00a5558" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "enmo" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

SQL> Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
******* 19.2 check HugePage info
AnonHugePages:      8192 kB
HugePages_Total:    2025
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB
db install used: 441 seconds

************** complete install Oracle db 21.3.0 on Linux 7.x *********************
************** if you need any support,contact my wechat: xidoublestar *************
复制

5. 常见问题

问题1 syntax error near unexpected token `$'{\r''
windows格式问题使用以下语句修复
sed -i 's/\r//g'  install_oracle11g_linux7_single.sh
问题2 7装11.2.4不需要打补丁吗
Installation of Oracle 11.2.0.4 Database Software on OL7 fails with 'Error in invoking target
'agent nmhs' of makefile ' & “undefined reference to symbol ‘B_DestroyKeyObject’” error (Doc ID 1965691.1),
solution: 
01) Ignore the undefined symbol error during Oracle 11.2.0.4 installation and proceed further. 
The software installation will succeed without any further errors.
02) Download and install patch 19692824  
复制

6. 版本功能说明

****************x_onekey_v0.1.sh*****************
1). 自动安装Oracle 11G on Linux 7.x软件
2). 自动完成大页配置整改
3). 自动关闭防火墙/selinux等37项OS服务
4). 自动配置Oracle监听
5). 自动创建Oracle实例
6). 自动完成大页整改
****************x_onekey_v0.2.sh*****************
1). 自动安装Oracle 19C/21C软件 
2). 自动配置Oracle 19C/21C监听
3). 自动创建Oracle 19C/21C实例
复制