RE: Oracle listener problems/ environment settings. (FOLLOWUP)

I used the Oracle Home selector to set the correct Oracle home, checked the ORACLE_HOME key in the registry, check the ORACLE_HOME environment variable....all set to the correct home. Still same problem.

But it is fixed now. How? I removed the computer's system environment variable ORACLE_HOME (right click on My Computer->Properties,Advanced Tab, Environment Variables... button, System variables region). Then reboot.

Can't believe how stupid window is. To verify I spent the day installing oracle 8 and 9 on a (windows 2000 server) test box and ran through different scenarios. Had the two listeners configured to listen to different ports so there was no port conflict.

When booting with the ORACLE_HOME system environment variable the listener with the corresponding oracle_home would start fine. Trying to start the other listener even after changing the environment variables, registry entries, etc. would fail with the "Operation would block" or "TNS: Protocol not found" errors that I was initially experiencing. Logs would show that it was retrieving the listener configuration file from the location of the oracle home that was defined by the ORACLE_HOME system environment variable at boot time.

Both listeners would start after deleting the ORACLE_HOME system environment variable and rebooting.

Just another reason to love Windows, huh?!?!?!?!?!

> -----Original Message-----
> From: Jared Still [mailto:jkstill_at_gmail.com]
> Sent: Thursday, March 24, 2005 4:07 PM
> <Jeff.Eberhard_at_triumphgs.com> wrote:
> > Listener log in the oracle 9i home shows the the oracle 8
> listener is
> > trying to read the oracle9 parameter file. Where does
> lsnrctl decide
> > to find the parameter file?
>
>
> ORACLE_HOME\network\admin
>
> Run the Oracle Home Selector and set the correct Oracle home,
> then open a new command window.
>
> Check your registry if there are still problems.
>
> You need to ensure that the ORACLE_HOME in the ORACLE
> registry key is indeed the one you expect it to be.
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

--
http://www.freelists.org/webpage/oracle-l