Just want to share some intersting experience and observations:
I installed Oracle 10g on Solaris 5.8, and on the same box there is
another Oracle 8i instance installed and running, with a separate
ORACLE_HOME (8.1.7.4). I found that the moment I startup the 10g instance
the 8i listener stopped responding. Further testing showed that this
only happens when the 10g database is about to open (i.e. startup nomount
and startup mount does NOT make this happen). The 8i listener is running
at port 1521. This must be that the 10g instance cannot do service
registration with an 8i listener. Had to resolve this by running 10g's
own listener at another port (in my case 1526), and specify the
LOCAL_LISTENER parameter in 10g, pointing to a tnsnames.ora entry
that resolves the new listener.
Received on Fri Feb 13 2004 - 15:27:00 CST
