-   - COMMAND
  - from root: chown -R ora1025:dba /db/aas3m1p
  - screen
  - su – ora1025
  - export ORACLE_SID=aas3m11p
  - cd /MIGRAZIONE/export/aas3m11p/upgrade
  - startup mount
  - @rename_datafile_aas3m11p.sql
  - alter database noarchivelog;
  - alter database open upgrade;
  - spool pre1025upgrade.log
  - @?/rdbms/admin/utlu102i.sql
  - spool off
  - spool upgrade_1023_to_1025.log
  - @?/rdbms/admin/catupgrd.sql
  - spool off
  - SHUTDOWN IMMEDIATE
  - STARTUP
  - @?/rdbms/admin/utlrp.sql
  - spool post1025upgrade.log
  - @?/rdbms/admin/utlu102s.sql
  - spool off
  - cd /MIGRAZIONE/export/aas3m11p/upgrade
  - spool pre12Cupgrade.log
  - @preupgrd.sql
  - EXECUTE dbms_preup.purge_recyclebin_fixup;
  - EXECUTE dbms_stats.gather_dictionary_stats;
  - @preupgrd.sql
  - check again file /appl/oracle/product/DE/10.2.0.5/OraBase/cfgtoollogs/aas3m11p/preupgrade/preupgrade.log
  - IMPORTANT, check that fixup scripts are not empty!!! optionaly rerun preupgrade.sql again to generate them
  - @/appl/oracle/product/DE/10.2.0.5/OraBase/cfgtoollogs/aas3m11p/preupgrade/preupgrade_fixups.sql
  - /MIGRAZIONE/export/aas3m11p/upgrade/backup_full_pre12Cupgrade.sh
  - shu immediate;
  - END OF 10G
  - correct /etc/oratab to point to new 12c OH
  - from root: chown -R oas31212:dba /db/aas3m1p
  - open new screen session and sudo to oas31212 user
  - Set new oracle environment and check env|grep ORACLE and env|grep appl .. all path should point to new 12c HOME
  - mv /db/aas3m1p/admin/diag/rdbms/aas3m11p/aas3m11p/trace/alert_aas3m11p.log /db/aas3m1p/admin/diag/rdbms/aas3m11p/aas3m11p/trace/alert_aas3m11p.log_bkp
  - cd $ORACLE_HOME/rdbms/admin
  - sqlplus '/ as sysdba'
  - startup upgrade
  - Exit
  - $ORACLE_HOME/perl/bin/perl catctl.pl -n 30 -l /MIGRAZIONE/export/aas3m11p/upgrade/logs catupgrd.sql
  - open another session and tail alert log file:
  - tail -f /db/aas3m1p/admin/diag/rdbms/aas3m11p/aas3m11p/trace/alert_aas3m11p.log
  - monitor alert log file (step 33) and upgrade logs 
  - grep ORA- /MIGRAZIONE/export/aas3m11p/upgrade/logs/*
  - POST UPGRADE STEPS
  - check upgrade logs for ORA- errors 
  - grep "Rem BEGIN catuppst.sql" /MIGRAZIONE/export/aas3m11p/upgrade/logs/*
  - not shown, you must execute as per document
  - startup database
  - $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
  - SPOOL postupgrade.log
  - @/appl/oracle/product/DE/10.2.0.5/OraBase/cfgtoollogs/aas3m11p/preupgrade/postupgrade_fixups.sql
  - spool utlu121s_upg.log
  - @?/rdbms/admin/utlu121s.sql
  - $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utluiobj -d '''.''' utluiobj.sql
  - Drop all public db links
  - select 'drop public database link '||db_link||';' from dba_db_links where owner='PUBLIC';
  - drop all db links (only private links can be dropped by this script): execute script and copy/paste result to sqlplus command line as sys
  - @/MIGRAZIONE/export/aas3m11p/upgrade/drop_private_db_links.sql
  - Check there is no db link in database anymore:
  - select * from dba_db_links;
  - check and correct /MIGRAZIONE/export/aas3m11p/upgrade/imp_schemas_backup.par to have latest export file and new log file and correct directory name!!!!
  - @/MIGRAZIONE/export/aas3m11p/upgrade/STEP1_postupgrade_12c.sql
  - /MIGRAZIONE/export/aas3m11p/upgrade/imp_schemas_backup.sh
  - @/MIGRAZIONE/export/aas3m11p/upgrade/STEP2_postupgrade_12c.sql
  - import db links from metadata export:
  - Correct /MIGRAZIONE/export/aas3m11p/upgrade/imp_db_links.par     > correct directory, dump file and log file
  - Execute
  - impdp \"\/ as sysdba\" parfile=imp_db_links.par
  - Create following link manually as user does not have requested privileges and db link is not imported
  - CREATE DATABASE LINK "DLAS3DE001"  CONNECT TO "TAS3DE" IDENTIFIED BY "TAS3DE"  USING 'ADE000';
  - Create rman user:
  - alter profile ADMIN_PROFILE limit PASSWORD_VERIFY_FUNCTION NULL;
  - create user rman identified by sgana profile admin_profile; 
  - grant sysdba,connect to rman; 
  - alter profile ADMIN_PROFILE limit PASSWORD_VERIFY_FUNCTION VERIFYIBM;
  - Execute 2x utlrp.sql
  - @?/rdbms/admin/utlrp.sql
  - Was addded to: MASTER_GRANTS_AAS3.sql
  - grant select on sys.dba_role_privs to BIPORTALAS32;
  - grant select on sys.dba_role_privs to BIPORTALAS33;