Posts

Showing posts from September, 2016

Database Upgrade to 12c Steps Summary [ Definition only]

Upgrading database to 12c steps ========================= Please read through below metalink documents for upgrading database to 12c: MOS    #1503653.1 + Upgrade Companion #1462240 + upgrade script 3884522.1 Note 2037154.1 DBMS_STATS.GATHER_DICTIONARY_STATS Fails with "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" hcheck.sql - Script to Check for Known Problems in Oracle8i, Oracle9i, Oracle10g, Oracle 11g and Oracle 12c (Doc ID 136697.1)       May 2016 Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql) (Doc ID 556610.1) In our workplace we are using a single scripts which contains steps below  -- verify into developemnt setup before implementing into working (TEST/QA/PROD) PreUpgrade Phase:                 1  : Compile invalid objects            ...