【Oracle】静默安装oracle 11.2.0.4 超详细
安装oracle
1.执行脚本完成初始化oracle环境
2.解压缩oracle的压缩包,单实例1个,rac是2两个压缩包
3.修改response下的db_install.rsp
修改内容如下:
---------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY // 安装类型 29行
ORACLE_HOSTNAME=t91 // 主机名称(hostname查询,这里要注意,主机名要在 /etc/hosts 文件中配置好ip对应关系,否则安装会报错) 37行
UNIX_GROUP_NAME=oinstall // 安装组 42行
INVENTORY_LOCATION=/usr/oracle/oraInventory //INVENTORY目录(不填就是默认值) 49行 这个文件不能放在ORACLE_BASE下
SELECTED_LANGUAGES=en,zh_CN,zh_TW // 选择语言 86行
ORACLE_HOME=/usr/oracle/product/11.2.0/db_1 // oracle_home 91行
ORACLE_BASE=/usr/oracle // oracle_base --96行
oracle.install.db.InstallEdition=EE // oracle版本 107行
oracle.install.db.isCustomInstall=false //自定义安装,否,使用默认组件 117行
oracle.install.db.DBA_GROUP=dba // dba用户组 154行
oracle.install.db.OPER_GROUP=oinstall // oper用户组 160行
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE //数据库类型 189行
oracle.install.db.config.starterdb.globalDBName=orcl //globalDBName(这里要和第8步配置的sid一致) 194行
oracle.install.db.config.starterdb.SID=orcl //SID(这里要和第8步配置的sid一致)199行
oracle.install.db.config.starterdb.characterSet=AL32UTF8 213行
oracle.install.db.config.starterdb.password.ALL=oracle123 //设定所有数据库用户使用同一个密码 262行
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false(手动写了false) 388
DECLINE_SECURITY_UPDATES=true //设置安全更新(貌似是有bug,这个一定要选true,否则会无限提醒邮件地址有问题,终止安装。 400行
--------------------------------------------------------------------
4.创建oracle软件
./runInstaller -silent -ignoreSysPrereqs -force -ignorePrereq -responseFile /usr/local/src/database/response/db_install.rsp
[oracle@oracle database]$ The installation of Oracle Database 11g was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2018-05-15_10-31-17AM.log' for more details.
As a root user, execute the following script(s):
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/oracle/product/11.2.0/dbhome_1/root.sh
Successfully Setup Software.
执行两个脚本,完成安装
出现问题后,根据日志,解决问题,并且删除oracle_base下的所有文件,并重新执行静默安装命令
遇到的坑有:[INS-32055] The Central Inventory is located in the Oracle base.
这个就是将注册文件存放在oracle_base下了,重新将文件中的路径修改下即可
安装监听
$ORACLE_HOME/bin
netca /silent /responseFile /usr/local/src/database/response/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /usr/local/src/database/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/dbhome_1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
提示successfully即安装成功
创建数据库
修改数据库中所有的orcl11g相关的内容,将orcl11g修改为你想要的sid
我这里就修改为orcl了
直接vi进入到dbca.rsp中,查找orcl11g完事后修改即可
$ORACLE_HOME/bin
dbca -silent -responseFile /usr/local/src/database/response/dbca.rsp
Enter SYS user password: 123456 --输入sys密码
Enter SYSTEM user password: --输入system密码
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.
到这里就正式安装数据库完成了,查看进程
[oracle@oracle bin]$ ps -ef | grep ora_
oracle 6233 1 0 02:15 ? 00:00:00 ora_pmon_orcl
oracle 6235 1 0 02:15 ? 00:00:00 ora_psp0_orcl
oracle 6237 1 2 02:15 ? 00:00:01 ora_vktm_orcl
oracle 6241 1 0 02:15 ? 00:00:00 ora_gen0_orcl
oracle 6243 1 0 02:15 ? 00:00:00 ora_diag_orcl
oracle 6245 1 0 02:15 ? 00:00:00 ora_dbrm_orcl
oracle 6247 1 0 02:15 ? 00:00:00 ora_dia0_orcl
oracle 6249 1 0 02:15 ? 00:00:00 ora_mman_orcl
oracle 6251 1 0 02:15 ? 00:00:00 ora_dbw0_orcl
oracle 6253 1 0 02:15 ? 00:00:00 ora_lgwr_orcl
oracle 6255 1 0 02:15 ? 00:00:00 ora_ckpt_orcl
oracle 6257 1 0 02:15 ? 00:00:00 ora_smon_orcl
oracle 6259 1 0 02:15 ? 00:00:00 ora_reco_orcl
oracle 6261 1 0 02:15 ? 00:00:00 ora_mmon_orcl
oracle 6263 1 0 02:15 ? 00:00:00 ora_mmnl_orcl
oracle 6265 1 0 02:15 ? 00:00:00 ora_d000_orcl
oracle 6267 1 0 02:15 ? 00:00:00 ora_s000_orcl
oracle 6275 1 0 02:15 ? 00:00:00 ora_qmnc_orcl
oracle 6291 1 0 02:15 ? 00:00:00 ora_cjq0_orcl
oracle 6293 1 0 02:15 ? 00:00:00 ora_q000_orcl
oracle 6295 1 0 02:15 ? 00:00:00 ora_q001_orcl
oracle 6297 5820 0 02:16 pts/0 00:00:00 grep orcl
[oracle@oracle ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed May 16 02:19:55 2018
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> col instance_name for a10;
SQL> col status for a10;
SQL> select instance_name ,status from v$instance;
INSTANCE_N STATUS
---------- ----------
orcl OPEN
SQL> select open_mode from v$database;
OPEN_MODE
------------------------------------------------------------
READ WRITE
SQL> create pfile from spfile; --这一步最好做一下,万一起不来的话,可以用pfile启动
File created.
尝试重启数据库看是否异常
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 409194496 bytes
Fixed Size 2253744 bytes
Variable Size 322964560 bytes
Database Buffers 79691776 bytes
Redo Buffers 4284416 bytes
Database mounted.
Database opened.
SQL> select instance_name ,status from v$instance;
INSTANCE_N STATUS
---------- ----------
orcl OPEN
启动正常,证明全部安装完成
dbca的时候报错误: ORA-1503, ORA-1130, ORA-1100
这里遇到了上述错误,提示版本不一致,后来发现就是dbca.rsp这个文件中,orcl11g相关的东西没有全部修改完全导致的,后来再次修改完整后,启动成功
最新文章
- marquee实现文字移动效果;js+div实现文字无缝移动效果
- PHP获取当前服务器信息的基本语句
- C++ REST SDK的基本用法
- 06章 Struts2数据校验
- Add Digits
- 【转】ASP.NET数据库连接字符串总结
- sqlserver 登录失败——孤立用户
- usb协议分析-设备描述符配置包-描述符
- Castle IOC容器快速入门
- C++对象模型5--多继承下的对象模型
- perl 登陆电信猫
- ARM裸编程系列---UART
- asp.net core mvc权限控制:权限控制介绍
- linux下安装配置jdk(解压版)
- x264源代码简单分析:概述
- 手把手教你使用 netlify 实现前端的 自动部署 + HTTPS
- 【原创】深入理解c++的右值引用
- HTML标签笔记
- 福州大学软件工程1816 | W班 第3次作业成绩排名
- 解决 git push Failed to connect to 127.0.0.1 port 8-87: 拒绝连接