ORACLE 10.2.0.3升级10.2.0.5.docVIP

ORACLE 10.2.0.3升级10.2.0.5 windows oracle 10.2.0.1 update to 10.2.0.4 补丁p6810189(for single instance) 打补丁之前查看oracle 版本： select * from v$version; select comp_name,version,status from dba_registry ; select version from v$timezone_file; 数据库升级之前考虑因素: 1.数据库为什么要升级,升级是为了解决什么问题 2.数据库升级时需要关闭数据库,最大的允许停机时间是多少 3.数据库的备份方式,是逻辑备份还是物理备份,备份存放地方 4.数据库升级之前一定要做备份.如果数据量不大,最好是逻辑与物理都备 5.数据库是否有使用EM：emctl status dbconsole 6.抓取数据库DDL(包括用户与表空间创建语句）: Set pages 999; Set long 90000 Spool get_ddl.sql SELECT DBMS_METADATA.GET_DDL(USER,STUDENT) FROM DBA_USERS; SELECT SELECT DBMS_METADATA.GET_DDL(USER,||USERNAME ||)from dba_users; FROM DBA_USERS where account_status=OPEN and default_tablespace not in (SYSAUX,SYSTEM,SYS); Spool off 7.WINDOWS系统，查看一个数据库软件上有几个库：services.msc 8.查看数据库及系统语言：REGEDIT NLS_LANG Select * from nls_database_parameters; 9.查看数据量，用户及用户所拥有的权限 Select sum(bytes)/1024/1024/1024 gb from dba_data_files; Select sum(bytes)/1024/1024/1024 gb from dba_segments; 10.查看归档方式: archive log list 11.查看系统，32位还是64位：winver ,systeminfo 12.windows 设置 ：set ORACLE_SID=**; echo %ORACLE_SID%; SET NLS_LANG=AMERICAN_AMERICA.ZHS16GBK SET 查看系统环境变量 1.identify the oracle database installation $ORACLE_HOME\db_1\OPatch\opatch lsinventory -all 2. update oracle time zone definitions 3.shutdown oracle database 4.stop services emctl stop dbconsole isqlplus stop lsnrctl stop 5.backup the system oracle inventory oracle home oracle database 6.install patch set 7.postinstallation tasks (The Pre-Upgrade Information Tool is a SQL script that ships with the new Oracle Database 10g release, and must be copied to and run from the environment of the database being upgraded) describe:database,tablespaces,update/obsolete/deprecated parameters ,components 7.1 run the pre-update information tool startup upgrade spool upgrade_info.log @ORACLE_HOME\rdbms\admin\utlu102i.sql spool off 7.2 lsnrctl start conn sys as sysdba startup upgrade