10g静默安装以及静默升级

chkconfig sendmail off
chkconfig iptables off
chkconfig  avahi-daemon off
关闭selinux:
vi /etc/selinux/config
SELINUX=disabled 
本地YUM
df -h 查看镜像位置
挂载到新路径下：mount /dev/sr0 /mnt
在/etc/yum.repos.d/下，编辑rhel.repo文件


[root@localhost ~]# cd /etc/yum.repos.d/
[root@localhost yum.repos.d]# ls
redhat.repo  rhel-debuginfo.repo  rhel.repo
[root@localhost yum.repos.d]# vi rhel.repo 
[rhel] 
name=rhel 
baseurl=file:///mnt/Server/ 
enabled=1 
gpgcheck=0


[root@localhost yum.repos.d]# yum clean all
安装软件包：
[root@localhost yum.repos.d]# yum install yum install binutils compat-libstdc++-33 elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel libXp -y
修改内核参数 
#vi /etc/sysctl.conf 
增加下面的内容到文件中： 
kernel.shmmni = 4096 
kernel.sem = 250 32000 100 128 
fs.file-max = 101365
net.ipv4.ip_local_port_range = 9000 65500 
net.core.rmem_default=1048576 
net.core.rmem_max=1048576 
net.core.wmem_default=262144 
net.core.wmem_max=262144 
运行下面的命令使得内核参数生效： 
/sbin/sysctl –p 
建立安装Oracle需要的用户，组，及目录 
a)新增组和用户： 
groupadd oinstall 
groupadd dba 
useradd -g oinstall -G dba oracle 
passwd oracle 
b) 创建Oracle的安装目录，并把权限付给oracle用户： 
mkdir -p /u01/app/oracle/product/10.2.0/db_1 
chown -R oracle.oinstall /u01 
设置oracle用户的shell limit 
#vi /etc/security/limits.conf 
增加下面的内容到文件 /etc/security/limits.conf 文件中： 
oracle soft nproc 2047 
oracle hard nproc 16384 
oracle soft nofile 1024 
oracle hard nofile 65536
增加下面的内容到文件 /etc/pam.d/login 中，使shell limit生效： 
session required /lib/security/pam_limits.so 
配置oracle用户的环境变量 
登录到oracle 用户并且配置环境变量，编辑/home/oracle目录下的.bash_profile文件 
vi .bash_profile 
增加下面的内容到文件 .bash_profile  
# Oracle Settings 
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/BIN
修改完用：source .bash_profile生效。
####################################################################################
*安装数据库软件
修改enterprise.rsp
[oracle@orcl response]$ pwd
/u01/database/response
[oracle@orcl response]$ ls
custom.rsp  dbca.rsp  emca.rsp  enterprise.rsp  netca.rsp  standard.rsp


 35 UNIX_GROUP_NAME="oinstall"
 62 ORACLE_HOME="/u01/app/oracle/10.2.0/db_1"
 70 ORACLE_HOME_NAME="OraDbHome1"
 351 COMPONENT_LANGUAGES={"en,zh_CN"}
 384 s_nameForDBAGrp="dba"
 392 s_nameForOPERGrp="oper"
 422 n_configurationOption=3
 
 ./runInstaller -ignoreSysPrereqs -silent -responseFile /u01/database/response/enterprise.rsp
 
*配置监听
$netca /silent /responsefile /u01/database/response/netca.rsp


*建库
修改dbca.rsp


78 GDBNAME = "orcl10g.us.oracle.com"
88 SID = "orcl10g"
108 TEMPLATENAME = "General Purpose"
355 #CHARACTERSET = "US7ASCII"  ---"ZHS16GBK"
477 SOURCEDB = "myhost:1521:orcl"
521 SOURCEDB = "orcl"
575 SOURCEDB = "orcl"
620 GDBNAME = "orcl10i.us.oracle.com"
647 SOURCEDB = "orcl"
823 DB_UNIQUE_NAME = "orcl10g.us.oracle.com"
890 DB_UNIQUE_NAME = "orcl10g.us.oracle.com"
900 INSTANCENAME = "orcl10g"




$ dbca -silent -responseFile /u01/database/response/dbca.rsp
**若报错：Template General Purpose does not exist. Please specify an existing template for database creation.
则将dbca.rsp中TEMPLATENAME = "General Purpose" 修改为  TEMPLATENAME = "General_Purpose.dbc"

修改为归档模式

shutdown immediate;
startup mount;
alter database archivelog;
alter system set log_archive_dest_1='location=*********';
alter database open;

#########################################################################
#########################################################################
Oracle10.2.0.1升级10.2.0.5
查询timezone问题
SELECT version FROM v$timezone_file;
2


  select c.owner || '.' || c.table_name || '(' || c.column_name || ') -' ||
 c.data_type || ' ' col
     from dba_tab_cols c, dba_objects o
    where c.data_type like '%TIME ZONE'
       and c.owner=o.owner
      and c.table_name = o.object_name
      and o.object_type = 'TABLE'
   order by col
   /

关闭数据库
shutdown immediate
关闭监听
lsnrctl stop  
备份数据库的软件目录


[root@test ~]# su - oracle
[oracle@test ~]$ env |grep ORA
ORACLE_SID=csdb
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1


cp -a /u01/app/oracle/product/10.2.0/db_1 /u01/app/oracle/product/10.2.0/db_1.bak


解压10.2.0.5补丁程序
安装补丁程序./runInstaller
修改[oracle@orcl response]$ pwd
/tmp/Disk1/response
[oracle@orcl response]$ ls
patchset.rsp


45 UNIX_GROUP_NAME="oinstall"
87 ORACLE_HOME="/u01/app/oracle/product/10.2.0/db_1"
99 ORACLE_HOME_NAME="OraDbHome1"
417 OUI_HOSTNAME=orcl
489 COMPONENT_LANGUAGES={"en,zh_CN"}
603 DECLINE_SECURITY_UPDATES=true


[oracle@orcl Disk1]$ ./runInstaller -ignoreSysPrereqs -silent -responseFile /tmp/Disk1/response/patchset.rsp 


升级检查
1. Start the database in the UPGRADE mode:
2. SQL> STARTUP UPGRADE;
3. Set the system to spool results to a log file for later analysis:
4. SQL> SPOOL upgrade_info.log 
5. Run the Pre-Upgrade Information Tool:
6. SQL> @?/rdbms/admin/utlu102i.sql
7. Turn off the spooling of script results to the log file:
8. SQL> SPOOL OFF


shutdown immediate


更新数据字典
1. SQL> STARTUP UPGRADE;
2. SQL> SPOOL patch.log
3. SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
编译无效对象
1. SQL> SHUTDOWN IMMEDIATE
2. SQL> STARTUP
3. SQL> @?/rdbms/admin/utlrp.sql