ORACLE10g102010升级102040已经测试可用.doc

参考 /zyhzsz1/blog/item/79d884fc47878f1f09244d8a.html /2010/03/12/oracle-10-2-0-1%e9%9d%99%e9%bb%98%e5%8d%87%e7%ba%a7%e8%87%b310-2-0-4linux/ /zhou__zhou/archive/2009/10/07/oracle_patch.html 一、root 用户任务unzip p6810189_10204_Linux-x86.zip [root@client1 oracle]# chown oracle.oinstall -R Disk1/ oracle用户[oracle@client1 ~]$ env | grep ORACLE ORACLE_SID=mydb ORACLE_BASE=/usr/local/oracle ORACLE_HOME=/usr/local/oracle/db_1 SQL select * from v$version;获取版本信息BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release .0 - 64bi PL/SQL Release .0 - Production CORE .0 Production TNS for Linux: Version .0 - Production NLSRTL Version .0 - Production SQL select name from v$datafile;获取数据文件信息 NAME -------------------------------------------------------------------------------- /usr/local/oracle/oradata/orcl10g/system01.dbf /usr/local/oracle/oradata/orcl10g/undotbs01.dbf /usr/local/oracle/oradata/orcl10g/sysaux01.dbf /usr/local/oracle/oradata/orcl10g/users01.dbf SQL select member from v$logfile;获取日志文件信息 MEMBER -------------------------------------------------------------------------------- /usr/local/oracle/oradata/orcl10g/redo03.log /usr/local/oracle/oradata/orcl10g/redo02.log /usr/local/oracle/oradata/orcl10g/redo01.log SQL select name from v$controlfile;控制文件信息NAME -------------------------------------------------------------------------------- /usr/local/oracle/oradata/orcl10g/control01.ctl /usr/local/oracle/oradata/orcl10g/control02.ctl /usr/local/oracle/oradata/orcl10g/control03.ctl SQL archive log list 归档模式信息Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 3 Current log sequence 5 停止数据库以及相关服务[oracle@client1 ~]$ emctl stop dbconsole TZ set to US/Eastern OC4J Configuration issue. /usr/local/oracle/db_1/oc4j/j2ee/OC4J_DBConsole_client1_mydb not found. [oracle@client1 ~]$