2 systems with 2 Oracle Listener on Windows

[philipp_schweizer]

Hi Gurus,

I am installing a 2nd system on a Windows server and want to use a separate Listener (with an own port).

sapinst is not able to start the 2nd listener and it is also not possible to start it manually.

The problem is that the new listener OracleQAS102TNSListener seems to point to the 1st listener parameter file.

System parameter file is K:\oracle\DEV\102\network\admin\listener.ora

Log messages written to K:\oracle\DEV\102\network\log\listener.log

I already deleted the service and re-created it, but it is still the same situation. To re-cretae the service I just call lsnrctl start from the correct Oracle home directory and if the service is not avaialable it is created.

Of course I could configure the 2nd listener within the 1st listener.ora - but I definitely do not want this!

I checked the environment and there is no entry from the other system - so is there anybody who has an idea where the Oracle listener gets the information to take the wrong listener.ora file?

Thank you

Philipp

[sunny_pahuja2 · Accepted solution]

Hi,

Check SAP Note 153835 - Starting Multiple tnslsnr on same server

Thanks

Sunny

[philipp_schweizer · Accepted solution]

Hi Sunny,

thank you for your reply.

I know this note and in general I also know how to configure a 2nd listener...

However I have a problem with the 2nd listener like described above and this note does not help in this case.

best regards

Philipp

[Former Member · Accepted solution]

Hi Phillip,

Can you confirm you are using two separate windows accounts for the installs.

Mark

[philipp_schweizer · Accepted solution]

yes, I can confirm this.

The environment variable like ORACLE_SID, ORACLE_HOME, ... is in the user environment and not in the system environment.

thank you.

Philipp

[Former Member · Accepted solution]

Hi,

Have a look in the Windows system PATH.

Now I remember having a similar issues years back and it's was somthing to do with PATH

Because you have muliple Oracles set it looks at the first entry.... I will have a scout around my notes as I think you need to take these out as it getting confused...

I will get back to you.

Mark

[philipp_schweizer · Accepted solution]

Hi Mark,

but also the oracle specific parts of the PATH variable is not in the system environment but the user environment.

Thank yo

Philipp

[Former Member · Accepted solution]

Phillip,

Did you, when you installed the DB instance select a different port number to DEV ?

I would have a look at the registry and check everything......

You could even change the PATH to the QAS Listener there and try starting the service afterwards.

Do not forget to change it in both places.

Mark

[philipp_schweizer · Accepted solution]

Hi Mark,

Listener Port of DEV system ist 1527

Listener Port of QAS system is 1537

I already searched within the registry but did not find anything that seems to be set wrong.

thank you

Philipp

[Former Member · Accepted solution]

Hi,

 OracleQAS102TNSListener seems to point to the 1st listener parameter file

have you tried re-pointing it in the registry ?

Mark

[philipp_schweizer · Accepted solution]

can you tell me where this can be changed? I do not find an entry where this can be defined.

Thank you

Philipp

[Former Member · Accepted solution]

Hi,

Try HKEY_LOCAL_MACHINE => SYSTEM => ControlSet001 and 002 or 003. => services

Mark

[philipp_schweizer · Accepted solution]

Hi Mark,

I already checked this entry - but there is no Path defined to the listener.ora - only the Path to the executable - and this path is correct.

best regards

Philipp

[Former Member · Accepted solution]

Hi,

When in you QAS environment you tried to create the listener from the start => programs net services and see where it goes.

Mark

[philipp_schweizer]

finally the solution was to reboot the server!

After the reboot all the adjustments concerning path and environment became active and I was able to configure the 2nd listener like I wanted.

Thank you!

[volker_borowski2]

Hi Phillipp,

I have a server with two systems runnning 1527 and 1537 as well, and is was

set up correctly with sapinst. I can query both listeners from the cmd.exe

as both sidadm users by only changing the ORACLE_HOME !

Nothing else matters.

Login devadm -> "lsnrctl status" shows DEV configuration

Then SET ORACLE_HOME to the other installtion

"lsnrctl status" shows QAS configuration

I think you need to use the net assistent to configure correctly, because on windows

both listeners have the same name LISTENER (which does not work on UNIX at all,

and causes shared memory problems there).

So I suggest:

- Remove QAS Listener

- Stop DEV Listener

- CREATE QAS Listener as qasadm when DEV Listener is stopped

If you manage to get them to work one by one, stop using lsnrctl for anything else but STATUS.

To manage the listeners, use "net start / net stop"

Hope this helps

Volker