小编给大家分享一下如何使用应答文件安装Oracle11g数据库,相信大部分人都还不怎么了解,因此分享这篇文章给大家参考一下,希望大家阅读完这篇文章后大有收获,下面让我们一起去了解一下吧!注:如果实在无法连上图形化界面,可选择该方案。安装之前:打开XShell,以root用户身份创建/oraInventory文件夹。[root@Pet ~]# mkdir /oraInventory
[root@Pet ~]# cd /
[root@P免费主机域名et /]# chown -R oracle:oinstall oraInventory
[root@XLJ181 ~]# export DISPLAY=:0.0
[root@XLJ181 ~]# xhost +
access control disabled, clients can connect from any host (在/etc/hosts文件中加入用户)如下:
1.找到oracle数据库对应的应答文件。
2.切换到Oracle用户,修改对应的应答文件内容并执行相关命令。一、db_install.rsp 安装Oracle数据库软件先进入/Oracle_11g/database目录修改response文件的如下选项:oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oraInventory
ORACLE_HOME=/Oracle_11g/oracle
ORACLE_BASE=/Oracle_11g
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
DECLINE_SECURITY_UPDATES=true
然后执行命令:./runInstaller -ignoreSysPrereqs -ignorePrereq -silent -responseFile /Oracle_11g/database/response/db_install.rsp -debug注意:1.-ignoreSysPrereqs linux上必须加上此项
2.静默安装,如果发现错误 “SEVERE: Email Address Not Specified …….”,需要设置: DECLINE_SECURITY_UPDATES=true执行后出现如下提示:
安装到这里会有两个脚本需要用root用户运行的。打开XShell,以root用户运行这两个脚本。[root@Pet ~]#/oraInventory/orainstRoot.sh[root@Pet ~]# /Oracle_11g/oracle/root.sh待脚本运行完后,Oracle 11g R2数据库软件已经安装完成。
二、netca.rsp 配置监听程序[oracle@XLJ182 database]$ /Oracle_11g/oracle/bin/netca -silent -responseFile /Oracle_11g/database/response/netca.rsp 运行后,出现如下提示:Parsing command line arguments:
Parameter “silent” = true
Parameter “responsefile” = /Oracle_11g/database/response/netca.rsp
Done 免费主机域名parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/Oracle_11g/oracle/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0 如果此处出现类似异常,需要用root权限用户登录服务器,在/etc/hosts文件中添加:IPhostname
三、dbca.rsp 创建数据库修改response文件的如下选项:GDBNAME = “cams”
SID = “cams”
SYSPASSWORD = “**********”
SYSTEMPASSWORD = “**********”
SYSMANPASSWORD = “**********”
DBSNMPPASSWORD = “**********”
CHARACTERSET = “UTF8” –字符集
NATIONALCHARACTERSET = “UTF8” –国家字符集,默认值
然后执行命令:/Oracle_11g/oracle/bin/dbca -silent -cloneTemplate -responseFile /Oracle_11g/database/response/dbca.rsp
注意:如果安装期间出现如下错误:Initializing Java Virtual Machine from /tmp/OraInstall2014-11-27_08-53-23AM/jdk/jre/bin/java. Please wait…./runInstaller: line 92: 11535 Segmentation fault (core dumped) $CMDDIR/install/.oui $*执行:[oracle@XLJ182 database]$ cat runInstaller | tail –n +80 | head –n 50
PATH=/usr/bin:/usr/ccs/bin:$CMDDIR/install
export PATH
fi
# Determine whether there is an existing CRS or not.
# Local is value of local_only in ocr.loc.
# False means there is an existing CRS installation on the system.
if [ -r $OCR_LOC ]; then
LOCAL=`$AWK -F= /$LOCALONLY/'{print $2}’ $OCR_LOC |
$SED ‘y/aeflrstu/AEFLRSTU/’`
fi
case “$BUNDLE” in
db)
# One-click: only if there is no cmd line argument and it’s not on CRS node
if [ $# -gt 0 -o “$LOCAL” = “FALSE” -o
! -r $CMDDIR/install/oneclick.properties ]; then
$CMDDIR/install/.oui $*
else
$CMDDIR/install/.oui -oneclick
fi
;;
client)
$CMDDIR/install/.oui $* CLUSTER_NODES={}
;;
crs)
$CMDDIR/install/.oui $* -formCluster
;;
dv)
$CMDDIR/install/.oui $* -oneclick
;;
dbbundle)
for arg in “$@”
do
arg=`echo $arg | $SED ‘y/ABCDEFGHIJKLMNOPQRSTUVWXYZ/abcdefghijklmnopqrstuvwxyz/ 92行的代码为:$CMDDIR/install/.oui $* -oneclick执行:[oracle@XLJ182 tmp]$ /Oracle_11g/database/install/.oui $* –oneclick
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 30005 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3967 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,
Continue? (y/n) [n] n
User Selected: No
Exiting Oracle Universal Installer, log for this session can be found at /tmp/OraInstall2014-11-27_09-23-40AM/installActions2014-11-27_09-23-40AM.log 解决方案:[oracle@XLJ182 tmp]$ su – root
[root@XLJ182 ~]# export DISPLAY=:0.0
[root@XLJ182 ~]# xhost +
access control disabled, clients can connect from any host
[oracle@XLJ182 oracle]$ /Oracle_11g/database/install/.oui $* –oneclick
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 29995 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3967 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-11-27_09-43-13AM. Please wait …以上是“如何使用应答文件安装Oracle11g数据库”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注云技术行业资讯频道!
这篇文章将为大家详细讲解有关oracle如何创建、刷新物化视图,小编觉得挺实用的,因此分享给大家做个参考,希望大家阅读完这篇文章后可以有所收获。 Create materialized view log on F_RPT_TASK WITH ROWID —…