![]() ![]() Almost done with configuration, set new environment db_1]$ export db_1]$ db_1]$.Move spfile and password file from Oracle Database 11g’s folder to Oracle Database 12c’s folder dbs]$ cp spfileorcl.ora dbs]$ cp orapworcl /u01/app/oracle/product/12.1.0.2/db_1/dbs/.SQL> EXECUTE dbms_stats.gather_dictionary_stats SQL>SERVEROUTPUT ?/olap/admin/catnomad.sql SQL>ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE Apply these recommended settings on database.After the script execution, please take a look to upgrade log db_1]$ vi /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/imc12c/upgrade/upg_summary.log Ĭlick to access upgrading-oracle-database-wp-12c-1896123.pdfħ. In addition to I would like to thank g.g. All of upgrade methods are helping you during upgrade time. This documants guiding to upgrade database. SQL> SELECT name, open_mode FROM v$database With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production Please, check the condition with admin]$ sqlplus / as sysdba.SQL> SET ECHO OFF SERVEROUTPUT ON FORMAT WRAPPED TAB OFF LINESIZE 750 ![]() SQL> REM Generated by Version: 12.1.0.2 Build: 006 ![]() SQL> REM Post Upgrade Script Generated on: 08:09:30 SQL> UPDATE sys.registry$upg_summary SET reportname = :ReportName,Ģ con_name = SYS_CONTEXT(‘USERENV’,’CON_NAME’), SQL> - Update Summary Table with con_name and endtime. Oracle Real Application Clusters OPTION OFF 12.1.0.2.0 00:00:01 All rights reserved.ĬATCTL REPORT = /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/imc12c/upgrade/upg_summary.log
0 Comments
Leave a Reply. |