oracle application express...2 oracle application express 2- one the file is downloaded navigate to...

Oracle Apex

2012

Oracle Application Express Installation Guide Step by Step on Windows

Mohammad Fawzy Mahmoud

1 Oracle Application Express

Oracle Apex Installation Guide Step by Step on Windows

Install oracle XE database

1- Navigate to the following URL to download the database

http://www.oracle.com/technetwork/database/express-edition/downloads/index.html

http://www.oracle.com/technetwork/database/express-edition/downloads/index.html


2- One the file is downloaded navigate to the directory where the software has been downloaded

Right click on OracleXEUniv.exe and select properties.


3- Select Compatibility tab and then check Run this program in compatibility mode for option and

select Windows XP (Service Pack 3) from the list and in privilege level section check Run this

program as an administrator option then click OK button.


4- Double click on OracleXEUniv.exe to install oracle XE database.


5- Click Next button.


6- Select I accept the terms in the license agreement then click Next button.


7- Check the Oracle Database 10g Express Edition and the click Next button.


8- Specify the password for SYS & SYSTEM accounts then click Next button.


9- Review installation setting then click Install button to start the installation.


10- Check Launch the Database homepage then click Finish button.


Install Oracle Application Express

1- Navigate to the following the URL to download the Oracle Application Express 4.1

http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html


2- Navigate to C directory and then unzip the file:

3- Open windows command line then write cd /d C:\apex and press enter key to navigate to the apex

source folder.

4- Write sqlplus sys/syspassword@xe as sysdba and press enter key to connect the oracle XE

database.


5- After connected to the XE database successfully write @apexins sysaux sysaux temp /i/ to start

the Oracle Application Express installation.


6- After finish the above step successfully write sqlplus sys/syspassword@xe as sysdba to connect

to oracle XE database again.


7- After connected to the XE database successfully write @apxldimg c:\ then press enter key.


8- After finish the above step successfully write @apxconf to run the apexconf.sql script to change

the ADMIN password and HTTP PORT and press enter key the system asks you to enter the

ADMIN password enter ADMIN new password and press enter key.


9- The system asks you to enter the HTTP PORT if you want use the default http port [8080] press

enter key next.


10- To use the oracle application express with external access (via machines in the same LAN) just

write execute dbms_xdb.setListenerLocalAccess(l_access => FALSE); and press enter key as

following:

11- Open internet explorer then write the(http://machineipaddress:8080/apex/apex_admin)and press

enter key as following:

http://machineipaddress:8080/apex/apex_admin


12- Enter admin in user name field and admin password in password field then click Login button.

13- The application ask you to change the admin password enter the admin current password and new

password and confirm new password then click Apply Changes button.


14- Click Return button login with new password.

15- Enter admin in the username field and admin new password in the password field then click

Login button.

16- Click Logout button to log out form the application express.

oracle application express...2 oracle application express 2- one the file is downloaded navigate to...

Documents