Connecting Oracle Express 10g with Oracle Forms 6i

Hi readers...

Recently I was going through my old stuff in Oracle that I was doing before my professional life started with Databases.  I found many of the applications build with Oracle 8i and Oracle Forms 6i (Developer 2000), tried to run them the the problem I was facing was 'no oracle 8i database'...

I thought to connect the same with Oracle Express 10g Database but Forms and Reports gave error.  After some study in database material I found that Oracle Express 10g Database is not compatible with Forms 6i because of its 'Character Set'...

Now the problem was to change the Oracle Express 10g Database Character Set to older version so that forms can be connected...

When Oracle Express 10g Database is installed on SQL command prompt connect with admin database user as

sys/password as sysdba

when connected apply following commands one by one...

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;

Finally you will be able to connect with Forms 6i and run and migrate your applications...

Thanks for reading...

Ask for further help as and when you required...