تثبيت Install Oracle Apex 5

بتاريخ: 13 ديسمبر 201510 سنة

هذا الشرح منقول من هذا الموقع

http://o7planning.org/web/fe/default/en/document/349698/guide-to-installing-and-configuring-oracle-apex

و احببت ان اضعه بين ايديكم للافادة

Guide to installing and configuring Oracle Apex 5.0

You can reference how to install Oracle Database 11g at:

http://o7planning.org/web/fe/default/en/document/19744/guide-to-installing-and-configuring-oracle-database-11g

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 zip file 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 CMD and CD to apex directory:

Next, enter sqlplus statement in order to log in sqlplus (Note: Don't open sqlplus directly. It should be through CMD after cd to apex directory).

Run script apexins.sql

-- 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 SCHEMA on Database, you can test by querying View ALL_USERS on SQLPlus:

4- Configuring APEX ▴

You need log in SQLPlus again from CMD and sign in sys user as sysdba.

apex_egp_config.sql

This script will load the Application Express images into XDB and then configure a DAD for use by Application Express in the Embedded PL/SQL Gateway.

-- 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:

-- Unlock user anonymous:

alter user anonymous 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 port and Application Express ADMIN password.

-- Running script: @apxconf.sql

-- Setup password for ADMIN

-- Configuring XDB Http Listener port

@apxconf.sql

To user, you can use ADMIN by 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.

Password must contain at least 6 characters.
Password must contain at least one alphabetic character (abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ).
Password must contain at least one punctuation character (!"#$%&()``*+,-/:;?_).
Password must contain at least one upper-case alphabetic character.
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:

http://o7planning.org/web/fe/default/en/document/359323/oracle-apex-tutorial-for-beginners

اقتباس

تقديم بلاغ

تسجيل دخول

تثبيت Install Oracle Apex 5

Featured Replies

انضم إلى المناقشة

برجاء الإنتباه

Account

Navigation

البحث

إعداد إشعارات المتصفح الفورية

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)