Změna nastavení v závislosti na skriptu utlu112i
!!! Důležité
V případě, že není aplikovaný DST patch verze 4. Nepujde spustit upgrade scriptSQL> @d:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\catupgrd.sqlDOC>#######################################################################DOC>#######################################################################DOC># TO_NUMBER(value$) != (SELECT tz_version from registry$database)) *ERROR at line 6:ORA-00942: table or view does not existNavíc budete muset začit o začátku, tedy od zálohy na zdrojovém serveru.
Přidání SYSAUX tablespacu
SQL> CREATE TABLESPACE sysaux DATAFILE ‘f:\orcl\sysaux01.dbf’ SIZE 500M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE;Tablespace created.
Zvětšení TEMP tablespace
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE ‘f:\orcl\TEMP01.DBF’ SIZE 110M;Tablespace altered.
Spuštění upgrade scriptů
Dle dokumentace.http://download.oracle.com/docs/cd/E11882_01/server.112/e17222/upgrade.htm#i1011600
UpgradeSQL> @d:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\catupgrd.sqlDOC>#######################################################################DOC>#######################################################################DOC>DOC> The above sql script is the final step of the upgrade. PleaseDOC> review any errors in the spool log file. If there are any errors inDOC> the spool file, consult the Oracle Database Upgrade Guide forDOC> troubleshooting recommendations.DOC>DOC> Next restart for normal operation, and then run utlrp.sql toDOC> recompile any invalid application objects.DOC>DOC> If the source database had an older time zone version prior toDOC> upgrade, then please run the DBMS_DST package. DBMS_DST will upgradeDOC> TIMESTAMP WITH TIME ZONE data to use the latest time zone file shippedDOC> with Oracle.DOC>DOC>#######################################################################DOC>#######################################################################DOC>#KontrolaSQL> @d:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlu112s.sql.Oracle Database 11.2 Post-Upgrade Status Tool 03-09-2011 11:45:39Component Status Version HH:MM:SSOracle Server. VALID 11.2.0.2.0 00:18:17JServer JAVA Virtual Machine. VALID 11.2.0.2.0 00:07:11Oracle Workspace Manager. VALID 11.2.0.2.0 00:02:13Oracle XDK. VALID 11.2.0.2.0 00:03:39Oracle Text. VALID 11.2.0.2.0 00:07:41Oracle XML Database. VALID 11.2.0.2.0 00:07:45Oracle Database Java Packages. VALID 11.2.0.2.0 00:00:18Oracle Multimedia. VALID 11.2.0.2.0 00:06:46Spatial. VALID 11.2.0.2.0 00:17:20Gathering Statistics. 00:02:54Total Upgrade Time: 01:15:17PL/SQL procedure successfully completed.
Post upgrade skript@d:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\catuppst.sql
Kompilace objektů@d:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlrp.sqlSELECT distinct object_name FROM dba_invalid_objects;
Krok 6 – Kontrola cílové databáze
d:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN>sqlplus sys@orcl as sysdbaSQL*Plus: Release 11.2.0.2.0 Production on Fri Mar 11 13:26:31 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.Enter password:Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> show parameter instanceNAME TYPE VALUE———————————— ———– ——————————active_instance_count integercluster_database_instances integer 1instance_groups stringinstance_name string orclinstance_number integer 0instance_type string RDBMSopen_links_per_instance integer 4parallel_instance_group stringparallel_server_instances integer 1SQL> select status from v$instance;STATUS————OPEN