oracle安装全流程,安装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的安装和配置了。^_^