Upgrading form6i and report6i to 11g/12c?

[admin]

It is always recommended to upgrade to the latest version of any product while Oracle Developer 6i is already obsolete by Oracle and de-supported. Few companies due to different factors can't upgrade so here we will share to stay with 6i and connect to 12c and higher versions or how to upgrade.

Parameters and Character Set Settings

Code: Select all

SYSTEM@mydb> show parameter SEC_CASE_SENSITIVE_LOGON
 
NAME                                               TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon       boolean   TRUE
 
SYSTEM@mydb> alter system set sec_case_sensitive_logon=false scope=both;

2

SQL> select * from v$nls_parameters where parameter like '%CHARACTERSET%';

PARAMETER                                                        VALUE                                                                                                                                                                                                                                                                                                                                                                                                                                             
---------------------------------------------------------------- ----------------------------------------------------------------                                                                                                                                                                                                                                                                                                                                                                                  
NLS_CHARACTERSET                                                 AL32UTF8                                                                                                                                                                                                                                                                                                                                                                                                                                          
NLS_NCHAR_CHARACTERSET                                           AL16UTF16    

1. connect as sysdba using SYSTEM, not SYS.
Run the following command sequentially.
SQL>CONN SYSTEM/MANAGER AS SYSDBA

2. Shutdown the database if running:
SQL>SHUTDOWN IMMEDIATE

3. Start the database in restrict mode:
SQL>STARTUP RESTRICT

4. Change the database character set to UTF8 as follows:
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;

5. Shutdown the database:
SQL>SHUTDOWN IMMEDIATE

6. At last, start the database in normal mode:
SQL>STARTUP

Oracle® Fusion Middleware
Upgrading Oracle Forms 6i to Oracle Forms 12c
12c (12.2.1.1) E71740-01
Using the Oracle Forms Migration Assistant

Oracle forms 6i migration to 12c.zip

(415.52 KiB) Downloaded 1078 times