Re: listener on windows using wrong directory structure

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Wed, 15 Aug 2012 11:01:16 -0400
Message-Id: <502B817C0200000B004EFF6F_at_groupwise.gcrta.org>

It is EBS, however, the database server is NOT EBS configured. We control our own installs on it.
>>> Niall Litchfield <niall.litchfield_at_gmail.com> 8/15/12 10:54 AM >>>
So the applmgr username suggests that this might be an EBiz install? is that correct? If so then

1. Ebiz has some specific control scripts for databases and listeners and some funky sqlnet config. I'd expect SET ORACLE_HOME, TNS_ADMIN etc not to work in any Ebiz environment.
2. the environment for the listener is set in the registry (and read from the registry by the executable lsnrctl - in general its often a mistake to set the environment on windows, instead use the full path to the relevant executable.
3. if it is ebiz and windows, good luck with that, you are in a small minority there.

On Wed, Aug 15, 2012 at 3:11 PM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:

That's the problem. I am trying to start the 11.2.0.3 listener but it keeps referencing the 10g or 11g r1 listener.ora files.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
>>> Robert Hanuschke <robert.hanuschke_at_gmail.com> 8/15/12 9:49 AM >>>
Hi Jeffrey,

the output you've provided shows you setting the environment while the listener is already running. What is the TNS_ADMIN set to when the listener is being started (via the Windows service I assume) in the registry?

Best regards,
Robert
http://robertvsoracle.blogspot.com

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


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

Received on Wed Aug 15 2012 - 10:01:16 CDT