10g on Linux (RHEL) with HTTP Server (Won't Start Up)
Hello...
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.
Thx much!
Ken
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.
Thx much!
Ken
Can you try to set the env variables for 1st oracle home and let us know if it helps?
Oracle Server and other products should be installed in different Oracle homes.
It seems it will be better to install different products in different schemas.
I think that your PATH variable can not serve both installations - it starts the first met executable, but it may be not from the correct Home.
You can recreate the repository of OEM:
You can try to recreate the OEM repository first:
To recreate the configuration files and repository for Database Console, run:
$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Jul 24, 2006 10:08:20 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: TESTDB
Database Control is already configured for the database TESTDB
You have chosen to configure Database Control for managing the database TESTDB
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener port number: 1521
Password for SYS user: change_on_install
Password for DBSNMP user: manager
Password for SYSMAN user: manager
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
--------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/10
Database hostname ................ linux3
Listener port number ................ 1521
Database SID ................ TESTDB
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
--------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 24, 2006 10:08:50 PM oracle.sysman.emcp.EMConfi
INFO: This operation is being logged at /u01/app/oracle/product/10
Jul 24, 2006 10:08:53 PM oracle.sysman.emcp.util.DB
INFO: Stopping Database Control (this may take a while) ...
Jul 24, 2006 10:09:29 PM oracle.sysman.emcp.EMRepos
INFO: Dropping the EM repository (this may take a while) ...
Jul 24, 2006 10:11:23 PM oracle.sysman.emcp.EMRepos
INFO: Repository successfully dropped
Jul 24, 2006 10:11:23 PM oracle.sysman.emcp.EMRepos
INFO: Creating the EM repository (this may take a while) ...
Jul 24, 2006 10:15:09 PM oracle.sysman.emcp.EMRepos
INFO: Repository successfully created
Jul 24, 2006 10:15:18 PM oracle.sysman.emcp.util.DB
INFO: Starting Database Control (this may take a while) ...
Jul 24, 2006 10:17:21 PM oracle.sysman.emcp.EMDBPos
INFO: Database Control started successfully
Jul 24, 2006 10:17:22 PM oracle.sysman.emcp.EMDBPos
INFO: >>>>>>>>>>> The Database Control URL is http://linux3:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 24, 2006 10:17:22 PM
It seems it will be better to install different products in different schemas.
I think that your PATH variable can not serve both installations - it starts the first met executable, but it may be not from the correct Home.
You can recreate the repository of OEM:
You can try to recreate the OEM repository first:
To recreate the configuration files and repository for Database Console, run:
$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Jul 24, 2006 10:08:20 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: TESTDB
Database Control is already configured for the database TESTDB
You have chosen to configure Database Control for managing the database TESTDB
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener port number: 1521
Password for SYS user: change_on_install
Password for DBSNMP user: manager
Password for SYSMAN user: manager
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
--------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/10
Database hostname ................ linux3
Listener port number ................ 1521
Database SID ................ TESTDB
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
--------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 24, 2006 10:08:50 PM oracle.sysman.emcp.EMConfi
INFO: This operation is being logged at /u01/app/oracle/product/10
Jul 24, 2006 10:08:53 PM oracle.sysman.emcp.util.DB
INFO: Stopping Database Control (this may take a while) ...
Jul 24, 2006 10:09:29 PM oracle.sysman.emcp.EMRepos
INFO: Dropping the EM repository (this may take a while) ...
Jul 24, 2006 10:11:23 PM oracle.sysman.emcp.EMRepos
INFO: Repository successfully dropped
Jul 24, 2006 10:11:23 PM oracle.sysman.emcp.EMRepos
INFO: Creating the EM repository (this may take a while) ...
Jul 24, 2006 10:15:09 PM oracle.sysman.emcp.EMRepos
INFO: Repository successfully created
Jul 24, 2006 10:15:18 PM oracle.sysman.emcp.util.DB
INFO: Starting Database Control (this may take a while) ...
Jul 24, 2006 10:17:21 PM oracle.sysman.emcp.EMDBPos
INFO: Database Control started successfully
Jul 24, 2006 10:17:22 PM oracle.sysman.emcp.EMDBPos
INFO: >>>>>>>>>>> The Database Control URL is http://linux3:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 24, 2006 10:17:22 PM
ASKER
Hi Schwertner,
It definitely seems to be an environmental setting. I finally got everything up and running and this is how i did it.
In my .bash_profile I set the oracle environment for db_1 where the database is running.
After the database is up...I set the PATH to include a path setting pointing to the Oracle HTTP Server at db_2/opmn/bin and I start up the Oracle HTTP Server at the command line. I suppose I can add this additional path directory pointing to db_2 into my PATH environment setting in my .bash_profile. I still have to work out those particulars...but it is finally up and running.
Ken
It definitely seems to be an environmental setting. I finally got everything up and running and this is how i did it.
In my .bash_profile I set the oracle environment for db_1 where the database is running.
After the database is up...I set the PATH to include a path setting pointing to the Oracle HTTP Server at db_2/opmn/bin and I start up the Oracle HTTP Server at the command line. I suppose I can add this additional path directory pointing to db_2 into my PATH environment setting in my .bash_profile. I still have to work out those particulars...but it is finally up and running.
Ken
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.