|
|
本帖最后由 吴旭彪 于 2020-8-17 23:41 编辑
- [root@classroom ~]# su - oracle
- [oracle@classroom ~]$ . oraenv
- ORACLE_SID = [oracle] ? +ASM
- The Oracle base remains unchanged with value /u01/app/oracle
- [oracle@classroom ~]$ crsctl status res -t
- --------------------------------------------------------------------------------
- Name Target State Server State details
- --------------------------------------------------------------------------------
- Local Resources
- --------------------------------------------------------------------------------
- ora.DATA.dg ONLINE ONLINE classroom STABLE
- ora.FRA.dg ONLINE ONLINE classroom STABLE
- ora.LISTENER.lsnr ONLINE ONLINE classroom STABLE
- ora.asm ONLINE ONLINE classroom Started,STABLE
- ora.ons OFFLINE OFFLINE classroom STABLE
- --------------------------------------------------------------------------------
- Cluster Resources
- --------------------------------------------------------------------------------
- ora.cdb1.db 1 OFFLINE OFFLINE Instance Shutdown,STABLE
- ora.cssd 1 ONLINE ONLINE classroom STABLE
- ora.diskmon 1 OFFLINE OFFLINE STABLE
- ora.em12rep.db 1 ONLINE ONLINE classroom Open,STABLE
- ora.evmd 1 ONLINE ONLINE classroom STABLE
- ora.orcl.db 1 ONLINE ONLINE classroom Open,STABLE
- --------------------------------------------------------------------------------
- [oracle@classroom ~]$
- ########################################################################################################
- [oracle@classroom ~]$ . oraenv
- ORACLE_SID = [+ASM] ? rcat
- The Oracle base remains unchanged with value /u01/app/oracle
- [oracle@classroom ~]$ sqlplus / as sysdba
- SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 17 22:24:29 2020
- Copyright (c) 1982, 2014, Oracle. All rights reserved.
- Connected to an idle instance.
- SQL> startup
- ORACLE instance started.
- Total System Global Area 1610612736 bytes
- Fixed Size 2924928 bytes
- Variable Size 1157631616 bytes
- Database Buffers 436207616 bytes
- Redo Buffers 13848576 bytes
- Database mounted.
- Database opened.
- SQL> exit
- Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
- With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
- #########################################################################################################
- [oracle@classroom ~]$ cd /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin
- [oracle@classroom admin]$ pwd
- /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin
- [oracle@classroom admin]$ ls utlu121s.sql
- utlu121s.sql
- [oracle@classroom admin]$ sqlplus / as sysdba
- SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 17 22:28:52 2020
- Copyright (c) 1982, 2014, Oracle. All rights reserved.
- Connected to:
- Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
- With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
- SQL> @utlu121s.sql
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- CATCTL REPORT = /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/rcat/upgrade/upg_summary.log
- PL/SQL procedure successfully completed.
- Oracle Database 12.1 Post-Upgrade Status Tool 08-17-2020 22:29:02
- Component Current Version Elapsed Time
- Name Status Number HH:MM:SS
- Oracle Server UPGRADED 12.1.0.2.0 00:08:38
- JServer JAVA Virtual Machine VALID 12.1.0.2.0 00:01:44
- Oracle Workspace Manager VALID 12.1.0.2.0 00:00:45
- OLAP Analytic Workspace VALID 12.1.0.2.0 00:00:13
- OLAP Catalog OPTION OFF 11.2.0.3.0 00:00:00
- Oracle OLAP API VALID 12.1.0.2.0 00:00:16
- Oracle XDK VALID 12.1.0.2.0 00:00:32
- Oracle Text VALID 12.1.0.2.0 00:00:41
- Oracle XML Database VALID 12.1.0.2.0 00:01:26
- Oracle Database Java Packages VALID 12.1.0.2.0 00:00:09
- Oracle Multimedia VALID 12.1.0.2.0 00:01:51
- Spatial UPGRADED 12.1.0.2.0 00:03:44
- Oracle Application Express VALID 4.2.5.00.08 00:18:22
- Final Actions 00:01:23
- Post Upgrade 00:02:39
- Total Upgrade Time: 00:42:49
- PL/SQL procedure successfully completed.
- SQL>
- SQL> --
- SQL> -- Update Summary Table with con_name and endtime.
- SQL> --
- SQL> UPDATE sys.registry$upg_summary SET reportname = :ReportName,
- 2 con_name = SYS_CONTEXT('USERENV','CON_NAME'),
- 3 endtime = SYSDATE
- 4 WHERE con_id = -1;
- 1 row updated.
- SQL> commit;
- Commit complete.
- ######################################################################################
- [oracle@classroom admin]$ ls catuppst.sql
- catuppst.sql
- [oracle@classroom admin]$ sqlplus / as sysdba
- SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 17 23:10:58 2020
- Copyright (c) 1982, 2014, Oracle. All rights reserved.
- Connected to:
- Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
- With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
- SQL> @catuppst.sql
- Session altered.
- Session altered.
- Session altered.
- Session altered.
- TIMESTAMP
- --------------------------------------------------------------------------------
- COMP_TIMESTAMP POSTUP_BGN 2020-08-17 23:11:31
- TIMESTAMP
- --------------------------------------------------------------------------------
- COMP_TIMESTAMP CATREQ_BGN 2020-08-17 23:11:31
- PL/SQL procedure successfully completed.
- catrequtlmg: b_StatEvt = TRUE
- catrequtlmg: b_SelProps = FALSE
- catrequtlmg: b_UpgradeMode = FALSE
- catrequtlmg: b_InUtlMig = FALSE
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- TIMESTAMP
- --------------------------------------------------------------------------------
- COMP_TIMESTAMP CATREQ_END 2020-08-17 23:11:31
- catuppst: Dropping library DBMS_DDL_INTERNAL_LIB
- PL/SQL procedure successfully completed.
- catuppst: Dropping view _CURRENT_EDITION_OBJ_MIG
- PL/SQL procedure successfully completed.
- catuppst: Dropping view _ACTUAL_EDITION_OBJ_MIG
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- This script will migrate the Baseline data on a pre-11g database
- to the 11g database.
- ... ...
- ... Completed Moving the Baseline Data ...
- ... ...
- ... If there are no Move BL Data messages ...
- ... above, then there are no renamed ...
- ... baseline tables in the system. ...
- ... ...
- ... ...
- ... Completed the Dropping of the ...
- ... Renamed Baseline Tables ...
- ... ...
- ... If there are no Drop Table messages ...
- ... above, then there are no renamed ...
- ... baseline tables in the system. ...
- ... ...
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- 0 rows created.
- Commit complete.
- Table created.
- 2 rows created.
- 1 row updated.
- 2 rows updated.
- 0 rows updated.
- Table dropped.
- Commit complete.
- 0 rows updated.
- Commit complete.
- 0 rows updated.
- Commit complete.
- 0 rows updated.
- Commit complete.
- 0 rows created.
- Commit complete.
- 0 rows created.
- Commit complete.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- PL/SQL procedure successfully completed.
- TIMESTAMP
- --------------------------------------------------------------------------------
- COMP_TIMESTAMP POSTUP_END 2020-08-17 23:11:32
- Session altered.
- SQL>
- #########################################################################################
- SQL> @ /u01/app/oracle/cfgtoollogs/rcat/preupgrade/postupgrade_fixups.sql
- Post Upgrade Fixup Script Generated on 2020-08-16 02:03:40 Version: 12.1.0.2 Build: 006
- Beginning Post-Upgrade Fixups...
- **********************************************************************
- Check Tag: OLD_TIME_ZONES_EXIST
- Check Summary: Check for use of older timezone data file
- Fix Summary: Update the timezone using the DBMS_DST package after upgrade is complete.
- **********************************************************************
- Fixup Returned Information:
- INFORMATION: --> Older Timezone in use
- Database is using a time zone file older than version 18.
- After the upgrade, it is recommended that DBMS_DST package
- be used to upgrade the 12.1.0.2.0 database time zone version
- to the latest version which comes with the new release.
- Please refer to My Oracle Support note number 977512.1 for details.
- **********************************************************************
- **********************************************************************
- Check Tag: NOT_UPG_BY_STD_UPGRD
- Check Summary: Identify existing components that will NOT be upgraded
- Fix Summary: This fixup does not perform any action.
- **********************************************************************
- Fixup Returned Information:
- This fixup does not perform any action.
- If you want to upgrade those other components, you must do so manually.
- **********************************************************************
- **********************************************************************
- [Post-Upgrade Recommendations]
- **********************************************************************
- *****************************************
- ******** Fixed Object Statistics ********
- *****************************************
- Please create stats on fixed objects two weeks
- after the upgrade using the command:
- EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
- ^^^ MANUAL ACTION SUGGESTED ^^^
- **************************************************
- ************* Fixup Summary ************
- 2 fixup routines generated INFORMATIONAL messages that should be reviewed.
- *************** Post Upgrade Fixup Script Complete ********************
- PL/SQL procedure successfully completed.
|
|
发表于 2020-8-17 23:28:32
发表于 2020-8-18 10:22:11
