Oracle Express correct character set modification tips"

The following article describes how to correctly modify the character set of Oracle Express and how to upgrade APEX. I installed windows in the European language two days ago, the international language version is no longer 60 M. The default Character Set of the database is AL32UTF8.

The company uses the ZHS16GBK character set, so the character set is changed using the following method:

SQL code

 
 

  
  
sqlplus sys_name/sys_password as sysdba  
  
  
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 ZHS16GBK;  
  
  
shutdown immediate  
  
  
startup  
  
  
sqlplus sys_name/sys_password as sysdba  
  
  
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 ZHS16GBK;  
  
  
shutdown immediate  
  
  
startup  
 
 

The character set is changed, and the attached APEX cannot be run.

Oracle Express modifies the character set and upgrades APEX to solve this problem.

APEX Download Page

Find a node on the internet, write a script based on apex_3.2.1.zip), just put it in the directory of your unzipped APEX, and run as prompted

Check whether the installation is successful:

SQL code

 
 

  
  
select status from dba_registry where comp_id='APEX';  
  
  
select status from dba_registry where comp_id='APEX';  
 
 

The installation is successful only when the result is "VALID ".

View APEX Port

SQL code

 
 

  
  
select DBMS_XDB.GETHTTPPORT() from dual;  
  
  
select DBMS_XDB.GETHTTPPORT() from dual;  
 
 

APEX administrator page

Http: // [IP]: [port]/apex/apex_admin

APEX normal page

Http: // [IP]: [port]/apex

The above content describes how to modify the character set of Oracle Express and upgrade APEX. I hope it will help you in this aspect.