Installing Oracle Application Express on XE http://www.dbcon.com This document is a step-by-step guide to install Oracle Express Edition Database (XE) on Microsoft Windows platform and then install Oracle Application Express on Oracle XE Database.
2
Installing Oracle Application Express on XE
Contents Installing Oracle XE on Windows ............................................................................................................ 3 Installing Latest Version of Oracle Application Express on Oracle XE database ................................... 14 Performing Full Installation of Oracle Application Express............................................................... 14
http://www.dbcon.com http://dbcon.blogspot.com
3
Installing Oracle Application Express on XE
Installing Oracle XE on Windows 1.
Navigate to URL http://www.oracle.com/technology/software/products/database/xe/index.html to download Oracle XE database.
2.
Click on the platform version of Oracle XE database that you would like to install.
http://www.dbcon.com http://dbcon.blogspot.com
4
Installing Oracle Application Express on XE
3.
Click on Accept License Agreement to be able to download the database
4.
Depending on the language that you intend to use, click on the Oracle Database edition that you would like to install. It is better to install multi-byte Unicode database so that all the languages can be used, if required.
http://www.dbcon.com http://dbcon.blogspot.com
5
Installing Oracle Application Express on XE
5.
To be able to download the Oracle XE Database software, you need to logon to Oracle Technology Network. If you are member of OTN enter your username and password. If you are not a member yet, sign up for OTN membership using ‘sign up now’ link. It’s free.
6.
Click on ‘Save File’
http://www.dbcon.com http://dbcon.blogspot.com
6
Installing Oracle Application Express on XE
Oracle XE database software will be downloaded to your disk. Wait for the download to finish. Depending on your internet connection it may take a while.
7.
One the file is downloaded navigate to the directory where the software has been downloaded. Double click on OracleXEUniv.exe to install Oracle XE database.
http://www.dbcon.com http://dbcon.blogspot.com
7
Installing Oracle Application Express on XE
Click ‘Next’
Accept the License Agreement. Click ‘Next’
http://www.dbcon.com http://dbcon.blogspot.com
8
Installing Oracle Application Express on XE
Select the folder where you want to install Oracle XE. Click ‘Next’
Specify the password for SYS & SYSTEM account. You can change the passwords later on also. Specify password as ‘xe’. Click ‘Next’
http://www.dbcon.com http://dbcon.blogspot.com
9
Installing Oracle Application Express on XE
Click ‘Install’ to start the installation.
Wait for the installation to finish.
http://www.dbcon.com http://dbcon.blogspot.com
10
Installing Oracle Application Express on XE
Check the ‘Launch Database homepage’ and Click ‘Finish’
http://www.dbcon.com http://dbcon.blogspot.com
11
Installing Oracle Application Express on XE
Logon to database home page to ensure that you are able to logon and the database has been installed successfully. Enter the username as ‘SYSTEM’ and the password that you specified in the previous step. If you specified your password as ‘xe’ then enter ‘xe’ as password.
http://www.dbcon.com http://dbcon.blogspot.com
12
Installing Oracle Application Express on XE
Once you have verified that you can login, click on ‘Logout’.
http://www.dbcon.com http://dbcon.blogspot.com
13
Installing Oracle Application Express on XE
http://www.dbcon.com http://dbcon.blogspot.com
14
Installing Oracle Application Express on XE
Installing Oracle Application Express on Oracle XE database Oracle Application Express is available in two installation formats. a.
One is the full installation of the latest version of Oracle APEX. If you do not already have installed APEX then you can download and install the full installation. Full installation of Oracle APEX software is available at URL http://www.oracle.com/technology/products/database/application_express/download.html .
b.
Second is the patch set that needs to be installed on the existing version. If you are already using Oracle Application Express, then you need to download and install the patch set to upgrade your Oracle Application Express to the latest version. The patch set to upgrade to the latest version of Oracle APEX is available on http://metalink.oracle.com . Go to URL http://www.oracle.com/technology/products/database/application_express/index.html to find out the patch number for the latest patch set version.
Performing Full Installation of Oracle Application Express 1.
If not already done so, download the latest version of Oracle Application Express from OTN. Go to URL http://www.oracle.com/technology/products/database/application_express/download.html to get the latest version of Oracle APEX.
2.
Click on ‘Accept License Agreement’.
http://www.dbcon.com http://dbcon.blogspot.com
15
Installing Oracle Application Express on XE
If you want to download a prior release of Oracle Application Express, click here.
3.
Click on ‘Download’ to download Oracle Application Express.
4.
Provide your OTN user id and password to be able to download the software. If you do not have account with OTN, you’ll need to register yourself first to be able to download the software. The registration is free. Provide your username & password. Click ‘Continue’
http://www.dbcon.com http://dbcon.blogspot.com
16
Installing Oracle Application Express on XE
The software will be downloaded to your PC
5.
Once downloaded navigate to the directory where you have downloaded the software and unzip the file.
6.
Unzip the file in the same directory.
http://www.dbcon.com http://dbcon.blogspot.com
17
Installing Oracle Application Express on XE
Once unzipped, you will see a folder with the name ‘apex’ inside the folder where you have unzipped the file.
7.
To install Oracle APEX on Oracle XE database Click on ‘Start’ –> ‘Run’
http://www.dbcon.com http://dbcon.blogspot.com
18
Installing Oracle Application Express on XE
8.
Type ‘cmd’ in the run window and press enter to go to the command window.
9.
Navigate to the directory where you have unzipped the apex installation files. Set the environment and logon to Oracle XE database. If you have not installed Oracle XE database under “ c:\oraclexe “ path then replace this value with the path where you have installed Oracle XE Database.
http://www.dbcon.com http://dbcon.blogspot.com
19
Installing Oracle Application Express on XE
You can copy paste the following to avoid typing errors. set ORACLE_HOME=c:\oraclexe\app\oracle\product\10.2.0\server set ORACLE_SID=XE set PATH=%ORACLE_HOME%\bin;%PATH%
10. Run the following command to install APEX in the database. @apexins SYSAUX SYSAUX TEMP /i/
Once installation finishes you should be seeing the following messages on the screen.
http://www.dbcon.com http://dbcon.blogspot.com
20
Installing Oracle Application Express on XE
11. Review the contents of the log file to ensure that no errors were encountered during the installation. The log file name is in the format of install
.log
12. Connect to database as SYSDBA user and run the following command to load the images in Oracle XE Database. @apxldimg c:\
http://www.dbcon.com http://dbcon.blogspot.com
21
Installing Oracle Application Express on XE
Once the images are uploaded successfully, you should be seeing the following message on your screen.
Exit from sqlplus by typing ‘exit’ 13. Connect again to database as SYSDBA user and run apxxepwd.sql to change the password for Oracle Application express ‘ADMIN’ user. Specify the password when prompted and remember it. @apxxepwd.sql
http://www.dbcon.com http://dbcon.blogspot.com
22
Installing Oracle Application Express on XE
Exit from sqlplus by typing ‘exit’ Now you should be able to access your Oracle Application Express Administration Services by opening the internet browser and typing the URL http://127.0.0.1:8080/apex/apex_admin 14. However if you want others to be able to access the application express through network, or if you want to access Oracle Application Express using your PC’s hostname and domain name (e.g. http://hostname.domain:port/apex/apex_admin ) connect again to database as SYSDBA user and run the following command execute dbms_xdb.setListenerLocalAccess(l_access => FALSE) ;
http://www.dbcon.com http://dbcon.blogspot.com
23
Installing Oracle Application Express on XE
15. Open the browser, type the URL in format http://hostname.domain:8080/apex/apex_admin and you should be seeing the following screen. The username is ‘admin’ and the password is the password that you specified in step 13. Enter the username & the password and click on ‘Login’.
16. When logging on for the first time, you will need to change the password for admin user. Specify the old password, the new password and click on ‘Apply Changes’
http://www.dbcon.com http://dbcon.blogspot.com
24
Installing Oracle Application Express on XE
17. Click ‘Return’ to return to the login page.
18. Logon with the new password.
http://www.dbcon.com http://dbcon.blogspot.com
25
Installing Oracle Application Express on XE
Now you are logged on to APEX Administration service and is ready to use APEX. Start by clicking on ‘Manage Workspace’ and create a new workspace. Then logout of APEX Administration service and login to your workspace using the URL http://hostname.domain:8080/apex .
If you would like to learn how to Develop Applications in Oracle Application Express, check out our training program at URL http://www.dbcon.com/courses.html . We offer Live Online
http://www.dbcon.com http://dbcon.blogspot.com
26
Installing Oracle Application Express on XE
Training in Oracle Application Express which can be attended by anyone from anywhere in the world. All you need is a computer and internet connection. We will give you your own dedicated workspace to practise 24 hours a day. In an unlikely event that you are not satisfied or feel that this training is not benefitting to you, you can get your entire money back. No questions asked. For training enquiry or any comments/feedback on this document, please send e-mail [email protected] . For more free tutorials on Oracle Application Express please visit http://dbcon.blogspot.com . Regards, Team DBCON http://www.dbcon.com
http://www.dbcon.com http://dbcon.blogspot.com