一, 软件清单
1. operator system
Red Hat ES4 update 6(64b)
2. Oracle 软件
Oracle Database 10g Enterprise Editon Release 10.2.0.1.0
Oracle Database 10g Release 2 (10.2.0.4) Patch set 4 for Linux X86
二. 服务器hosts的文件内容
127.0.0.1 UAT1 localhost.localdomain localhost
192.168.144.221 UAT1
三. 硬件要求:
1. 内存 grep Mem Total/proc/meminfo >2G
2. SWAP 分区 grep Swap Total/proc/meminfo >32G
3. 软件所需要空间 df -h >4G
4. 临时文件夹 / tmp df -h/tmp >2G
四. 创建用户和组
1. /usr/sbin/groupadd oinstall
2. /usr/sbin/groupadd dba
3. /usr/sbin/useradd -g oinstall -G dba Oracle
4. /usr/sbin/passwd Oracle
# su - Oracle
# cd
vi .bash_profile
# 添加以下内容:
PATH=$PATH:$HOME/bin
export PATH
export TMP=/tmp
unset USERNAME
ORACLE_BASE=/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_HOME
export ORACLE_SID=uweb
PATH=/usr/sbin:$PATH
PATH=$ORACLE_HOME/bin:$PATH
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export CLASSPATH
检查系统包是否缺失: (以下安装必须)
#rpm -qa | grep glibc
#rpm -qa | grep make
#rpm -qa | grep binutils
#rpm -qa | grep openmotif
#rpm -qa | grep openmotif-devel
#rpm -qa | grep openmotif21
#rpm -qa | grep setarch
#rpm -qa | grep compat-db
#rpm -qa | grep compat-gcc
#rpm -qa | grep compat-gcc-c++
#rpm -qa | grep compat-libstdc++
#rpm -qa | grep compat-libstdc++-devel
#rpm -qa | grep compat-glibc
#rpm -qa | grep gnome-libs
#rpm -qa | grep libstdc++
#rpm -qa | grep gcc
#rpm -qa | grep pdksh
#rpm -qa | grep sysstat
#rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' compat-libstdc++-33
五. ./runstaller
==============================================================================
六. 安装补丁包.10.2.0.4
Oracle 补丁升级10.2.0.1---10.2.0.4
我想把Oracle10g 10.2.0.1升级到 10.2.0.4 补丁已经获取到了， 补丁文件名：p6810189_10204_Win32 .
select * from v$version;
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
1) 冷备份数据库
2) 运行安装补丁程序
--如果没有创建数据库,升级就结束了,如果升级已经创建了数据库的数据库,需要执行下面的操作
3) startup upgrade; lsnrctl start
3.1) 修改java_pool_size / large_pool_size=150M
4) 运行脚本@rdbms/admin/catupgrd.sql
5) shutdown immediate
6) startup
7) 运行脚本@rdbms/admin/utlrp.sql
8) 其它升级后工作
如果用到了rman catalog，那么得升级catalog：
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;
运行changePerm.sh放宽新建目录和文件的权限，使其它客户端能访问：
$ cd $ORACLE_HOME/install
$ ./changePerm.sh
9) --察看数据库安装的组件、版本、状态:
col comp_name format a30
col version format a30
col status format a10
SELECT comp_name, version, status FROM dba_registry;
COMP_NAME VERSION STATUS
------------------------------ ---------- ---------- ------------
Oracle Enterprise Manager 10.2.0.4.0 VALID
Oracle interMedia 10.2.0.4.0 VALID
Oracle XML Database 10.2.0.4.0 VALID
Oracle Expression Filter 10.2.0.4.0 VALID
Oracle Rule Manager 10.2.0.4.0 VALID
Oracle Workspace Manager 10.2.0.4.3 VALID
Oracle Database Catalog Views 10.2.0.4.0 VALID
Oracle Database Packages and Types 10.2.0.4.0 VALID
JServer JAVA Virtual Machine 10.2.0.4.0 VALID
Oracle XDK 10.2.0.4.0 VALID
Oracle Database Java Packages 10.2.0.4.0 VALID
===end===
================================================================================
ＱＡ ：
① 操作系统验证不通过 check operator system version: must be redhat_3, Suse_9 radhat_4 等.
==> vi /Disk1/install/oraparam.ini 加入redhat_5 即可.
②. *.cpio 压缩文件解压:
==> cpio -idcmv < test.cpio
③.Error in wrintting to file '/oracle/product/10.2.0/db_1/bin/sqlplus' [sqlplus test file busy ]\
==> 找到该进程,杀死该进程即可.
ps -ef|grep sqlplus
kill -9 16258
④.
1、查看数据库版本
SQL> select banner from .v$version;
BANNER
----------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
2、查看安装了哪些选项
SQL> col PARAMETER format a60
SQL> col VALUE format a10
SQL> select * from v$option;
PARAMETER VALUE
------------------------------------------------------------ ----------
Partitioning TRUE
Objects TRUE
Parallel Server FALSE
Advanced replication TRUE
Bit-mapped indexes TRUE
Connection multiplexing TRUE
Connection pooling TRUE
Database queuing TRUE
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Parallel backup and recovery TRUE
PARAMETER VALUE
------------------------------------------------------------ ----------
Parallel execution TRUE
Parallel load TRUE
Point-in-time tablespace recovery TRUE
Fine-grained access control TRUE
N-Tier authentication/authorization TRUE
Function-based indexes TRUE
Plan Stability TRUE
Online Index Build TRUE
Coalesce Index TRUE
Managed Standby TRUE
Materialized view rewrite TRUE
PARAMETER VALUE
------------------------------------------------------------ ----------
Materialized view warehouse refresh TRUE
Database resource manager TRUE
Spatial TRUE
Visual Information Retrieval TRUE
Export transportable tablespaces TRUE
Transparent Application Failover TRUE
Fast-Start Fault Recovery TRUE
Sample Scan TRUE
Duplexed backups TRUE
Java FALSE
OLAP Window Functions TRUE
已选择33行。
SQL> set head off feed off pages 0 serveroutput on
SQL> begin
2 dbms_output.put_line('Port String: '||dbms_utility.port_string);
3 end;
4 /
Port String: IBMPC/WIN_NT-8.1.0
==========================================
⑤.
Linux下完全卸载ORACLE 10G的方法
1. 运行 $ORACLE_HOME/bin/localconfig delete
2. rm -rf $ORACLE_BASE/*
3. rm -f /etc/oraInst.loc /etc/oratab
4. rm -rf /etc/oracle
5. rm -f /etc/inittab.cssd
6. rm -f /usr/local/bin/coraenv /usr/local/bin/dbhome /usr/local/bin/oraenv
7. 删除oracle用户和组。
此方法同样适用与AIX系统，已经测试，其他平台没有验证过。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22578826/viewspace-663043/ ，如需转载，请注明出处，否则将追究法律责任。
