From oracle-l-bounce@freelists.org Fri Mar 25 17:01:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2PN18YM025902 for ; Fri, 25 Mar 2005 17:01:18 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2PN18em025891 for ; Fri, 25 Mar 2005 17:01:08 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 58B6C89595; Fri, 25 Mar 2005 16:59:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27897-03; Fri, 25 Mar 2005 16:59:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CFA5A8993B; Fri, 25 Mar 2005 16:59:11 -0500 (EST) Message-ID: <37496C8294976947996C7F9ADF7010FB0B4035@compqsrv.rolls-roycegs.com> From: "Eberhard, Jeff" To: "'oracle-l@freelists.org'" Subject: RE: Oracle listener problems/ environment settings. (FOLLOWUP) Date: Fri, 25 Mar 2005 14:57:22 -0700 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 17708 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jeff.Eberhard@triumphgs.com Precedence: normal Reply-To: Jeff.Eberhard@triumphgs.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: 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@gmail.com] > Sent: Thursday, March 24, 2005 4:07 PM > 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