CentOS 5.5命令行安装Oracle 10G(二)

2014-11-24 18:03:14 · 作者: · 浏览: 3
以下参数配置:


INSTALL_TYPE=""custom"" 安装的类型


LISTENER_NUMBER=1 监听器数量


LISTENER_NAMES={"LISTENER"} 监听器的名称列表


LISTENER_PROTOCOLS={"TCP;1521"} 监听器使用的通讯协议列表


LISTENER_START=""LISTENER"" 监听器启动的名称


运行安装命令:


$ORACLE_HOME/bin/netca /silent /responseFile /home/oracle/database/response/netca.rsp


注意:在此处可能会有错误 oracle 需要的软件包不全。请根据 1 中列出的软件包,确保所有的软件包都已经正确安装( 2 ) 6 中对 gennttab 文件的修改不正确,本人就是没有去掉 n 后的空格导致了该错误。


15. 修改 dbstart


vi $ORACLE_HOME/bin/dbstart


ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle


改为:


ORACLE_HOME_LISTNER=$ORACLE_HOME


确保数据库启动时,网络监听器同时启动。


16. 安装数据库实例


编辑 Oracle 安装源文件夹 response 目录下的 dbca.rsp 应答文件:


vi /home/oracle/database/response/dbca.rsp


根据自己的需要修改下列参数:


GDBNAME = “ orcl10g ” # 数据库全局名称


SID = “ ora ” # 数据库的 SID


SYSPASSWORD = “ sys ” # SYS 用户的初始密码


SYSTEMPASSWORD = ” sys ” #SYSTEM 用户的初始密码


CHARACTERSET = “ ZHS16GBK ” # 数据库字符集(中文为 ZHS16GBK )


NATIONALCHARACTERSET = ” ZHS16GBK ” # 数据库国家字符集


运行安装命令:


$ORACLE_HOME/bin/dbca -silent -responseFile /home/oracle/database/response/dbca.rsp -cloneTemplate


数据库创建成功后需要修改一些信息:


vi /etc/oratab


ora10g:/opt/oracle/product/10.2.0.1/db_1:N


改为:


ora10g:/opt/oracle/product/10.2.0.1/db_1:Y


保证数据库实例能自动启动。


17. 启动数据库实例


$ORACLE_HOME/bin/dbstart


18. 测试


sqlplus "/as sysdba"


19. 配置 EM 资料库,数据库和监听都必须已经启动并正常工作


配置 dbcontrol


[oracle@oracle10 ~]$ emca -config dbcontrol db


STARTED EMCA at Oct 27, 2007 9:33:48 AM


EM Configuration Assistant, Version 10.2.0.1.0 Production


Copyright (c) 2003, 2005, Oracle. All rights reserved.


Enter the following information:


Database SID: orcl


Database Control is already configured for the database orcl


You have chosen to configure Database Control for managing the database orcl


This will remove the existing configuration and the default settings and perform a fresh configuration


Do you wish to continue [yes(Y)/no(N)]: Y


Listener port number: 1521


Password for SYS user:


Password for DBSNMP user:


Password for SYSMAN user:


Email address for notifications (optional):


Outgoing Mail (SMTP) server for notifications (optional):


-----------------------------------------------------------------


You have specified the following settings


Database ORACLE_HOME ................ /opt/oracle/product/10.2.0/Database


Database hostname ................ oracle10


Listener port number ................ 1521


Database SID ................ orcl


Email address for notifications ...............


Outgoing Mail (SMTP) server for notifications ...............


-----------------------------------------------------------------


Do you wish to continue [yes(Y)/no(N)]: Y


Oct 27, 2007 9:35:12 AM oracle.sysman.emcp.EMConfig perform


INFO: This operation is being logged at /opt/oracle/product/10.2.0/Database/cfgtoollogs/emca/orcl/emca_2007-10-27_09-33-46-AM.log.


Oct 27, 2007 9:35:33 AM oracle.sysman.emcp.util.DBControlUtil stopOMS


INFO: Stopping Database Control (this may take a while) ...


Oct 27, 2007 9:36:39 AM oracle.sysman.emcp.ParamsManager getLocalListener


WARNING: Error retrieving listener for oracle10


Oct 27, 2007 9:36:54 AM oracle.sysman.emcp.util.DBControlUtil startOMS


INFO: Starting Database Control (this may take a while) ...


Oct 27, 2007 9:39:51 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration


INFO: Database Control started successfully


Oct 27, 2007 9:39:53 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration


INFO: >>>>>>>>>>> The Database Control URL is http://oracle10:5500/em <<<<<<<<<<<


Enterp