安装Oracle Application Express详细过程
请先下载Oracle Application Express软件apex 3.0，并解压到相应目录下（I:app/apex）1.安装Oracle Application Express
①进入DOS窗口，切换到I:app/apex目录
②执行sqlplus /nolog
③登录：conn sys/密码 as sysdba
④安装脚本apexin.sql：@apexin SYSAUX SYSAUX TEMP /i/
//apexin :安装脚本的文件名
// TEMP:排序所用的空间表
// /i/：存放图像的虚拟目录
// SYSAUX:数据和用户信息将存放在SYSAUX表空间里
结果为这样，表明第一步成功了：
2.修改ADMIN账户密码
SQL> @apexxpwd
3.配置嵌入式PL/SQL网关
①SQL> @apex_epg_config I:\app
②将ANONYMOUS账户解锁：
SQL>>
4.核实和开启Oracle XML DB HTTP服务器的端口
①SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
②SQL> EXEC DBMS_XDB.SETHTTPPORT(8080);
③SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
服务器已开启，端口为：8080
5.开启数据库网络服务
复制到SQL*Plus：
DECLARE
ACL_PATH VARCHAR2(4000);
ACL_ID RAW(16);
BEGIN
-- Look for the ACL currently assigned to '*' and give APEX_030200
-- the "connect" privilege if APEX_030200 does not have the privilege yet.
SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
-- Before checking the privilege, ensure that the ACL is valid
-- (for example, does not contain stale references to dropped users).
-- If it does, the following exception will be raised:
--
-- ORA-44416: Invalid ACL: Unresolved principal 'APEX_030200'
-- ORA-06512: at "XDB.DBMS_XDBZ", line ...
--
SELECT SYS_OP_R2O(extractValue(P.RES, '/Resource/XMLRef')) INTO ACL_ID
FROM XDB.XDB$ACL A, PATH_VIEW P
WHERE extractValue(P.RES, '/Resource/XMLRef') = REF(A) AND
EQUALS_PATH(P.RES, ACL_PATH) = 1;
DBMS_XDBZ.ValidateACL(ACL_ID);
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_030200',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_030200', TRUE, 'connect');
END IF;
EXCEPTION
-- When no ACL has been assigned to '*'.
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
'ACL that lets power users to connect to everywhere',
'APEX_030200', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/
commit;
6.安装中文
①设置环境变量NLS_LANG
用鼠标选择开始->选择控制面板->选择性能和维护->选择系统->选择高级->选择环境变量->选择新建。在变量名处输入NLS_LANG，在变量值处输入American_America.AL32UTF8，之后一直选择确定就完成了操作系统环境变量的设置。
②启动DOS窗口
I:
cd app\apex
③sqlplus sys/密码as sysdba
④切换当前会话用户为APEX_030200
ALTER SESSION SET CURRENT_SCHEMA = APEX_030200;
⑤运行语言脚本文件
@I:\app\apex\builder\zh-cn\load_zh-cn.sql
7.核实和设置JOB_QUEUE_PROCESSES参数
SQL> SELECT VALUE FROM v$parameter WHERE NAME = 'job_queue_processes'；
SQL> show parameter job
8.核实并设置SHARED_SERVERS参数
SQL> show parameter shared_servers
SQL> ALTER SYSTEM SET SHARED_SERVERS = 5 SCOPE=BOTH;
SQL> show parameter shared_servers
OK,完成了Oracle Application Express的安装和配置了。^_^
页:
[1]