Oracle Express修改字符集，升級(jí)到APEX

2024-08-29 13:53:59

字體：大中小

供稿：網(wǎng)友

我裝配的是windows停的歐洲語言版，國(guó)際語言版的大了60M便沒要

因?yàn)閯傃b好，默許數(shù)據(jù)庫(kù)的字符集是AL32UTF八

公司用的字符集是ZHS16GBK，于是乎用下部步驟改了字符集

Sql代碼

sqlplus sys_name/sys_passWord as sysdba

shutdown immediate;

startup mount

alter system enable restricted session;

alter system set JOB_QUEUE_PROCESSES=零;

alter system set AQ_TM_PROCESSES=零;

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=零;

alter system set AQ_TM_PROCESSES=零;

alter database open;

alter database character set internal_use ZHS16GBK;

shutdown immediate

startup

字符集是改好了，結(jié)果發(fā)現(xiàn)捎帶的APEX不能運(yùn)作了

既是不能用就決議經(jīng)過升格一下子APEX來解決

APEX下載頁(yè)面

在網(wǎng)上找了點(diǎn)貨色，寫了個(gè)腳本（基于apex_3.2.1.zip），只要把它放在你解壓的APEX索引里邊，運(yùn)作按提醒操作

查看是不是裝配順利：

Sql代碼

select status from dba_registry where comp_id='APEX';

select status from dba_registry where comp_id='APEX';惟獨(dú)結(jié)果為“VALID”才示意裝配順利

查看APEX端口

Sql代碼

select DBMS_XDB.GETHTTPPORT() from dual;

select DBMS_XDB.GETHTTPPORT() from dual;

APEX管理員頁(yè)面

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

APEX普普通通頁(yè)面

http://[IP]:[port]/apex

上一篇：Oracle碎片拾掇全面解析

下一篇：oracle 表空間表權(quán)限用戶