AW: two listeners problem ???

2002-04-08 Thread v . schoen
]] Gesendet: Samstag, 6. April 2002 08:08 An: Multiple recipients of list ORACLE-L Betreff: two listeners problem ??? Hi, I have two databases ORCL817 and ORCL816 in version 817, 816 on the same machine Sun 5.7. I'd like to configure seperate listener for each database. I used different port

Re: two listeners problem ???

2002-04-08 Thread Yechiel Adar
Please excuse my idiotic curiosity. Why do you need 2 listeners on the same machine? I always install the listener of the higher version and disable the previous one. Yechiel Adar. Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday,

Re: two listeners problem ???

2002-04-08 Thread Jay Hostetter
I joined in a bit late on this thread, so you might have your problem fixed. Your SID_LIST_LISTENER entry in the listener.ora should say SID_LIST_LISTENER816 and SID_LIST_LISTENER817. When starting the listener, do the following: (w/environment set for 816) lsnrctl start listener816

RE: two listeners problem ???

2002-04-08 Thread Sherman, Paul R.
Hello, It should not be all that uncommon. We have 7 databases each on our development and test machines that are tied to their production counterparts, and, over time, some of the databases have lagged behind others (lots of reasons for that, esp. mgt. priorities), leaving us with multiple

RE: two listeners problem ???

2002-04-08 Thread Jay Hostetter
Leave your tnsnames.ora files alone for now - they aren't relevant to getting the listeners started. Post your current listener.ora files and the output from your commands to start the listeners. Make sure they are down before you try to start them. Jay [EMAIL PROTECTED] 04/08/02 01:56PM

Re: two listeners problem ???

2002-04-08 Thread Suzy Vordos
Why not just run the 817 listener for both databases? Only one listener can be bound to a port, so using your config you could run 816 on 1521 817 on 1522. But I'd stick with using just the 817 listener on ports 1521 1526. Janet Linsy wrote: Hi, I have two databases ORCL817 and

Re: two listeners problem ???

2002-04-08 Thread Janet Linsy
PROTECTED] Subject: two listeners problem ??? Date: Fri, 5 Apr 2002 22:09:15 -0800 (PST) Hi, I have two databases ORCL817 and ORCL816 in version 817, 816 on the same machine Sun 5.7. I'd like to configure seperate listener for each database. I used different port, listener name (1521

RE: two listeners problem ???

2002-04-08 Thread Kimberly Smith
what went wrong. Did you get any errors while trying to start the listener? Hope this helps. If not get back to me and I shall help you. Rgds Raj From: Janet Linsy [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: two listeners problem ??? Date: Fri, 5 Apr 2002

Re: two listeners problem ???

2002-04-08 Thread Suzy Vordos
] Subject: two listeners problem ??? Date: Fri, 5 Apr 2002 22:09:15 -0800 (PST) Hi, I have two databases ORCL817 and ORCL816 in version 817, 816 on the same machine Sun 5.7. I'd like to configure seperate listener for each database. I used different port, listener name (1521

[Re: two listeners problem ???]

2002-04-08 Thread Suzy Vordos
] Subject: two listeners problem ??? Date: Fri, 5 Apr 2002 22:09:15 -0800 (PST) Hi, I have two databases ORCL817 and ORCL816 in version 817, 816 on the same machine Sun 5.7. I'd like to configure seperate listener for each database. I used different port, listener name (1521

Re: two listeners problem ???

2002-04-06 Thread Rachel Carmichael
when you start your second listener, make sure ALL the environment variables are correct and pointing to that version of Oracle --- Janet Linsy [EMAIL PROTECTED] wrote: Hi, I have two databases ORCL817 and ORCL816 in version 817, 816 on the same machine Sun 5.7. I'd like to configure

Re: two listeners problem ???

2002-04-06 Thread Tim Gorman
Janet, The format of entries in the listener.ora file is organized by listener-name, which is the phrase trailing the parameters in the file. For example, if you look at your own file, you'll see: LISTENER816 = SID_LIST_LISTENER = ... LISTENER817 = ... SID_LIST_LISTENER

RE: two listeners problem ???

2002-04-06 Thread Gogala, Mladen
What happens to the second listener? Is there an error or it just hangs? -Original Message- Sent: Saturday, April 06, 2002 1:08 AM To: Multiple recipients of list ORACLE-L Hi, I have two databases ORCL817 and ORCL816 in version 817, 816 on the same machine Sun 5.7. I'd like to

RE: two listeners problem ???

2002-04-06 Thread Gogala, Mladen
Be very careful with LD_LIBRARY_PATH. This one is not strictly an oracle environment variable but it can really mess things up. -Original Message- Sent: Saturday, April 06, 2002 7:23 AM To: Multiple recipients of list ORACLE-L when you start your second listener, make sure ALL the

two listeners problem ???

2002-04-05 Thread Janet Linsy
Hi, I have two databases ORCL817 and ORCL816 in version 817, 816 on the same machine Sun 5.7. I'd like to configure seperate listener for each database. I used different port, listener name (1521 and LISTENER817 for ORCL817 , 1522 and LISTENER816 for ORCL816), but somehow the listener on 1522