I'm not sure where to begin. I had an excellent running 10g installation running Linux (RHEL 4). I had downloaded Application Express 3.0 and started installing the script. I had various errors on the install and realized that it should be going into 2nd home directory with Oracle HTTP Server. So I installed Oracle HTTP Server into a 2nd home directory named db_2. Somewhere in the process I had to reboot...and voila...the twilight zone begins.
It seems my environmental variables changed for oracle. I could not start the database, I couldn't login to sqlplus, i could not go to Oracle EM DBConsole.
After reading several posts, it appears my Listener.ORA forgot what SID I had and so I had to type that in. I also had to set my SID and Oracle Home using 'oraenv'.
I started the Listener at the command prompt and all came up just fine...or so I thought. The Listener displayed the SID. I was able to login into SQLPLUS and start up the database. I thought I was ok until...I went to a web page to access Oracle EM DBConsole. (http://host:1158/em
) It comes up saying "Database Instance APEX is down", "Listener status is down," and "Agent Connection to Instance" failed. I tried to "Startup" on the EM page but it failed. BUT when I go to sqlplus in the terminal session it says that the database is already running.
It seems that when I installed Oracle HTTP Server in the 2nd oracle home (db_2) that my environment got messed up. My original database installation for the sid 'APEX' is in oracle home (db_1).
I don't know what to do! Do I need to reinstall Oracle all over again? Please help!! I'm getting desperate.