I set the ORACLE_HOME to 11G and installed the 11G listener: SUCCESS!
But there is an Oracle 10G database running. So I deleted the ORACLE_HOME entry in the environment because I fear the 10G database has problems with 11G ORACLE_HOME.
Now the 11G Listener has the same problems again!
How do I set the ORACLE_HOME variable while migrating from 10G to 11G because I have to run the 11G listener during migration. Am I right?
Thank you very much!
1) Stop 11g (and 10g if up) listeners services.
2) Check the environment variables for correct oracle home in the PATH and if there is a TNS_ADMIN pointing to correct location of the listener.ora and tnsnames.ora files.
3) Check in the registry oracle-homes for TNS_ADMIN entry and point it to the correct location.
4) Disable the 10g listener in the services.
5) Start 11g listener service
PS: When there are multiple oracle homes on one server, some of us prefer to create a separate directory for the listener parameter files, for example: C:\Oracle\Network\Admin that will have the listener.ora, tnsnames.ora and sqlnet.ora files.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb