Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX not working

511496May 7 2006 — edited May 8 2006
Hi,

I removed the old database 'XE' and created a new one also named 'XE' in another location via the CREATE DATABASE command. The database was created successfully and I ran the catalog scripts that creates the data dictionary views. However, when I tried accessing the Database Home Page via http://127.0.0.1:8080/apex, I get a page not found error. In fact, even just accessing http://127.0.0.1 gives this error. I can access this page before I removed the old XE and I can use the new database I just created in development work. Now I end up using sql commands in order to do administrative work that the Home Page provides.

Can you guys tell me how do I activate the Database Home Page again for my new database?

Thanks.

Comments

Hans Forbrich
Apex consists of a number of table, view, index, etc. and stored procedure definitions that exist inside the database. So the obvious question is:

When you created the database, using the create database command, what additional steps did you take to load all of the Apex related schema?

In other words, please provide in detail all the steps you used to get the 'database' to it's current state.
511496
Thank you for your reply. I followed these steps when I created the database:

1. Create a new spfile

2. Used the SQL Plus command prompt provided in XE install and logged in using:

conn / as sysdba

Login was successful.

3. Shutdown the database using "shutdown normal".

4. Startup the database using the following:

startup nomount pfile = <path to file which points to spfile>

Database mounted successfully.

5. Issue the create database command. Database was created successfully.

6. Opened the database.

7. Logged in as SYSTEM and run the following scripts: catalog.sql and catproc.sql

8. Bounced the database (just paranoid =)

9. Navigate to http://127.0.0.1:8080/apex. The page now cannot be accessed.

Looks like I need to run more scripts to enable this URL to work?

Your help is appreciated.

Thanks.
dave sharples
APEX doesnt get installed as part of the database itself (it is a seprate application) not even sure if the scripts to create it are delivered with XE.

Also you said you ran catalog and catproc as system. These should always be run as SYS, if you ran then as system then you have a non functioning database

Is there a reason you created a new database? to solve a problem. The quiest way to get it back would be do uninstall XE and then reinstall
511496
Oops, sorry, I did ran catalog and catproc as SYS instead of SYSTEM and the database is working fine - I'm able to create tablespaces, tables, do CRUD, view data dictionary views,etc.

When I first installed XE I noticed that it already came with a starter database that is installed under a default location under the install base directory. I can't remember the installer allowing me to choose which directory to install. I'm using the java installer.

I have a separate disk containing all the database files I'm using - SQL Server, MySQL, Postgres, etc. I decided to place my XE datafiles here also so that I won't change any of my backup procedure. Hence, I deleted the old files and created a new database whose data files point to this location. All is working perfectly except for the apex page. Can this mean that creating a new database will not allow it to be managed by apex?

Thanks.
dave sharples
You used the java installer? there is no java installer for XE?

As for moving datafiles, you can do that without having to re-create the database without a problem.

Suggest reinstalling XE and then we can talk about moving datafiles to where you want them to go.

I dont think the apex install scripts are delivered, so no might not be able to get APEX working on that database
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 5 2006
Added on May 7 2006
5 comments
627 views