Oracle APEX 3.2 安装

矫情吗；* 2022-09-30 03:50 213阅读 0赞

### 前几时帮朋友安装了一个APEX 3.2环境，参照网上的文档和官方文档进行安装，顺利完成。 ###

### APEX安装前的准备 ###

登录系统：sqlplus system/0621  
1.   从数据字典v$instance中获取数据库的实例名和版本号：

SQL> conn system/oracle

Connected.

SQL> show user;

USER is "SYSTEM"

SQL> select instance\_name,version from v$instance;

INSTANCE\_NAME    VERSION

\---------------- -----------------

ORCL             11.1.0.6.0

2.        从数据字典v$version中获取版本的详细信息：

SQL> select \* from v$version;

BANNER

\--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

PL/SQL Release 11.1.0.6.0 - Production

CORE    11.1.0.6.0      Production

TNS for Linux: Version 11.1.0.6.0 - Production

NLSRTL Version 11.1.0.6.0 – Production

3.确认oracle所使用的参数文件是否为二进制的参数文件（spfile表明为二进制文件）：

SQL> show parameter pfile

NAME                           TYPE        VALUE

\------------------------------------ ----------- ------------------------------

spfile                              string      /u01/oracle/dbs/spfileORCL.ora

4. 确认oracle是否使用的是自动内存管理：

SQL> show parameter memory\_target

NAME                                 TYPE        VALUE

\------------------------------------ ----------- ------------------------------

memory\_target                        big integer 396M

5. 查看表空间是否为自动扩展：

SQL> select tablespace\_name, autoextensible from dba\_data\_files;

TABLESPACE\_NAME                AUT

\------------------------------ ---

USERS                          YES

UNDOTBS1                       YES

SYSAUX                         YES

SYSTEM                         YES

EXAMPLE                        YES

PEIHU                          NO

PEIHU                          YES

7 rows selected.

### 嵌入式PL/SQL网关配置 ###

使用嵌入式PL/SQL网关（也称连接器，Gateway）安装和配置Oracle Application Express的具体步骤如下：  
1.       安装Oracle Application Express.

1.1先进入到APEX的解压根目录

我的目录是/u01/apex(这个一定要做，否则等下无法正确安装)

\[oracle@oracle11g ~\]$ cd /u01/apex

\[oracle@oracle11g apex\]$ ls

apex\_epg\_config\_core.sql  apxe111.sql   core

apex\_epg\_config.sql       apxldimg.sql  coreins.sql

apexins.sql               apxpatch.sql  devins.sql

apexvalidate.sql          apxrelod.sql  doc

apxchpwd.sql              apxremov.sql  endins.sql

apxconf.sql               apxrtins.sql  images

apxdbmig.sql              apxsqler.sql  install2011-03-14\_01-45-58.log

apxdevrm.sql              apxxemig.sql  load\_trans.sql

apxdvins.sql              apxxepwd.sql  owa

apxe101.sql               builder       utilities

apxe102.sql               catapx.sql

1.2然后用SYS身份登陆

SQL> conn / as sysdba

Connected.

SQL> show user

USER is "SYS"

1.3安装脚本

SQL> @apexins SYSAUX SYSAUX TEMP /i/

其中：apexins为安装脚本文件名称

SYSAUX SYSAUX 第一个SYSAUX为数据存放的表空间，第二个为用户信息存放表空间

TEMP为排序所用的表空间

/i/表示EXPRESS中存放的虚拟目录

1.4检查是否安装完毕

SQL> select username,created from dba\_users

2  where username like 'APEX%';

USERNAME                       CREATED

\------------------------------ ---------

APEX\_030200                    14-MAR-11

APEX\_PUBLIC\_USER               03-AUG-07

SQL> select username,created from dba\_users  where username like 'FLOW%';

USERNAME                       CREATED

\------------------------------ ---------

FLOWS\_FILES                    03-AUG-07

FLOWS\_030000                   03-AUG-07

2.       修改Admin帐户密码

SQL> @apxchpwd

Enter a value below for the password for the Application Express ADMIN user.

Enter a password for the ADMIN user              \[\]

输入你的密码:oracle

Session altered.

...changing password for ADMIN

PL/SQL procedure successfully completed.

Commit complete.

3.       配置嵌入式PL/SQL网关。

SQL> @apex\_epg\_config  /u01/apex

PL/SQL procedure successfully completed.

Directory created.

declare

ERROR at line 1:

ORA-22288: file or LOB operation FILEOPEN failed

No such file or directory

ORA-06512: at "SYS.XMLTYPE", line 296

ORA-06512: at line 18

Commit complete.

PL/SQL procedure successfully completed.

timing for: Load Images

Elapsed: 00:00:03.68

Session altered.

PL/SQL procedure successfully completed.

Commit complete.

Session altered.

Directory dropped.

错误原因是目录不对。解决办法：   
改 /tmp 为你解压apex后所在的目录，例如我的是：/u01/apex，那么/tmp为/u01

文档做了注释，但地方不对，在@apxldimg.sql是有如下说明：

引用

Tip:  
The above examples assume that you unzipped Oracle Application Express in a directory called TEMP on Windows and tmp on UNIX or Linux.

纠正后如下：

SQL> @apex\_epg\_config  /u01

PL/SQL procedure successfully completed.

Directory created.

PL/SQL procedure successfully completed.

Commit complete.

PL/SQL procedure successfully completed.

timing for: Load Images

Elapsed: 00:01:45.40

Session altered.

PL/SQL procedure successfully completed.

Commit complete.

Session altered.

Directory dropped.

4.   核实和开启Oracle XML DB HTTP服务器的端口。

4.1查看端口是否开启，为0未开启，大于0表示开启

SQL> select DBMS\_XDB.GETHTTPPORT FROM DUAL;

GETHTTPPORT

\-----------

4．2开启制定端口

SQL> exec DBMS\_XDB.SETHTTPPORT(8080);

PL/SQL procedure successfully completed.

4.3 再次查询

SQL>  select DBMS\_XDB.GETHTTPPORT FROM DUAL;

GETHTTPPORT

\-----------

8080

5.  开启Oracle 11g数据库中的网络服务

在SQL中运行开启网络服务语句如下：

SQL>

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;

PL/SQL procedure successfully completed.

6.将用户解锁

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

User altered.

7.               安装中文语言。

\[oracle@oracle11g ~\]$ set NLS\_LANG=American\_America.AL32UTF8

\[oracle@oracle11g ~\]$ sqlplus / as sysdba

SQL> ALTER SESSION SET CURRENT\_SCHEMA = APEX\_030200;

Session altered

SQL> @/u01/oracle/apex/builder/zh-cn/load\_zh-cn.sql

8.       设置JOB\_QUERY\_PROCESS参数。

查看参数值：

SQL> SELECT VALUE FROM v$parameter WHERE NAME ='job_queue_processes';

VALUE

---------------------------------------------------

1000

得到的值如果为20以上，则无需更改，否则更改命令如下

SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 100

9.       配置SHARED\_SERVER参数。

SQL> ALTER SYSTEM SET SHARED\_SERVERS = 5 SCOPE=BOTH;

SQL> show parameter shared\_servers;

NAME                                 TYPE        VALUE

\------------------------------------ ----------- ------------------------------

max\_shared\_servers                   integer

shared\_servers                       integer     5

### 开启数据库监听和数据库EM ###

\[oracle@oracle11g ~\]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 14-MAR-2011 05:04:28

Starting /u01/oracle/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - Production

System parameter file is /u01/oracle/network/admin/listener.ora

Log messages written to /u01/diag/tnslsnr/oracle11g/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle11g)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11g)(PORT=1521)))

STATUS of the LISTENER

\------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production

Listener Parameter File   /u01/oracle/network/admin/listener.ora

Listener Log File         /u01/diag/tnslsnr/oracle11g/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle11g)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

The listener supports no services

The command completed successfully

\[oracle@oracle11g ~\]$ emctl start dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0

https://oracle11g:1158/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control ............. started.

\------------------------------------------------------------------

Logs are generated in directory /u01/oracle/oracle11g\_ORCL/sysman/log

### 设置本地环境 ###

1.       登陆APEX管理服务

输入网址登陆

附件为：[官方下载文档和网上参考文档][Link 1]

[Link 1]: http://download.csdn.net/source/3147483

Oracle APEX 3.2 安装

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Oracle APEX应用部署常见问题及解决方案

相关 oracle32 plsql,plsql32 链接oracle64

相关 CentOS7部署Oracle-19c Apex

相关 Docker部署Oracle-19c Apex Ords

相关 Docker部署Oracle-xe Apex Ords

相关 oracle apex登录,Oracle数据库11.2 Express Edition Beta 版有默认的APEX用户和默认密码

相关 Apex 调用 apex写的rest

相关 Oracle APEX 3.2 安装

相关混合精度工具apex安装

相关 apex的实践