Centos6.0 Oracle11gR2 静默命令行安装_lmx_20110819

Centos6.0 Oracle11gR2 静默命令行安装

写的比较仓促，可能有些小问题，请各位见谅。

LMX66768 原创。

参考资料

http://blog.csdn.net/leehq/article/details/1429499

http://www.aixchina.net/club/thread-30015-1-1.html

目录结构

/u01/oracle/ora11

/u01/linux.x64_11gR2_database_1of2.zip

/u01/linux.x64_11gR2_database_2of2.zip

unzip 上面zip文件

/u01/database

/oraInventory

Rpm 下载网站推荐：http://rpm.pbone.net/

检查rpm包

rpm -q binutils compat-libstdc++ gcc

gcc-c++

elfutils-libelf elfutils-libelf-devel

glibc-devel

elfutils-libelf-devel-static glibc glibc-common

glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make numactl-devel sysstat unixODBC unixODBC-devel

创建用户组

groupadd oinstall

groupadd dba

useradd -m -g oinstall -G dba -d /u01/oracle oracle

chown -R oracle:oinstall /u01

chown -R oracle:oinstall /oraInventory

修改用户环境

ORACLE_BASE=/u01

ORACLE_HOME=$ORACLE_BASE/oracle/ora11

ORACLE_SID=ora11

PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATH:.

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH

修改静默配置包-附件

vi /u01/database/response/db_install.rsp

静默安装

./runInstaller -ignoreSysPrereqs -ignorePrereq -silent -responseFile

/u01/database/response/db_install.rsp

（得不时回车，不然不会继续..）

最后按提示另开窗口root用户执行指定脚本。

-ignorePrereq # 下面问题解决不了，只能忽略

[FATAL] [INS-13013] Target environment do not meet some mandatory requirements.

安装监听-附件

$ORACLE_HOME/bin/netca /u01/database/response/netca.rsp

启动数据库

sqlplus sys/manager as sysdba

shutdown

startup

修改监听，重启动监听

[oracle@mdw admin]$ cat tnsnames.ora /silent /responseFile

# tnsnames.ora Network Configuration File:

/u01/oracle/ora11/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORA11 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = mdw-1)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ora11)

)

)

lsnrctl stop

lsnrctl start

访问数据库-放到.bash_profile中

alias osql='sqlplus anserdms/anserdms@orc11'

安装数据库实例-附件

vi /u01/database/response/dbca.rsp -cloneTemplate

$ORACLE_HOME/bin/dbca -silent -responseFile

/u01/database/response/dbca.rsp -cloneTemplate

密码为manager

删除工作

$./runInstaller -silent -deinstall -removeallfiles -removeAllPatches

\"REMOVE_HOMES={$ORACLE_HOME}\" -responseFile <安装时使用的应答文件>

附录

我这用的默认的字符集

select userenv('language') from dual;

SIMPLIFIED CHINESE_CHINA.AL32UTF8

配置文件里有改得地方自己找下吧。中文字符集

SIMPLIFIED CHINESE_CHINA.AL32UTF8

或则

如果在查询的表中有中文的时候出现乱码，就是你创建数据库的配置文件设置的问题，可以用以下命令来解决：

SQL>SHUTDOWN IMMEDIATE;

SQL>STARTUP MOUNT EXCLUSIVE;

SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;

SQL>ALTER DATABASE OPEN;

SQL>alter database national character set internal_use utf8;

SQL>alter database character set internal_use zhs16gbk;

SQL>SHUTDOWN immediate;

SQL>startup;

附件