加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

Oracle Apex 5.0安装教程

发布时间:2020-12-12 14:45:09 所属栏目:百科 来源:网络整理
导读:1- The installation requires Before installing Oracle Application Express (Oracle APEX) you need to: Install Oracle Database (10g,11g or 12c) 2- Download Oracle APEX http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.ht
1 2 3 4 5 6 7 8 9 10 11 12 13 14 ---- Run script apexins.sql with parameters:---- @apexins.sql tablespace_apex tablespace_files tablespace_temp images---- Where:-- tablespace_apex is the name of the tablespace for the Oracle Application Express application user.-- tablespace_files is the name of the tablespace for the Oracle Application Express files user.-- tablespace_temp is the name of the temporary tablespace or tablespace group.-- images is the virtual directory for Oracle Application Express images.-- (To support future Oracle Application Express upgrades,define the virtual image directory as /i/.)--@apexins.sql sysaux sysaux temp/i/ Wait for about 30 minutes until the above statement is completed. The above script create some SCHEMAon Database,you can test by querying view ALL_USERSon SQLPlus:

4- Configuring APEX

You need log in SQLPlusagain from CMDand sign in sysuser as sysdba.

apex_egp_config.sql

This script will load the Application Expressimages into XDBand then configure a DADfor use by Application Expressin the Embedded PL/SQL Gateway. 6 -- Running script apex_epg_config.sql with parameter:-- @apex_epg_config.sql <parent of apex directory>--@apex_epg_config.sql C:DevPrograms

Unlock user anonymous:

3 -- Unlock user anonymous:alteruseranonymous account unlock;

apexconf.sql

Run script apexconf.sql

Used to perform the final configuration steps for Oracle Application Express,including setting the XDB HTTP listener portand Application ExpressADMIN password. 7 -- Running script: @apxconf.sql-- Setup password for ADMIN-- Configuring XDB Http Listener port--@apxconf.sql To user,you can use ADMINby default,and email can be skipped. To password,the system requires you to enter a strong password: Password does not conform to this site's password complexity rules.
  1. Password must contain at least 6 characters.
  2. Password must contain at least one alphabetic character (abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ).
  3. Password must contain at least one punctuation character (!"#$%&()``*+,-/:;?_).
  4. Password must contain at least one upper-case alphabetic character.
  5. Password must contain at least one lower-case alphabetic character.
Port default is 8080: The configuration has been completed.

5- Running Oracle APEX admin

  • http://localhost:8080/apex/apex_admin
You have successfully logged into the system of management of Oracle APEX:

6- Getting Started with Oracle APEX programming

Next you can be ready with Oracle APEX programming,you can read document:
  • Oracle APEX Tutorial for Beginners (APEX 5.0)

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

1- The installation requires

Before installing Oracle Application Express (Oracle APEX)you need to:
  1. InstallOracle Database(10g,11g or 12c)


2- Download Oracle APEX

  • http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
To download,you need to log in with an account of Oracle,if not,you can register a free account.

3- Installing Oracle APEX

Decompress zipfile you have downloaded in some position of hard disk drive. Here I decompress it at C:/DevPrograms.
Note: Your folder must be named apex.This is compulsory.
Open CMDand CDto apexdirectory: Next,enter sqlplus statement in order to log in sqlplus(Note: Don't open sqlplusdirectly. It should be through CMDafter CDto apexdirectory). Sign in to user sys,as sysdba. Login successful: Run script apexins.sql ?
    推荐文章
      热点阅读