Automatically starting Listeners in different Oracle Homes (10g and 11g)
OS: Oracle Enterprise Linux 5 Update 2 (64-bit)
DB: 10.2.0.4.0 (Standard Edition)
Gateway: Oracle Database Gateways for Microsoft SQL Server 11.1.0.6.0
I have some questions about starting Listeners in two different Oracle Homes (10g and 11g). I have a database running 10gR2 in a 10g home. I modified the dbora script to automatically start and stop the 10g database, 10g listener and 10g database control upon restarts. I also modified the .bash_profile to export the $ORACLE_HOME, $ORACLE_SID and $PATH to the 10g settings for the 'oracle' user.
I recently installed Gateways for SQL Server on the box. This required installing a new, 11g home and creating a new, 11g Listener. Everything is working great, except when I restart the box, the 11g Listener does not start automatically. To start it, I have to export the $ORACLE_HOME, $LD_LIBRARY_PATH and $PATH environment variables for the 11g home, and then I'm able to start and stop the 11g Listener.
Gateway: Oracle Database Gateways for Microsoft SQL Server 11.1.0.6.0
I have some questions about starting Listeners in two different Oracle Homes (10g and 11g). I have a database running 10gR2 in a 10g home. I modified the dbora script to automatically start and stop the 10g database, 10g listener and 10g database control upon restarts. I also modified the .bash_profile to export the $ORACLE_HOME, $ORACLE_SID and $PATH to the 10g settings for the 'oracle' user.
I recently installed Gateways for SQL Server on the box. This required installing a new, 11g home and creating a new, 11g Listener. Everything is working great, except when I restart the box, the 11g Listener does not start automatically. To start it, I have to export the $ORACLE_HOME, $LD_LIBRARY_PATH and $PATH environment variables for the 11g home, and then I'm able to start and stop the 11g Listener.
0