I installed the European language version of Windows. The international language version is 60M larger, so I don’t need it.
Because it has just been installed, the default character set of the database is AL32UTF eight.
The character set used by the company is ZHS16GBK, so I changed the character set using the following steps.
Sql code
sqlplus sys_name/sys_password as sysdba
shutdown immediate;
startup mount
alter system enable restricted session;
alter system set JOB_QUEUE_PROCESSES=zero;
alter system set AQ_TM_PROCESSES=zero;
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=zero;
alter system set AQ_TM_PROCESSES=zero;
alter database open;
alter database character set internal_use ZHS16GBK;
shutdown immediate
startup
The character set was changed, but it turned out that the APEX that came with it didn't work anymore.
Since it can't be used, I decided to solve it by upgrading APEX.
APEX download page
I found some stuff on the Internet and wrote a script (based on apex_3.2.1.zip). Just put it in the APEX index you decompressed and run it according to the prompts.
Check whether the assembly is smooth:
Sql code
select status from dba_registry where comp_id='APEX';
select status from dba_registry where comp_id='APEX'; Only the result is "VALID" which means the installation is successful.
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 ordinary page