安装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> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

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的安装和配置了。^_^

转载于:https://blog.51cto.com/4610383/1251929