Oracle Form/Report 6 Character Set

Submitted by aa.gusti on Tue, 15/10/2013 - 19:41

Dalam akses database, Oracle form/report 6 pada dasarnya hanya bisa membaca database dengan Character Set WE8MSWIN1252, padahal saat instalasi Oracle 11 Database Default Character Set menggunakan AL16UTF8.

Unuk dapat menggunakan oracle form/report 6.0 berikut langkah-langkah yang digunakan :

1. Check Character set saat ini :

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

2. Langkah mengubah Character Set


>sqlplus / as sysdba
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP RESTRICT;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;

SQL>ALTER DATABASE CHARACTER SET WE8MSWIN1252;

-- if the above fails:
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252;
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP;