Oracle Database Discussions

Hi, I just downloaded and installed the Oracle Database 10g Express edition. It installed smoothly without any problems and I used all the default settings.

If I try to go the database home page (http://127.0.0.1:8080/apex) it tells me the page can not be found.

What I have tried is:
- Added the above page to my list of Internet Explorer trusted sites. No effect.
- I read that Windows might have problems with port 8080 and tried to change it using SQL command line, but that did not go well:

SQL> exec dbms_xdb.sethttpport(8087);
SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> connect
Enter user-name: SYS
Enter password:
ERROR: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

What gives? I would guess the Oracle HTTP server is missing but supposedly it gets installed with the package? I also installed the Oracle client piece, but that didnt change anything.

There is no firewall on the machine, after installation I installed Apache on there in case it needed it, but Apache runs fine but it didnt fix anything. Also running MySQL and MSSQL and installed and used them on that machine without any problems.

The machine is a dual processor HP 2 GB RAM machine running Windows XP Pro with SP2. I heard earlier editions might not run on dual processor machines but apparently that is not an issue anymore. We dont have any single processor machines so I can test it to see if that is it.

I am working on an engineering application that supports SQL Server, Jet, and MySQL. We want to make it also work for clients who want to use Oracle, assuming I can of course get the Oracle database to work in the first place.

Any ideas? OracleServiceXE is running as is OracleXETNSListener. Listening but nobody home it seems..

It funny how all the databases require some extra adminstration or query piece to be downloaded separately and installed as well. It looked like the Oracle package has all the pices you need.

Any suggestions would be appreciated.