Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) [ID 1503653.1]
Minimum version of the database that can be directly upgraded to Oracle 12c Release 1 (12.1)
Source Database Target Database
10.2.0.5 12.1.x
11.1.0.7 12.1.x
11.2.0.2 or higher 12.1.x
Requirements and recommendations for Source database
• Either take a cold or hot backup of the source database (advisable to have cold backup).
a) Perform Cold Backup
(or)
b) Take a backup using RMAN
Connect to RMAN:
rman "target / nocatalog"
RUN
{
ALLOCATE CHANNEL chan_name TYPE DISK;
BACKUP DATABASE FORMAT '<db_backup_directory>%U' TAG before_upgrade;
BACKUP CURRENT CONTROLFILE TO '<controlfile_backup_directory>';
}
Below is a SQL*Plus script that will list all objects that have been created in both the SYS and SYSTEM schema:
SQL> column object_name format a30
select object_name, object_type
from dba_objects
where object_name||object_type in
(select object_name||object_type
from dba_objects
where owner = 'SYS')
and owner = 'SYSTEM';
If the list of objects is large then you may want to use the following SQL*Plus script to automatically generate an SQL script that contains the appropriate DROP commands:
set pause off
set heading off
set pagesize 0
set feedback off
set verify off
spool dropsys.sql
select 'DROP ' || object_type || ' SYSTEM.' || object_name || ';'
from dba_objects
where object_name||object_type in
(select object_name||object_type
from dba_objects
where owner = 'SYS')
and owner = 'SYSTEM';
spool off
exit
ORA-1418 (specified index does not exist):
This occurs because the table that the index was created on has already been dropped which also drops the index. When the script tries to drop the index it is no longer there and thus the ORA-1418 error. You can safely ignore this error.
Install 12C software on different location
Check for the integrity of the source database.
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql) [ID 556610.1]
Download and save the script as dbupgdiag.sql. The script needs no additional configuration
SQL> alter session set nls_language='American';
SQL> @dbupgdiag.sql
Enter location for Spooled output:
Enter value for 1: /tmp
SQL> @utrlrp.sql
#############Pre-Upgrade Steps################
How to Download and Run Oracle's Database Pre-Upgrade Utility [ID 884522.1]
Copy the Pre-Upgrade Information Tool script preupgrd.sql and utluppkg.sql from the Oracle Database 12c Release 1 (12.1)
Run the new Pre-Upgrade Information Tool. For example, if you copied preupgrd.sql to the /admin directory of the source Oracle Home:
SQL> @/u01/oinstall/product/12.1.1/rdbms/admin/preupgrd.sql
SQL> @/u01/oinstall/product/12.1.1/rdbms/admin/utluppkg.sql
SQL> ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE;
SQL> show processes parameter processes;
SQL> @/u01/oinstall/product/12.1.1/rdbms/admin/emremove.sql
SQL> create pfile from spfile;
SQL> @/u01/oinstall/product/11.2.0/olap/admin/catnoamd.sql
SQL> EXECUTE dbms_stats.gather_dictionary_stats;
SQL> @/u01/oinstall/product/11.2.0/cfgtoollogs/MUTH/preupgrade/preupgrade_fixups.sql
##############Deprecated CONNECT Role#############
After upgrading to Oracle Database 12c Release 1 (12.1) from INDIRECT database upgrade release like Oracle Database9i Release 2 (9.2) or Oracle Database 10g Release 1 (10.1), the CONNECT role has only the CREATE SESSION privilege; the other privileges granted to the CONNECT role in earlier releases are revoked during the upgrade. To identify which users and roles in your database are granted the CONNECT role, use the following query:
SQL> SELECT grantee FROM dba_role_privs
WHERE granted_role = 'CONNECT' and
grantee NOT IN (
'SYS', 'OUTLN', 'SYSTEM', 'CTXSYS', 'DBSNMP',
'LOGSTDBY_ADMINISTRATOR', 'ORDSYS',
'ORDPLUGINS', 'OEM_MONITOR', 'WKSYS', 'WKPROXY',
'WK_TEST', 'WKUSER', 'MDSYS', 'LBACSYS', 'DMSYS',
'WMSYS', 'EXFSYS', 'SYSMAN', 'MDDATA',
'SI_INFORMTN_SCHEMA', 'XDB', 'ODM');
SQL> SELECT GRANTEE,PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE ='CONNECT';
#################Dependencies on Network Utility Packages #############
Execute the following query
SQL> SELECT * FROM DBA_DEPENDENCIES
WHERE referenced_name IN ('UTL_TCP','UTL_SMTP','UTL_MAIL','UTL_HTTP','UTL_
INADDR','DBMS_LDAP')
AND owner NOT IN ('SYS','PUBLIC','ORDPLUGINS');
###########Database Links with Passwords from Earlier Releases#############
SQL> SELECT 'CREATE '||DECODE(U.NAME,'PUBLIC','public ')||'DATABASE LINK '||CHR(10)
||DECODE(U.NAME,'PUBLIC',Null, 'SYS','',U.NAME||'.')|| L.NAME||chr(10)
||'CONNECT TO ' || L.USERID || ' IDENTIFIED BY "'||L.PASSWORD||'" USING
'''||L.HOST||''''
||chr(10)||';' TEXT
FROM SYS.LINK$ L, SYS.USER$ U
WHERE L.OWNER# = U.USER#;
###############Optimizer Statistics ###################
Oracle recommends collecting statistics the night before starting the upgrade to decrease the amount of downtime
To decrease the amount of downtime incurred when collecting statistics, Oracle recommends to collect statistics prior to performing the actual database upgrade.
As of Oracle Database 10g Release 1 (10.1), Oracle recommends that you use the DBMS_STATS.GATHER_DICTIONARY_STATS procedure to gather these statistics. For example, you can enter the following:
SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
Verify That Materialized View Refreshes Have Completed Before Upgrading
Before upgrading Oracle Database, you must wait until all materialized views have completed refreshing.
Run the following query to determine if there are any materialized view refreshes still in progress:
SQL> select s.obj#,o.obj#,s.containerobj#,lastrefreshdate,pflags,xpflags,o.name,o.owner#, bitand(s.mflags, 8) from obj$ o, sum$ s
where o.obj# = s.obj# and o.type# = 42 AND bitand(s.mflags, 8) = 8;
Ensure That No Files Need Media Recovery Before Upgrading
Make ensure that there are no files requiring media recovery by executing the following query
SQL> SELECT * FROM v$recover_file;
no rows selected
Ensure That No Files Are in Backup Mode Before Upgrading
Execute the following query to verify that No Files in backup mode when upgrading Oracle Database
SQL> SELECT * FROM v$backup WHERE status != 'NOT ACTIVE';
no rows selected
Resolve Outstanding Distributed Transactions Before Upgrading
To resolve outstanding distributed transactions:
1. Issue the following statement:
SQL> SELECT * FROM dba_2pc_pending;
no rows selected
If the query in the previous step returns any rows, then issue the following
statements:
SQL> SELECT local_tran_id FROM dba_2pc_pending;
SQL> EXECUTE dbms_transaction.purge_lost_db_entry('');
SQL> COMMIT;
###########Purge the Database Recycle Bin Before Upgrading :#############
To empty the database recycle bin, issue the following command:
SQL> PURGE DBA_RECYCLEBIN;
DBA Recyclebin purged.
NOTE : The database recycle bin must be empty during the upgrade process to avoid possible ORA-00600 errors and to minimize the upgrade time.
##########Synchronize the Standby Database with the Primary Database When Upgrading ############
To check if a standby database exists and to synchronize it:
SQL> SELECT SUBSTR(value,INSTR(value,'=',INSTR(UPPER(value),'SERVICE'))+1)
FROM v$parameter
WHERE name LIKE 'log_archive_dest%' AND UPPER(value) LIKE 'SERVICE%';
Disable all batch and cron jobs
For jobs initiated by Oracle then packages DBMS_JOB, DBMS_SCHEDULER can be used.
For cron jobs (external jobs controlled at the OS level) then this is a task for your Unix administrator.
See also:
Note 404238.1 : How to Disable an Entry from DBMS_SCHEDULER
Note 1335741.1 : How To Stop A Running Job Using DBMS_JOB
Note 67695.1 : PROCEDURE DBMS_JOB.BROKEN Specification
############Verify SYS and SYSTEM Default tablespace ############
SQL> SELECT username, default_tablespace
FROM dba_users
WHERE username in ('SYS','SYSTEM');
If DEFAULT_TABLESPACE is anything other than SYSTEM tablespace, modify the default tablespace for user SYS and SYSTEM to SYSTEM by using the command below:
SQL> ALTER user SYS default tablespace SYSTEM;
SQL> ALTER user SYSTEM default tablespace SYSTEM;
#############Verify the existance of the AUD$ tables################
Ensure that if the aud$ table exists that it is in the SYS schema and in the SYSTEM tablespace.
SQL> SELECT owner,tablespace_name
FROM dba_tables
WHERE table_name='AUD$';
############Check whether database has any externally authenticated SSL users###########
Execute the following query
SQL> SELECT name FROM sys.user$
WHERE ext_username IS NOT NULL
AND password = 'GLOBAL';
Location of datafiles, redo logs and control files
Note the location of datafiles, redo logs and control files. Also take a backup of all configuration files like listener.ora, tnsnames.ora, etc. from $ORACLE_HOME.
SQL> SELECT name FROM v$controlfile;
SQL> SELECT file_name FROM dba_data_files;
SQL> SELECT group#, member FROM v$logfile;
###########Remove Enterprise Manager Database Control repository :#################
Enterprise Manager Database Control is superseded in 12c by Oracle Enterprise Manager Express .
Therefore no repository is needed anymore .
Remove Enterprise Manager Database Control repository MANUALLY using the following command
Note : You will get the emremove.sql script in the Oracle 12c home .
Copy the emremove.sql script from the 12c $ORACLE_HOME/rdbms/admin to the source $ORALCE_HOME/rdbms/admin and then execute on the source database prior to upgrade.
SQL> @/u01/oinstall/product/12.1.1/rdbms/admin/emremove.sql
################Run olspreupgrade.sql :#################
If OLS(Lable Security) and/or DV ( Database Vault) was already in the database prior to the upgrade then execute the following steps on Source database prior to upgrade
Note : You will get the olspreupgrade.sql script in the Oracle 12c home .
Copy the olspreupgrde.sql script from the 12c $ORACLE_HOME/rdbms/admin to the source $ORALCE_HOME/rdbms/admin and then execute on the source database prior to upgrade.
SQL> @/u01/oinstall/product/12.1.1/rdbms/admin/olspreupgrade.sql
##########Copy Pfile from 11.2.0.3 oracle home to 12c Oracle home###############
[oinstall@arjun dbs]$ cd /u01/oinstall/product/12.1.1/dbs
[oinstall@arjun dbs]$ cp ../../11.2.0/dbs/initMUTH.ora .
[oinstall@arjun dbs]$lsnrctl stop MUTH
##########Copy Tnsnames and Listner names from 11.2.0.3 Oracle Home###############
[oinstall@arjun admin]$ cp -r ../../../11.2.0/network/admin/tnsnames.ora .
[oinstall@arjun admin]$ cp -r ../../../11.2.0/network/admin/listener.ora .
[oinstall@arjun admin]$ emctl stop dbconsole
######## Shut Down your database ##########
[oinstall@arjun admin]$ sqlplus "/as sysdba"
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[oinstall@arjun admin]$export ORACLE_HOME=/u01/oinstall/product/12.1.1
[oinstall@arjun admin]$export ORACLE_SID=MUTH
[oinstall@arjun admin]$export PATH=$ORACLE_HOME/bin:$PATH
######### Listener Configuration #########
[oinstall@arjun admin]$vi /u01/oinstall/product/12.1.1/network/admin/listener.ora # Change Oracle Home location
[oinstall@arjun admin]$ lsnrctl start MUTH
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 16-JUL-2013 09:28:43
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/oinstall/product/12.1.1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.1.0 - Production
System parameter file is /u01/oinstall/product/12.1.1/network/admin/listener.ora
Log messages written to /u01/oinstall/diag/tnslsnr/arjun/muth/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arjun.bangalore.bedford.local)(PORT=1550)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1550)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=arjun.bangalore.bedford.local)(PORT=1550)))
STATUS of the LISTENER
------------------------
Alias MUTH
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 16-JUL-2013 09:28:43
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oinstall/product/12.1.1/network/admin/listener.ora
Listener Log File /u01/oinstall/diag/tnslsnr/arjun/muth/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arjun.bangalore.bedford.local)(PORT=1550)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1550)))
Services Summary...
Service "MUTH" has 1 instance(s).
Instance "MUTH", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oinstall@arjun admin]$ orabase
/u01/oinstall
########Upgrading Database to 12cR1##########
[oinstall@arjun admin]$ sqlplus "/as syss dba"
SQL*Plus: Release 12.1.0.1.0 Production on Tue Jul 16 09:31:38 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1670221824 bytes
Fixed Size 2289064 bytes
Variable Size 570425944 bytes
Database Buffers 1090519040 bytes
Redo Buffers 6987776 bytes
Database mounted.
Database opened.
SQL> exit
[oinstall@arjun admin]$ cd $ORACLE_HOME/rdbms/admin
[oinstall@arjun admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl -n 6 -l $ORACLE_HOME/diagnostics catupgrd.sql
Analyzing file catupgrd.sql
Log files in /u01/oinstall/product/12.1.1/diagnostics
14 scripts found in file catupgrd.sql
Next path: catalog.sql
32 scripts found in file catalog.sql
Next path: catproc.sql
37 scripts found in file catproc.sql
Next path: catptabs.sql
61 scripts found in file catptabs.sql
Next path: catpdbms.sql
205 scripts found in file catpdbms.sql
Next path: catpdeps.sql
77 scripts found in file catpdeps.sql
Next path: catpprvt.sql
260 scripts found in file catpprvt.sql
Next path: catpexec.sql
26 scripts found in file catpexec.sql
Next path: cmpupgrd.sql
16 scripts found in file cmpupgrd.sql
[Phase 0] type is 1 with 1 Files
catupstr.sql
[Phase 1] type is 1 with 3 Files
cdstrt.sql cdfixed.sql cdcore.sql
[Phase 2] type is 1 with 1 Files
ora_restart.sql
[Phase 3] type is 2 with 18 Files
cdplsql.sql cdsqlddl.sql cdmanage.sql cdtxnspc.sql
cdenv.sql cdrac.sql cdsec.sql cdobj.sql
cdjava.sql cdpart.sql cdrep.sql cdaw.sql
cdsummgt.sql cdtools.sql cdexttab.sql cddm.sql
catldr.sql cdclst.sql
[Phase 4] type is 1 with 1 Files
ora_restart.sql
[Phase 5] type is 1 with 5 Files
cdoptim.sql catsum.sql catexp.sql cddst.sql
cdend.sql
[Phase 6] type is 1 with 1 Files
catpstrt.sql
[Phase 7] type is 1 with 3 Files
catptyps.sql catpgrants.sql catgwm.sql
[Phase 8] type is 1 with 1 Files
ora_restart.sql
[Phase 9] type is 2 with 60 Files
catnodpt.sql catbac.sql prvtrctv.plb catactx.sql
prvtuttv.plb catsvrmg.sql prvtlsis.plb prvtlsss.plb
cattrans.sql catrule.sql catsnap.sql catpitr.sql
catdip.sql catrls.sql catar.sql catfga.sql
catamgt.sql catidxu.sql cattsm.sql catchnf.sql
catodm.sql catkppls.sql catsscr.sql catqueue.sql
cathae.sql catadvtb.sql catrm.sql catsch.sql
catol.sql catdpb.sql catcrc.sql dbmscr.sql
dbmsutil.sql catdbfus.sql catalrt.sql catatsk.sql
catmntr.sql catsqlt.sql catawrtv.sql catsmbvw.sql
catwrrtb.sql catsumat.sql catrep.sql catlmnr.sql
catdef.sql catadrvw.sql catrepv.sql catpexe.sql
cattlog.sql catcapi.sql catpspi.sql catts.sql
catnacl.sql catredact.sql catproftab.sql catpstdy.sql
catrupg.sql catratmask.sql catqitab.sql catappcont.sql
[Phase 10] type is 1 with 1 Files
ora_restart.sql
[Phase 11] type is 1 with 1 Files
catpspec.sql
[Phase 12] type is 1 with 1 Files
ora_restart.sql
[Phase 13] type is 2 with 199 Files
utlinad.sql utlsmtp.sql utlurl.sql utlenc.sql
utlgdk.sql utlcstk.sql utlcomp.sql utli18n.sql
utllms.sql dbmsplsw.sql utlnla.sql dbmspdb.sql
dbmstrns.sql dbmsrwid.sql dbmspclx.sql dbmserlg.sql
dbmsspu.sql dbmsapin.sql dbmssyer.sql dbmspipe.sql
dbmsalrt.sql dbmsdesc.sql dbmspexp.sql dbmsjob.sql
dbmsstat.sql dbmsstts.sql dbmsddl.sql dbmsedu.sql
dbmspp.sql prvthddl.plb prvthjob.plb prvthsye.plb
prvtzhlp.plb dbmsidxu.sql prvthidx.plb dbmspsp.sql
dbmstran.sql dbmsxa.sql dbmstxfm.sql dbmsread.sql
prvtreut.plb dbmspb.sql dbmspbt.sql dbmsplts.sql
dbmspitr.sql utlrefld.sql utlcoll.plb dbmstrst.sql
dbmsrlsa.sql dbmsrpr.sql dbmsobtk.sql dbmshtdb.sql
dbmslm.sql dbmslmd.sql prvtlmes.plb utlcxml.sql
dbmsfga.sql dbmsamgt.sql dbmstypu.sql dbmsres.sql
dbmstxin.sql dbmsdrs.sql dbmsdg.sql dbmssum.sql
dbmshord.sql dbmsxfr.sql dbmsmap.sql dbmsfi.sql
dbmsdbv.sql dbmstcv.sql dbmscoll.sql dbmscdcu.sql
dbmscdcp.sql dbmscdcs.sql dbmspbp.sql dbmshpro.sql
dbmssrv.sql dbmschnf.sql dbmsxpln.sql utlmatch.sql
dbmsdbvn.sql dbmspool.sql dbmsrcad.sql prvthcrc.plb
prvtkpps.plb dbmsaq.plb dbmsaqad.sql dbmsaq8x.plb
dbmsaqem.plb prvtaqxi.plb dbmsslrt.sql dbmsmntr.sql
dbmshm.sql catsqltk.sql dbmsir.sql prvtsss.plb
dbmsocm.sql dbmslobu.sql dbmsmp.sql dbmsaddm.sql
prvttxfs.plb dbmsrmin.plb dbmsrmad.sql dbmsrmpr.sql
dbmsrmpe.plb dbmsrmge.plb dbmsrmpa.plb prvtrmie.plb
prvthjob.plb prvthesh.plb dbmsol.sql prvtdputh.plb
dbmsmeta.sql dbmsmetb.sql dbmsmetd.sql dbmsmet2.sql
dbmsdp.sql prvthpp.plb prvthpd.plb prvthpdi.plb
prvthpvi.plb prvtdtde.plb prvtsum.plb prvtjdbs.plb
dbmsslxp.sql prvssmgu.plb dbmsawr.sql prvsemxi.plb
prvsemx_admin.plb prvsemx_dbhome.plb prvsemx_memory.plb prvsemx_perf.plb
dbmsperf.sql prvsrept.plb prvsrepr.plb prvshdm.plb
prvsrtaddm.plb prvs_awr_data_cp.plb prvscpaddm.plb prvsadv.plb
prvsawr.plb prvsawri.plb prvsawrs.plb prvsash.plb
prvsawrv.plb dbmssqlu.sql prvssqlf.plb dbmswrr.sql
dbmsfus.sql prvsfus.plb dbmsuadv.sql dbmsrepl.sql
dbmsspm.sql prvsspmi.plb prvssmb.plb prvssmbi.plb
dbmsstr.sql dbmssqlt.sql dbmsspa.sql prvsautorepi.plb
dbmsautorep.sql dbmsratmask.sql dbmsdiag.sql dbmsobj.sql
dbmskzxp.sql dbmscu.sql dbmsdst.sql dbmscomp.sql
dbmsilm.sql dbmspexe.sql prvthpexei.plb dbmscapi.sql
dbmsfuse.sql dbmsfspi.sql dbmspspi.sql dbmsdnfs.sql
dbmsadr.sql dbmsadra.sql prvsadri.plb xsrs.sql
xssc.sql xsacl.sql xsds.sql xsns.sql
xsdiag.sql xssess.sql dbmsredacta.sql dbmssqll.sql
dbmsgwm.sql dbmsappcont.sql dbmsspd.sql prvsspdi.plb
dbmsfs.sql dbmssqlm.sql catprofp.sql prvtsys.plb
dbmspart.sql dbmsrupg.sql dbmstsdp.sql
[Phase 14] type is 1 with 1 Files
ora_restart.sql
[Phase 15] type is 1 with 3 Files
dbmsmeti.sql dbmsmetu.sql dbmsqopi.sql
[Phase 16] type is 1 with 1 Files
ora_restart.sql
[Phase 17] type is 2 with 33 Files
catmettypes.sql prvthdbu.plb catost.sql dbmshae.sql
catxpend.sql prvtotpt.plb prvthlut.plb prvthlin.plb
prvthsdp.plb dbmsrman.sql dbmsbkrs.sql dbmstrig.sql
dbmsrand.sql dbmsjdwp.sql catxs.sql dbmssnap.sql
prvtxrmv.plb depsaq.sql prvthlrt.plb catadv.sql
dbmscred.sql catcredv.sql cataqsch.sql catrssch.sql
catplug.sql prvtsql.plb prvtssql.plb prvtlmd.plb
prvtlmcs.plb prvtlmrs.plb dbmslms.sql prvthpu.plb
prvthpv.plb
[Phase 18] type is 1 with 1 Files
ora_restart.sql
[Phase 19] type is 1 with 3 Files
prvtkupc.plb prvtaqiu.plb catlsby.sql
[Phase 20] type is 1 with 1 Files
ora_restart.sql
[Phase 21] type is 2 with 23 Files
catmetviews.sql prvthpw.plb prvthpm.plb prvthpfi.plb
prvthpf.plb dbmsodm.sql prvtitrg.plb prvtsms.plb
depssvrm.sql deptxn.sql catstr.sql prvthsts.plb
prvthfgr.plb prvthfie.plb prvthcmp.plb catpexev.sql
depscapi.sql depspspi.sql catwrrvw.sql dbmsjdcu.sql
dbmsjdmp.sql prvthpc.plb prvt_awr_data.plb
[Phase 22] type is 1 with 1 Files
ora_restart.sql
[Phase 23] type is 2 with 11 Files
catmetgrant1.sql catldap.sql prvtocm.sql prvtrepl.sql
catpstr.sql prvthpci.plb catilm.sql catemxv.sql
catnaclv.sql dbmsnacl.sql dbmswlm.sql
[Phase 24] type is 1 with 1 Files
ora_restart.sql
[Phase 25] type is 1 with 1 Files
catcdbviews.sql
[Phase 26] type is 1 with 1 Files
ora_restart.sql
[Phase 27] type is 2 with 0 Files
[Phase 28] type is 1 with 1 Files
ora_load_without_comp.sql
[Phase 29] type is 2 with 130 Files
prvtfile.plb prvtrawb.plb prvttcp.plb prvtinad.plb
prvtsmtp.plb prvthttp.plb prvturl.plb prvtenc.plb
prvtgdk.plb prvtlob.plb prvtlobu.plb prvtcstk.plb
prvtcomp.plb prvti18n.plb prvtlms2.plb prvtnla.plb
prvttrns.plb prvtsess.plb prvtrwid.plb prvtpclx.plb
prvterlg.plb prvtapin.plb prvtsyer.plb prvtlock.plb
prvtpipe.plb prvtalrt.plb prvtdesc.plb prvtpexp.plb
prvtzexp.plb prvtstts.plb prvtddl.plb prvtpp.plb
prvtscrp.plb prvtkppb.plb prvtutil.plb prvtpsp.plb
prvttran.plb prvtxa.plb prvtany.plb prvtread.plb
prvtpb.plb prvtpbt.plb prvtxpsw.plb prvtcoll.plb
prvttrst.plb prvtrlsa.plb prvtodci.plb prvtrpr.plb
prvtobtk.plb prvthtdb.plb prvtxmlt.plb prvturi.plb
prvtxml.plb prvtcxml.plb prvtemxi.plb prvtemx_admin.plb
prvtemx_dbhome.plb prvtemx_memory.plb prvtemx_perf.plb prvtperf.plb
prvtrep.plb prvtrept.plb prvtrepr.plb prvtfga.plb
prvtamgt.plb prvttypu.plb prvtjdwp.plb prvtjdmp.plb
prvtres.plb prvtcr.plb prvttxin.plb prvtdrs.plb
prvtdg.plb prvtfi.plb prvtmap.plb prvthpui.plb
prvtdbv.plb prvttcv.plb prvtpbp.plb prvthpro.plb
prvtbdbu.plb prvtsrv.plb prvtpool.plb prvtkzxs.plb
prvtkzxp.plb prvtcrc.plb prvtrc.plb prvtaq.plb
prvtaqdi.plb prvtaqxe.plb prvtaqis.plb prvtaqim.plb
prvtaqad.plb prvtaq8x.plb prvtaqin.plb prvtaqal.plb
prvtaqjm.plb prvtaqmi.plb prvtaqme.plb prvtaqem.plb
prvtaqip.plb prvtaqds.plb prvtsqdi.plb prvtsqds.plb
prvtsqis.plb prvthm.plb prvtwlm.plb prvtsqtk.plb
prvtkjhn.plb prvtir.plb prvtssb.plb prvttxfm.plb
prvtrmin.plb prvtrmad.plb prvtrmpr.plb prvtrmpe.plb
prvtrmge.plb prvtrmpa.plb prvtjob.plb prvtbsch.plb
prvtesch.plb prvtcred.plb prvtol.plb prvtlm.plb
prvtlmcb.plb prvtlmrb.plb prvtlms.plb prvtlmeb.plb
prvtbpu.plb prvtwrr.plb
[Phase 30] type is 1 with 1 Files
ora_load_with_comp.sql
[Phase 31] type is 1 with 1 Files
ora_restart.sql
[Phase 32] type is 1 with 1 Files
ora_load_without_comp.sql
[Phase 33] type is 2 with 122 Files
prvtbpui.plb prvtdput.plb prvtmeta.plb prvtmeti.plb
prvtmetu.plb prvtmetb.plb prvtmetd.plb prvtmet2.plb
prvtdp.plb prvtbpc.plb prvtbpci.plb prvtbpw.plb
prvtbpm.plb prvtbpfi.plb prvtbpf.plb prvtbpp.plb
prvtbpd.plb prvtbpdi.plb prvtbpv.plb prvtbpvi.plb
prvtdpcr.plb prvtplts.plb prvtpitr.plb prvtreie.plb
prvtrwee.plb prvtidxu.plb prvtrcmp.plb prvtchnf.plb
prvtedu.plb prvtlsby.plb prvtlsib.plb prvtlssb.plb
prvtsmv.plb prvtsma.plb prvtbxfr.plb prvtbord.plb
prvtjdbb.plb prvtslrt.plb prvtslxp.plb prvtatsk.plb
prvtmntr.plb prvtsmgu.plb prvtdadv.plb prvtadv.plb
prvtawr.plb prvtawrs.plb prvtawri.plb prvtash.plb
prvtawrv.plb prvtsqlf.plb prvtsqli.plb prvtsqlt.plb
prvtautorepi.plb prvtautorep.plb prvtfus.plb prvtmp.plb
prvthdm.plb prvtaddm.plb prvtrtaddm.plb prvt_awr_data_cp.plb
prvtcpaddm.plb prvtuadv.plb prvtsqlu.plb prvtspai.plb
prvtspa.plb prvtratmask.plb prvtspmi.plb prvtspm.plb
prvtsmbi.plb prvtsmb.plb prvtfus.plb catfusrg.sql
prvtwrk.plb prvtsmaa.plb prvtxpln.plb prvtstat.plb
prvtstai.plb prvtsqld.plb prvtspcu.plb prvtodm.plb
prvtkcl.plb prvtdst.plb prvtcmpr.plb prvtilm.plb
prvtpexei.plb prvtpexe.plb prvtcapi.plb prvtfuse.plb
prvtfspi.plb prvtpspi.plb prvtdnfs.plb prvtfs.plb
prvtadri.plb prvtadr.plb prvtadra.plb prvtadmi.plb
prvtutils.plb prvtxsrs.plb prvtsc.plb prvtacl.plb
prvtds.plb prvtns.plb prvtdiag.plb prvtkzrxu.plb
prvtnacl.plb prvtredacta.plb prvtpdb.plb prvttlog.plb
prvtsqll.plb prvtappcont.plb prvtspd.plb prvtspdi.plb
prvtpprof.plb prvtsqlm.plb prvtpart.plb prvtrupg.plb
prvtrupgis.plb prvtrupgib.plb prvtpstdy.plb prvttsdp.plb
prvtqopi.plb prvtlog.plb
[Phase 34] type is 1 with 1 Files
ora_load_with_comp.sql
[Phase 35] type is 1 with 1 Files
ora_restart.sql
[Phase 36] type is 1 with 4 Files
catmetinsert.sql catpcnfg.sql utluppkg.sql catdph.sql
[Phase 37] type is 1 with 1 Files
ora_restart.sql
[Phase 38] type is 2 with 13 Files
catmetgrant2.sql execemx.sql execcr.sql caths.sql
catemini.sql execaq.sql execsvrm.sql exechae.sql
execsec.sql execbsln.sql dbmspump.sql olappl.sql
execrep.sql
[Phase 39] type is 1 with 1 Files
ora_restart.sql
[Phase 40] type is 2 with 10 Files
execstr.sql execsvr.sql execstat.sql catsnmp.sql
wpiutil.sql owainst.sql catilmini.sql execocm.sql
exectsdp.sql execqopi.sql
[Phase 41] type is 1 with 1 Files
ora_restart.sql
[Phase 42] type is 1 with 1 Files
catpend.sql
[Phase 43] type is 1 with 1 Files
ora_restart.sql
[Phase 44] type is 1 with 1 Files
catupprc.sql
[Phase 45] type is 1 with 1 Files
cmpupstr.sql
[Phase 46] type is 1 with 1 Files
ora_restart.sql
[Phase 47] type is 1 with 2 Files
cmpupjav.sql cmpupnjv.sql
[Phase 48] type is 1 with 1 Files
ora_restart.sql
[Phase 49] type is 1 with 2 Files
cmpupxdb.sql cmpupnxb.sql
[Phase 50] type is 1 with 1 Files
ora_restart.sql
[Phase 51] type is 1 with 2 Files
cmpupord.sql cmpupmsc.sql
[Phase 52] type is 1 with 1 Files
ora_restart.sql
[Phase 53] type is 1 with 1 Files
cmpupend.sql
[Phase 54] type is 1 with 1 Files
catupend.sql
[Phase 55] type is 1 with 1 Files
catuppst.sql
[Phase 56] type is 1 with 1 Files
catshutdown.sql
Using 6 processes.
Serial Phase #: 0 Files: 1
Time: 118s
Serial Phase #: 1 Files: 3 Time: 29s
Restart Phase #: 2 Files: 1 Time: 1s
Parallel Phase #: 3 Files: 18 Time: 6s
Restart Phase #: 4 Files: 1 Time: 0s
Serial Phase #: 5 Files: 5 Time: 15s
Serial Phase #: 6 Files: 1 Time: 14s
Serial Phase #: 7 Files: 3 Time: 6s
Restart Phase #: 8 Files: 1 Time: 1s
Parallel Phase #: 9 Files: 60 Time: 24s
Restart Phase #:10 Files: 1 Time: 1s
Serial Phase #:11 Files: 1 Time: 14s
Restart Phase #:12 Files: 1 Time: 0s
Parallel Phase #:13 Files: 199 Time: 52s
Restart Phase #:14 Files: 1 Time: 1s
Serial Phase #:15 Files: 3 Time: 1s
Restart Phase #:16 Files: 1 Time: 0s
Parallel Phase #:17 Files: 33 Time: 31s
Restart Phase #:18 Files: 1 Time: 1s
Serial Phase #:19 Files: 3 Time: 5s
Restart Phase #:20 Files: 1 Time: 0s
Parallel Phase #:21 Files: 23 Time: 52s
Restart Phase #:22 Files: 1 Time: 1s
Parallel Phase #:23 Files: 11 Time: 22s
Restart Phase #:24 Files: 1 Time: 1s
Serial Phase #:25 Files: 1 Time: 24s
Restart Phase #:26 Files: 1 Time: 0s
Parallel Phase #:27 Files: 0 Time: 1s
Serial Phase #:28 Files: 1 Time: 0s
Parallel Phase #:29 Files: 130 Time: 11s
Serial Phase #:30 Files: 1 Time: 0s
Restart Phase #:31 Files: 1 Time: 0s
Serial Phase #:32 Files: 1 Time: 0s
Parallel Phase #:33 Files: 122 Time: 12s
Serial Phase #:34 Files: 1 Time: 0s
Restart Phase #:35 Files: 1 Time: 1s
Serial Phase #:36 Files: 4 Time: 48s
Restart Phase #:37 Files: 1 Time: 0s
Parallel Phase #:38 Files: 13 Time: 29s
Restart Phase #:39 Files: 1 Time: 1s
Parallel Phase #:40 Files: 10 Time: 8s
Restart Phase #:41 Files: 1 Time: 1s
Serial Phase #:42 Files: 1 Time: 5s
Restart Phase #:43 Files: 1 Time: 0s
Serial Phase #:44 Files: 1 Time: 7s
Serial Phase #:45 Files: 1 Time: 0s
Restart Phase #:46 Files: 1 Time: 0s
Serial Phase #:47 Files: 2 Time: 340s
Restart Phase #:48 Files: 1 Time: 0s
Serial Phase #:49 Files: 2 Time: 278s
Restart Phase #:50 Files: 1 Time: 0s
Serial Phase #:51 Files: 2 Time: 1167s
Restart Phase #:52 Files: 1 Time: 1s
Serial Phase #:53 Files: 1 Time: 1s
Serial Phase #:54 Files: 1
*** WARNING: ERRORS FOUND DURING UPGRADE ***
Due to errors found during the upgrade process, the post
upgrade actions in catuppst.sql have not been automatically run.
*** THEREFORE THE DATABASE UPGRADE IS NOT YET COMPLETE ***
1. Evaluate the errors found in the upgrade logs (*.log) and determine the proper action.
2. Execute the post upgrade script as described in Chapter 3 of the Database Upgrade Guide.
Time: 110s
Grand Total Time: 2441s
[oinstall@arjun admin]$
[oinstall@arjun admin]$ ls -lrt *.log
[00mls: *.log: No such file or directory
[oinstall@arjun admin]$ sqlplus "/as sysdba"
SQL*Plus: Release 12.1.0.1.0 Production on Tue Jul 16 10:22:15 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1670221824 bytes
Fixed Size 2289064 bytes
Variable Size 570425944 bytes
Database Buffers 1090519040 bytes
Redo Buffers 6987776 bytes
Database mounted.
Database opened.
SQL> @$ORACLE_HOME/rdbms/admin/utlu121s.sql
.
Oracle Database 12.1 Post-Upgrade Status Tool 07-16-2013 10:24:24
.
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
.
Oracle Server
. UPGRADED 12.1.0.1.0 00:09:02
JServer JAVA Virtual Machine
. VALID 12.1.0.1.0 00:04:08
Oracle Workspace Manager
. VALID 12.1.0.1.0 00:00:45
OLAP Analytic Workspace
. VALID 12.1.0.1.0 00:00:54
Oracle OLAP API
. ORA-00942: table or view does not exist
. ORA-00942: table or view does not exist
. ORA-00942: table or view does not exist
. ORA-00942: table or view does not exist
. ORA-00942: table or view does not exist
. VALID 12.1.0.1.0 00:00:12
Oracle XDK
. VALID 12.1.0.1.0 00:00:36
Oracle Text
. VALID 12.1.0.1.0 00:01:02
Oracle XML Database
. VALID 12.1.0.1.0 00:02:38
Oracle Database Java Packages
. VALID 12.1.0.1.0 00:00:10
Oracle Multimedia
. VALID 12.1.0.1.0 00:01:40
Spatial
. VALID 12.1.0.1.0 00:04:08
Oracle Application Express
. VALID 4.2.0.00.27 00:13:10
Final Actions
. 00:01:14
Total Upgrade Time: 00:40:03
PL/SQL procedure successfully completed.
SQL>
SQL> @$ORACLE_HOME/rdbms/admin/catuppst.sql
Session altered.
Session altered.
Session altered.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP POSTUP_BGN 2013-07-16 10:25:24
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP CATREQ_BGN 2013-07-16 10:25:24
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 2013-07-16 10:25:24
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.
catuppst: Gathering fixed objects stats now...
catuppst: Gathering fixed objects stats done.
PL/SQL procedure successfully completed.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP POSTUP_END 2013-07-16 10:26:41
PL/SQL procedure successfully completed.
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Generating apply and rollback scripts...
Check the following file for errors:
/u01/oinstall/cfgtoollogs/catbundle/catbundle_PSU_MUTH_GENERATE_2013Jul16_10_26_44.log
Apply script: /u01/oinstall/product/12.1.1/rdbms/admin/catbundle_PSU_MUTH_APPLY.sql
Rollback script: /u01/oinstall/product/12.1.1/rdbms/admin/catbundle_PSU_MUTH_ROLLBACK.sql
PL/SQL procedure successfully completed.
Executing script file...
SQL> alter session set "_ORACLE_SCRIPT" = true;
Session altered.
SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/u01/oinstall/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LANGUAGE=''AMERICAN''') || '.log' AS spool_file FROM v$database;
SQL> SPOOL &spool_file
SQL> exec dbms_registry.set_session_namespace('SERVER')
PL/SQL procedure successfully completed.
SQL> ALTER SESSION SET current_schema = SYS;
Session altered.
SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
2 (action_time, action,
3 namespace, version, id,
4 bundle_series, comments)
5 VALUES
6 (SYSTIMESTAMP, 'APPLY',
7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
8 '12.1.0.1',
9 0,
10 'PSU',
11 'Patchset 12.1.0.0.0');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/u01/oinstall/cfgtoollogs/catbundle/catbundle_PSU_MUTH_APPLY_2013Jul16_10_26_45.log
Session altered.
Session altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oinstall@arjun admin]$ vi /u01/oinstall/cfgtoollogs/catbundle/catbundle_PSU_MUTH_APPLY_2013Jul16_10_26_45.log
############Compile Invalid Objects#########
[oinstall@arjun admin]$sqlplus "/as sysdba"
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> @/usr/tmp/dbupgdiag.sql
###########Post Upgrade Steps################
Make sure the following environment variables point to the Oracle 12c Release 1 (12.1) directories
- ORACLE_BASE
- ORACLE_HOME
- PATH, LD_LIBRARY_PATH and SHLIB_PATH
Ensure that your oratab file and any client scripts that set the value of ORACLE_HOME point to the new Oracle home that is created for the new Oracle Database 12c release,
############Initialization parameter file##########
Edit init.ora
If you changed the CLUSTER_DATABASE parameter prior the upgrade set it back to TRUE
Migrate your initialization parameter file to a server parameter file.
Create a server parameter file with an initialization parameter file.
SQL> create spfile from pfile;
###############Password File###################
If the REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to either exclusive or shared, create a password file with ORAPWD.
#############COMPATIBLE Initialization Parameter#############
The COMPATIBLE initialization parameter controls the compatibility level of your database.
When you are certain that you no longer need the ability to downgrade your database to its original release
Perform a backup of your database before you raise the COMPATIBLE initialization parameter (optional).
If you are using a server parameter file, then complete the following steps:
a. Update the server parameter file to set or change the value of the COMPATIBLE initialization parameter.
For example, to set the COMPATIBLE initialization parameter to 12.0.0, enter the following statement:
SQL> ALTER SYSTEM SET COMPATIBLE = '12.0.0' SCOPE=SPFILE;
b. Shut down and restart the instance.
If you are using an initialization parameter file, then complete the following steps:
a. Shut down the instance if it is running:
SQL> SHUTDOWN IMMEDIATE
b. Edit the initialization parameter file to set or change the value of the COMPATIBLE initialization parameter.
For example, to set the COMPATIBLE initialization parameter to for Oracle Database release 12.1, enter the following in the initialization parameter file:
COMPATIBLE = 12.1.0
c. Start the instance using STARTUP.
Change passwords for Oracle-Supplied Accounts.
SQL> SELECT username, account_status FROM dba_users ORDER BY username;
To lock and expire passwords, issue the following SQL statement:
SQL> ALTER USER username PASSWORD EXPIRE ACCOUNT LOCK;
Upgrade the Recovery Catalog After Upgrading Oracle Database
You can upgrade the Recovery catalog by executing the UPGRADE CATALOG command
Upgrade the Time Zone File Version After Upgrading Oracle Database
Identify Invalid Objects With the utluiobj Script
SQL> @$ORACLE_HOME/rdbms/admin/utluiobj.sql
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE 12.1.0.1.0 Production
TNS for Linux: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 - Production
SQL>
No comments:
Post a Comment