centos 7 静默安装oracle 11.2.0.4 单机版安装指南 -m6米乐安卓版下载

1.9 安装依赖包

# root用户使用本地yum源安装如下依赖包
[root@192 ~]# yum install -y gcc make binutils gcc-c   compat-libstdc  -33 elfutils-libelf-devel elfutils-libelf-devel-static libstdc   libstdc  -devel ksh libaio libaio-devel numactl-devel sysstat unixodbc unixodbc-devel pcre-devel glibc glibc-common glibc-devel

1.10 关闭防火墙

# root用户操作
[root@192 ~]# service iptables stop
[root@192 ~]# systemctl stop firewalld
[root@192 ~]# systemctl disable firewalld

1.11 关闭selinux

# root用户操作
[root@192 ~]# sed -i  "s/selinux=enforcing/selinux=disabled/"  /etc/selinux/config
[root@192 ~]# cat /etc/selinux/config
[root@192 ~]# setenforce 0

2.1 准备db_install.rsp响应文件

# 切换至oracle用户操作
[root@192 ~]# su - oracle
[oracle@192 ~]$ cp -r /home/soft/database/response/ .
[oracle@192 ~]$ ll
total 0
drwxr-xr-x. 2 oracle oinstall 61 may 23 22:04 response
[oracle@192 ~]$ cd response/
# 编辑 db_install.rsp响应文件，主要修改以下内容
# 响应文件的格式版本，这里指定的版本为 "/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0"
oracle.install.responsefileversion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
# 安装选项，这里设置为 "install_db_swonly"，表示仅安装数据库软件，而不创建或配置数据库实例
oracle.install.option=install_db_swonly
# oracle数据库所在的主机名
oracle_hostname=xxx-db
# 用于安装和管理oracle软件的unix组名,这里设置为"oinstall"
unix_group_name=oinstall
# oracle inventory(安装目录)的路径,这里设置为 "/u01/app/orainventory"。
inventory_location=/u01/app/orainventory
# 选择的语言,这里设置为 "en,zh_cn"，表示英文和简体中文
selected_languages=en,zh_cn
# oracle软件的安装路径(数据库主目录)
oracle_home=/u01/app/oracle/product/11.2.0/db_1
# oracle软件的基本路径
oracle_base=/u01/app/oracle
# 安装的oracle数据库版本。这里设置为 "ee"，表示企业版
oracle.install.db.installedition=ee
# 是否选择了企业版选项,这里设置为"false"，表示未选择任何企业版选项
oracle.install.db.eeoptionsselection=false
# 用于数据库管理员(dba) 组的名称,这里设置为 "dba"
oracle.install.db.dba_group=dba
# 用于操作员组的名称,这里设置为 "dba"，与dba组相同
oracle.install.db.oper_group=dba
# 是否拒绝安装安全更新,这里设置为 "true"，表示拒绝安装安全更新
decline_security_updates=true
# 自动更新选项,这里设置为 "skip_updates"，表示跳过自动更新
oracle.installer.autoupdates.option=skip_updates

2.2 运行runinstaller进行安装

[oracle@192 response]$ cd /home/soft/database/
[oracle@192 database]$ ./runinstaller -silent -noconfig -ignoreprereq -responsefile /home/oracle/response/db_install.rsp
# 以下是上述命令执行生成内容
starting oracle universal installer...
checking temp space: must be greater than 120 mb.   actual 43276 mb    passed
checking swap space: must be greater than 150 mb.   actual 3967 mb    passed
preparing to launch oracle universal installer from /tmp/orainstall2023-05-23_10-51-54pm. please wait ...[oracle@192 database]$ 
[oracle@192 database]$ [warning] [ins-32055] the central inventory is located in the oracle base.
   cause: the central inventory is located in the oracle base.
   action: oracle recommends placing this central inventory in a location outside the oracle base directory.
you can find the log of this install session at:
 /u01/app/oracle/inventory/logs/installactions2023-05-23_10-51-54pm.log
the installation of oracle database 11g was successful.
please check '/u01/app/oracle/inventory/logs/silentinstall2023-05-23_10-51-54pm.log' for more details.
as a root user, execute the following script(s):
        1. /u01/app/oracle/inventory/orainstroot.sh
        2. /u01/app/oracle/product/11.2.0/db_1/root.sh
# 此时会提示要使用root用户执行上述两个脚本
# 新打开一个会话，使用root用户执行
1） 首先执行/u01/app/oracle/inventory/orainstroot.sh脚本
[root@192 db_1]# /u01/app/oracle/inventory/orainstroot.sh
# 生成内容如下
changing permissions of /u01/app/oracle/inventory.
adding read,write permissions for group.
removing read,write,execute permissions for world.
changing groupname of /u01/app/oracle/inventory to oinstall.
the execution of the script is complete.
2）再次执行/u01/app/oracle/product/11.2.0/db_1/root.sh脚本
[root@192 db_1]# /u01/app/oracle/product/11.2.0/db_1/root.sh
# 生成内容如下
check /u01/app/oracle/product/11.2.0/db_1/install/root_192.168.20.16_2023-05-23_22-59-10.log for the output of root script
# 以上两个脚本执行完毕后，返回前一个会话，按回车，结束安装，执行成功，结果如下。
successfully setup software.

3.1 使用netca.rsp响应文件创建监听

# 使用oracle用户执行
[oracle@192 ~]$ netca /silent -responsefile /home/oracle/response/netca.rsp
# 上述命令执行后，生成内容如下
parsing command line arguments:
    parameter "silent" = true
    parameter "responsefile" = /home/oracle/response/netca.rsp
done parsing command line arguments.
oracle net services configuration:
profile configuration complete.
oracle net listener startup:
    running listener control: 
      /u01/app/oracle/product/11.2.0/db_1/bin/lsnrctl start listener
    listener control complete.
    listener started successfully.
listener configuration complete.
oracle net services configuration successful. the exit code is 0
# 曾在一个测试环境执行时遇到如下报错
parsing command line arguments:
    parameter "silent" = true
    parameter "responsefile" = /home/oracle/response/netca.rsp
done parsing command line arguments.
oracle net services configuration:
profileexception: could not save profile: tns-04415: file i/o error
  caused by: java.io.filenotfoundexception: /usr/lib/oracle/19.16/client64/lib/network/admin/sqlnet.ora (permission denied)
profile configuration complete.
listenerexception: could not save listener: tns-04415: file i/o error
  caused by: java.io.filenotfoundexception: /usr/lib/oracle/19.16/client64/lib/network/admin/listener.ora (permission denied)
oracle net listener startup:
    running listener control: 
      /u01/app/oracle/product/11.2.0/bin/lsnrctl start listener
    listener control complete.
    listener started successfully.
# 对于上述报错，将/usr/lib/下oracle目录进行了修改，修改为777，再执行命令就未再报错

4.1 准备dbca.rsp响应文件

# 使用oracle用户执行，编辑dbca.rsp响应文件，主要修改如下内容
# 全局数据库名
gdbname = "orcl"
# 数据库实例名
sid = "orcl"
# sys用户的密码
syspassword = "oracle"
# system用户的密码
systempassword = "oracle"
# sysman用户（用于enterprise manager）的密码
sysmanpassword = "oracle"
# dbsnmp用户（用于snmp管理）的密码
dbsnmppassword = "oracle"
# 数据文件存储路径
datafiledestination =/u01/app/oracle/oradata
# 恢复区域存储路径
recoveryareadestination=/u01/app/oracle/fast_recovery_area
# 数据库字符集
characterset = "zhs16gbk"
# 数据库实例使用的总内存大小（以mb为单位）
totalmemory = "3276"

4.2 创建数据库

# 使用oracle用户，执行如下命令
[oracle@192 ~]$ dbca -silent -responsefile /home/oracle/response/dbca.rsp
# 上述命令执行后生成内容如下
copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
creating and starting oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
completing database creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details

4.3 查看监听状态

[oracle@192 ~]$ lsnrctl status
lsnrctl for linux: version 11.2.0.4.0 - production on 24-may-2023 02:18:01
米乐app官网下载 copyright (c) 1991, 2013, oracle.  all rights reserved.
connecting to (description=(address=(protocol=ipc)(key=extproc1521)))
status of the listener
------------------------
alias                     listener
version                   tnslsnr for linux: version 11.2.0.4.0 - production
start date                23-may-2023 23:50:11
uptime                    0 days 2 hr. 27 min. 51 sec
trace level               off
security                  on: local os authentication
snmp                      off
listener parameter file   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
listener log file         /u01/app/oracle/diag/tnslsnr/192/listener/alert/log.xml
listening endpoints summary...
  (description=(address=(protocol=ipc)(key=extproc1521)))
  (description=(address=(protocol=tcp)(host=192.168.xxx.xxx)(port=1521)))
services summary...
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

4.4 查看实例状态

[oracle@192 ~]$ sqlplus / as sysdba
sql*plus: release 11.2.0.4.0 production on wed may 24 02:19:04 2023
米乐app官网下载 copyright (c) 1982, 2013, oracle.  all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.4.0 - 64bit production
with the partitioning, olap, data mining and real application testing options
sql> select status from v$instance;
status
------------
open

4.5 修改local_listener

[oracle@192 ~]$ sqlplus / as sysdba
sql> alter system set local_listener='(address=(protocol=tcp)(host=192.168.xxx.xxx)(port=1521))';
sql> alter system register;