Installing / Configuring APEX (Application Express / HTMLDB) in 10gR2 on Windows XP

Posted on April 16, 2008. Filed under: APEX / HTMLDB, Installation | Tags: , , , , , |

Apex 3.1 works with all versions above 9203, (including Oracle 11g). In this article the steps are defined for Installing apex_3.1 on 10gR2 (10.2.0.1)

Step 1: Download 10gR2 software (http://www.oracle.com/technology/software/products/database/index.html)
Step 2: Download 10gR2 Companion CD (for HTTP Server) (http://www.oracle.com/technology/software/products/database/index.html)
Step 3: Download apex_3.1 from http://apex.oracle.com or http://www.oracle.com/technology/products/database/application_express/download.html
Step 4: Install 10gR2 software and create a general database as part of installation
Step 5: Install 10gR2 companion CD – you will have two options (HTMLDB + HTTP Server or only HTTP Server) (I selected HTMLDB + HTTP Server, not a must though, since we will be installing apex_3.1)
Step 6: Stop both oracle DB and Apache server just installed.
Step 7: Start the DB and let apache be down.
Step 8: Unzip apex_3.1.zip (hereinafter referred as APEX_LOC)
Step 9: Pre-install requirements for APEX.
1. DB Requirement – Should be greater than 9203.
2. JVM Requirement – Need to be installed separetly if DB is less than 10gR1
3. Shared Pool Size of the database – ignore if sga_target is used, else it has to be atleast 100M;
4. HTTP Server (with mod_plsql) Requirements – Oracle9iR2 (9.2) or later / Oracle9iAS release 1 (1.0.2.2) or later / Oracle Database 10g Companion CD release 1 or 2 / Oracle Database 11g release 1
5. Space Requirement
For APEX Software Files – 450MB
For APEX objects (tablespace) – 125MB
SYSTEM Tablesapce – 85MB
6. Oracle XML DB Requirement – XML DB should be installed in the database
7. Oracle Text Requirement – for Searchable online help in APEX
8. PL/SQL Web toolkit – required Version 10.1.2.0.6 (10gR2 brings in 10.1.2.0)

In our approach, (10gR2 DB + 10gR2 Companion CD 1) we had satisfied 1,2,3,4 & 6 requirements. Perform below steps to satisfy 5, 7 & 8.

For 5: We can create a separate tablespace for APEX objects or we can use SYSAUX tables. Add appropriate datafiles to the tablespaces to meet the required free space.
For 7: Connect to db as ctxsys user and execute @ORACLE_HOME\ctx\admin\defaults\drdefus.sql (substitute ORACLE_HOME with actual path)
For 8: Go to the location where you had extracted apex_3.1 zip (APEX_LOC). Connect to db as sys user and execute owainst.sql (under apex\owa directory)
Execute “select owa_util.get_version from dual;” to verify the pl/sql web toolkit version.

Step 10: Install APEX 3.1
– Goto the location where you had extracted apex_3.1 zip. change location to apex directory under APEX_LOC.
– Connect to database as sys user and execute below command
– @apexins TS1 TS2 TEMP_TS /i/

TS1 => SYSAUX or (tablespace created for APEX)
TS2 => SYSAUX or (tablespace created for APEX)
TEMP_TS => Temporary tablesapce
/i/ => Location to store APEX Images (no need to mention any path, just leave it as /i/)
eg:(@apexins APEX_DATA APEX_DATA TEMP /i/)

Installation logfile will be located under APEX_LOC as installYYYY-MM-DD_HH24-MI-SS.log.

Step 11: Change Password for ADMIN Account
– Change directory to apex
– Connect to DB as sys user and execute
– @apxchpwd

(ADMIN user is the super user account simillar to SYS for DB)

Step 12: Configure HTTP Server
Step 12.1: Unlock APEX_PUBLIC_USER Account & change password

– Connect to db as sys user
– alter user apex_public_user account unlock;
– alter user apex_public_user identified by NEW_PASSWORD;

Step 12.2: Copy APEX Images
– Open APACHE_ORACLE_HOME/Apache/modplsql/conf/marvel.con to identify default location set for images (/i/) (Hereinafter referred as IMAGE_LOC)
– Goto the location identified above (eg.C:/oracle/product/as/1020/htmldb/images/)
– Rename the images directory to images_old
– Copy APEX_LOC/apex/images to C:/oracle/product/as/1020/htmldb/

Step 12.3: Adding DAD entry to connect to APEX
– Open APACHE_ORACLE_HOME/Apache/modplsql/dad.conf
– Past below entry

Alias /i/ “[ Put the IMAGE_LOC Value] ”
AddType text/xml xbl
AddType text/x-component htc

<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString hostname:port:SID
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword APEX_PASSWORD
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
Allow from all
</Location>

Make sure these values are properly set before saving this file (marvel.conf)

1. IMAGE_LOC Value
2. hostname:port:SID => eg: localhost:1521:ORCL
3. APEX_PASSWORD => eg: password_you_had_selected_on_step_12.1

IF all the above values are set, save the file as marvel.conf

Step 13: Start HTTP Server (Start -> Programs -> Oracle)

Step 14: Access the admin page of APEX

http://hostname:port/pls/apex/apex_admin

Username: ADMIN
Password: PASSWORD_SELECTED_WHILE_RUNNING_apxchpwd

 Sample Screen: https://oraclepitstop.files.wordpress.com/2008/04/apex_admin_screen1.jpeg

cheers,
OraclePitStop

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

22 Responses to “Installing / Configuring APEX (Application Express / HTMLDB) in 10gR2 on Windows XP”

RSS Feed for OraclePitStop – Lets share some knowledge Comments RSS Feed

I`m very happy that i found this article and soon will start working from step one. Hope everything will pass fine. Thanks for the guide.

All the best Jeremija. The above steps worked for me, so it should work for you too :-).

cheers,
Ram.

I tried insatlling Apex on 10g in Linux and it installs fine but when I start it up and try accessing Apex, i get Ora-604 in the error logs and the browser just says Service Temporarily available. Does any one know why Im gettignm this error ?

Hi Ash,

Can you give more details regarding your error. Is the http server up and running.

Ash,

Check Metalink Note:311314.1.

cheers,
Ram.

Article is great. Quick question in regard to space requirements. What’s a quick way to verify the requirements?

Article helpped me speed up the process of installing by being a bit more in-depth detailed, but still some stuff is confusing for a lot of begginners.. :S

i still can’t get past thru the HTTP stuff.
i thought Oracle 10g XE came with its own HTTP server.

Thanks for the comment and you are right about Http in Oracle 10g XE. I guess the title of the article had confused a bit, this article is to install APEX 3.1 over Oracle 10g on Windows XP :-). I havent tried Apex on Oracle 10g XE but im sure the HTTP configuration steps should be same.

cheers,
OraclePitStop.

Thanks for the article,
But after follow this ich got the message:
Service Temporarily unavailable.
Im using Oracle 10.2 Database on windows 2003 Server. The Http-Server is running.
Can anyone give me assistance?

Regards Frank

Hi Frank,

There could be multiple reasons for this issue. Please do check for the following components – 1) Database Listener, 2) HTTP Servers – access and error log. The log files should give you more information. Even i had this issue once – it just came up out of the blue – found out the problem was with the Oracle Database listener – the sid of the database was not registered which caused the issue.

cheers,
OraclePitStop

hi,
i have problem with PlsqlRequestValidationFunction. in httpserver log there is an error like that :

Syntax error on line 19 of c:/orahome1/apache/modplsql/conf/dads.conf:
Invalid command ‘PlsqlRequestValidationFunction’, perhaps mis-spelled or defined by a module not included in the server configuration

do you have any workaround or something about this problem.

thank you.

Hi Kerim,

You have couple of options here to debug/solve this issue.

Option 1. Paste the dads.conf content, so that we can have a look at it.
Option 2. Take a backup of your dads.conf and remove the entire line PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
and start apache again.

PlsqlRequestValidationFunction is an add-on security feature which enables/disables direct access to a database package from the browser ie., using http/https.

I had tried option 2 on my local apex install and it works without any problem. Give it a shot and let us know the outcome.

cheers,
OraclePitStop.

After spending a few days on how to get apex
installed with existing 10gR2 database and
trying to make sense of the unclear install
instructions that came with the standalone
apex, this article was a life saver. Thank for
the help..

Thanks Paul.

cheers,
OraclePitStop.

I was having issues getting App Express to install correctly, being a newbie did not help. Google is my friend. Found this guide and then I finally got App Express to install. Checked to see if all required apps were installed according to the guide and they were. But I still had problems with App Express, this time though the web browser was stating something along these lines ‘Part of the page or components require an application that is not installed’. By this time a week had gone by. Finally found out that the PC did not have JAVA installed. So I installed the latest version of JAVA and rebooted the computer and tried App Express agian. Presto, finally can get to the Admin Login page but no images. Checked the marvel.conf file and the location was incorrect fixed the issue and retried. Finally everything works. WHEW!!!
Now comes the fun part of learning a new app. Thank you for creating this guide it helped out in a big way..

Thanks Clinton.

cheers,
OraclePitStop.

IT IS VERY GOOD SITE FULL OF INFORMATION.

Thanks Younas.

cheers,
OraclePitStop

excellent article.
Now how do I clone this db with apex to DEV and test??

One more thing :
First, probably on your installation the default port is 7777, but never forget to check also the 7778 port ( HTTP server from companion cd 10.2 installs default on 7778 port , even you can see also some page on 7777 port ). Anyway, Apex won’t work unless you try to login on 7778 port .

And , be aware that the correct form is :
PlsqlDatabaseConnectString DATABASEHOST:PORT:SID ServiceNameFormat

Don’t forget ServiceNameFormat !!!

And … if you can’t log in to pls/apex/apex_admin , try to login a pls/apex with workspace INTERNAL and username ADMIN

Hope this will help.

Hi,
When I am trying to start apex it is not starting
and the error message in error log says /pls/apex
is disabled because of mis configuration.
Please see the marvel.conf and dads.conf below.

marvel.conf
———–
Alias /i/ “/opt/oracle/product/HTDB/htmldb/images/”
AddType text/xml xbl
AddType text/x-component htc

Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_manager.process_download
PlsqlDatabaseConnectString secmis02:1521:misdev ServieNameFormat
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword dp123
Allow from all

dads.conf
———

Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_manager.process_download
PlsqlDatabaseConnectString secmis02:1521:misdev
PlsqlNLSLanguage AMERICAN_AMERICA.WE8ISO8859P1
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword dp123
Allow from all

Thanks,
DP

Hi,
Can we install 10gR2 companion CD – with (HTMLDB + HTTP Server) – STEP 5 – in a different machine than Oracle 10GR2 – STEP 4 ?
If yes, did we have something special to do ?
Thanks
Eric


Where's The Comment Form?

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: