Home > Uncategorized > Installing Application Express 3.1 on Oracle 10g 10.2.0.1.0

Installing Application Express 3.1 on Oracle 10g 10.2.0.1.0

In installing apex on Oracle 10g 10.2.0.1.0, i was getting a XDB Login Problem. I setup apex and entering the url path of apex, then browser ask me repeatedly xdb username and password. I tried lots of things that could not solve this problem. Especially this problem take place in Oracle 10g 10.2.0.1.0. I searched lots of web pages, forum, blogs then i found the solution.

Firstly, download the apex_3.1.1.zip in Oracle Web page. Then extract this file to Oracle Home.
When you type “dir /b” or “ls -la” in Oracle Home, you should see same this :

G:\oracle\product\10.2.0\db_3>dir /b
1907-b75f9673d7_orcl
admin
apex
assistants
BIN
cdata
cfgtoollogs
clone
com
config
….

So, type “cd apex” to enter this folder. Then run sqlplus as sysdba.
And execute the @apexins (apexins.sql).

Then, to change the ADMIN user password type the @apxxepwd.

After these, you should configure the Embedded PL SQL Gateway ( if you wont use the oracle http server like me).

Type @apex_epg_config to configure the plsql gateway.
Then, unlock the ANONYMOUS user, type “ALTER USER ANONYMOUS ACCOUNT UNLOCK”.
After these, now we are at the last point.
To enable XML DB HTTP SERVER :
exec dbms_xdb.sethttpport(7780);
// if you enter a port of used service, you can’t run the apex.
// so do not enter the Apache Tomcat Port : 8080

If XDB username and password is questioned, you should run this command:
( I found it after lots of searching )
EXEC DBMS_EPG.authorize_dad ( dad_name => ‘APEX’, user => ‘ANONYMOUS’ );

Now, you can try to login the Apex page via typing “http://localhost:7780/apex/apex_admin”.

If it asks still XDB username and password, you should read this blog and comments carefully.

http://jeffkemponoracle.blogspot.com/2007/07/apex-30-via-embedded-plsql-gateway.html

If you encounter any problem, send an email or comments.

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: