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