Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)
1. Stop all services of oracle并且冷备份数据
[oracle@node19 ~]$ emctl stop dbconsole
[oracle@node19 ~]$ isqlplusctl stop
[oracle@node19 ~]$
[oracle@node19 ~]$ lsnrctl stop
[oracle@node19 ~]$ sqlplus “/as sysdba”
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
[oracle@node19 ~]$ ps -ef|grep oracle
root 13754 32094 0 13:13 pts/1 00:00:00 su – oracle
oracle 13755 13754 0 13:13 pts/1 00:00:00 -bash
oracle 14525 13755 0 13:18 pts/1 00:00:00 ps -ef
oracle 14526 13755 0 13:18 pts/1 00:00:00 grep oracle
[oracle@node19 ~]$ cp -r /db/oracle10g /vol/
检查ORACLE_BASE ORACLE_HOME ORACLE_SID 是正确的。
Step 2: Install the Database Patch Set
用的系统是Centos5.3 ,要把/etc/redhat-release内容改为如下,否则安装包的时候会报错。
Red Hat Enterprise Linux AS release 4
解压p6810189_10204_Linux-x86.zip 之后,按照默认next安装即可。注意DISPLAY 和LANG的设置。
./runinstaller
Starting Oracle Universal Installer…
Checking installer requirements…
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-02-08_01-22-19PM. Please wait …
Step 3 : Upgrade Database
[oracle@node19 ~]$ sqlplus “/as sysdba”
SQL*Plus: Release 10.2.0.4.0 – Production on Mon Feb 8 13:28:53 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> STARTUP UPGRADE; #安装完包后第一次启动
ORACLE instance started.
Total System Global Area 578813952 bytes
Fixed Size 1268752 bytes
Variable Size 369099760 bytes
Database Buffers 205520896 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
SQL>
SQL> SPOOL upgrade_info.log
SQL> @?/rdbms/admin/utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility 05-20-2012 16:25:35
.
**********************************************************************
Database:
**********************************************************************
--> name: JADE
--> version: 10.2.0.1.0
--> compatible: 10.2.0.1.0
--> blocksize: 8192
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 487 MB
.... AUTOEXTEND additional space required: 7 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 401 MB
.... AUTOEXTEND additional space required: 376 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 250 MB
.... AUTOEXTEND additional space required: 10 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 58 MB
.... AUTOEXTEND additional space required: 38 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No update parameter changes are required.
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No obsolete parameters found. No changes are required
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> Oracle Data Mining [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> Oracle OLAP API [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Rule Manager [upgrade] VALID
.
PL/SQL procedure successfully completed.
SQL> SPOOL OFF;
SQL>
SQL>
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql #要持续报个小时左右,耐心等待
..........................................................................................
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP RUL 2012-05-20 16:53:49
DBUA_TIMESTAMP RUL VALID 2012-05-20 16:53:49
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UPGRD_END 2012-05-20 16:53:49
.
Oracle Database 10.2 Upgrade Status Utility 05-20-2012 16:53:49
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:09:56
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:02:41
Oracle XDK VALID 10.2.0.4.0 00:00:29
Oracle Database Java Packages VALID 10.2.0.4.0 00:00:22
Oracle Text VALID 10.2.0.4.0 00:00:20
Oracle XML Database VALID 10.2.0.4.0 00:01:21
Oracle Workspace Manager VALID 10.2.0.4.3 00:00:46
Oracle Data Mining VALID 10.2.0.4.0 00:00:20
OLAP Analytic Workspace VALID 10.2.0.4.0 00:01:49
OLAP Catalog VALID 10.2.0.4.0 00:01:08
Oracle OLAP API VALID 10.2.0.4.0 00:00:44
Oracle interMedia VALID 10.2.0.4.0 00:03:59
Spatial VALID 10.2.0.4.0 00:01:40
Oracle Expression Filter VALID 10.2.0.4.0 00:00:10
Oracle Enterprise Manager VALID 10.2.0.4.0 00:01:33
Oracle Rule Manager VALID 10.2.0.4.0 00:00:09
.
Total Upgrade Time: 00:27:36
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC> The above PL/SQL lists the SERVER components in the upgraded
DOC> database, along with their current version and status.
DOC>
DOC> Please review the status and version columns and look for
DOC> any errors in the spool log file. If there are errors in the spool
DOC> file, or any components are not VALID or not the current version,
DOC> consult the Oracle Database Upgrade Guide for troubleshooting
DOC> recommendations.
DOC>
DOC> Next shutdown immediate, restart for normal operation, and then
DOC> run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL>
SQL> spool off
SQL>
..........................................................................................
SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> STARTUP
ORACLE instance started.
Total System Global Area 578813952 bytes
Fixed Size 1268752 bytes
Variable Size 369099760 bytes
Database Buffers 205520896 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
SQL>
To compile invalid objects
SQL> @?/rdbms/admin/utlrp.sql
SQL> select comp_name, version, status from sys.dba_registry;
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ ------------------------------------------
Oracle Database Catalog Views 10.2.0.4.0 VALID
Oracle Database Packages and Types 10.2.0.4.0 VALID
Oracle Workspace Manager 10.2.0.4.3 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
Oracle Expression Filter 10.2.0.4.0 VALID
Oracle Data Mining 10.2.0.4.0 VALID
Oracle Text 10.2.0.4.0 VALID
Oracle XML Database 10.2.0.4.0 VALID
Oracle Rule Manager 10.2.0.4.0 VALID
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ -------------------------------------
Oracle interMedia 10.2.0.4.0 VALID
OLAP Analytic Workspace 10.2.0.4.0 VALID
Oracle OLAP API 10.2.0.4.0 VALID
OLAP Catalog 10.2.0.4.0 VALID
Spatial 10.2.0.4.0 VALID
Oracle Enterprise Manager 10.2.0.4.0 VALID
17 rows selected.
SQL>exit
ok。
参考:oracle10.2.0.1升级到10.2.0.4报错
更多参考:
the specified nodes are not clusterable
根据rowid删除表中重复的行
Agent process exited abnormally during initialization
一次字符乱码的解决过程
rman实验(一)
rman实验(二)
ORA-00600: internal error code, arguments: [keltnf
ORA-00600: ORA-12012 ORA-08102解决
linux下完全删除oracle
INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory
centos4.8_64上安装oracle10201建库报ORA-12547
EM乱码解决
ORA-31613 Master process DM00 failed during startup
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
ORA-24324 ORA-01041 ORA-03113
centos5.3升级oracle
pdksh-5.2.14-36.el5.i386.rpm
使用rman进行数据库迁移
oracle10.2.0.1升级到10.2.0.4报错
Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)
改oracle的name和dbid
修改oracle实例名
Solaris8上迁移oracle8i---上
Solaris8上迁移oracle8i---下
未备份归档日志导致数据丢失的实验
使用NBU进行数据库迁移
catalog备份数据库
RMAN FORMAT字符串格式化
Error: can not register my instance state - -1
not all alterations performed
The ASM instance configured on the local node is a single-instance ASM
/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared
Initializing the Oracle ASMLib driver: [FAILED]
ORA-00245: control file backup operation failed
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent
模拟恢复参数文件
Interface eth0 checked failed
import server uses ZHS16GBK character set (possible charset conversion)