Oracle Forms Builder 6i Connected Database 12c then Appcrash on win7 (更改語系)

1. 查一下資料庫的語系
SQL> SELECT parameter, value FROM v$nls_parameters WHERE parameter LIKE '%CHARACTERSET';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8

NLS_NCHAR_CHARACTERSET
AL16UTF16

2. 查一下本機Oracle Forms Builder 6i NLS_LANG
CMD > regedit
Find = NLS_LANG
NLS_LANG = AMERICAN_AMERICA.ZHT16BIG5


3. 更改資料庫的語系
shutdown immediate;
STARTUP MOUNT;
ALTER SESSION SET SQL_TRACE=TRUE;
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 ZHT16BIG5;
ALTER SESSION SET SQL_TRACE=FALSE;
shutdown immediate;
STARTUP;



PS. ORA-28040時還需在SQLNET.ora上加入SQLNET_ALLOWED_LOGON_VERSION=8，SERVER與CLIENT要相同。

PS. ORA-12717則改成
ALTER DATABASE CHARACTER SET INTERNAL_USE ZHT16BIG5;

注意：請評估開發環境是否能這樣做，再決定如何處理(以上是不建議做法)。

建議安全做法是安裝新的INSTANCE，用DB LINK、(EXPDP和IMPDP)、RMAN還原。