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,
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
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
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
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
Hi,
After I issued lsnrctl start ORACL816, the 816
listener started, but the status shows the listener
supports no services.
STATUS of the LISTENER
Alias LISTENER816
Version TNSLSNR for Solaris: Version
8.1.6.0.0 - Production
Start
Why not post the latest of your listener.ora file. It should be quite a bit
different then the original that made it to the list.
-Original Message-
Sent: Monday, April 08, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
Hi,
After I issued lsnrctl start ORACL816, the 816
Check your tnsnames.ora and verify in CONNECT_DATA you have SERVICE_NAME
(instead of SID) and the value of SERVICE_NAME=db_name.db_domain. For
example, if your db_name=orcl01 and db_domain=world then
SERVICE_NAME=orcl01.world.
Janet Linsy wrote:
Hi,
After I issued lsnrctl start ORACL816,
Check your tnsnames.ora and verify in CONNECT_DATA you have SERVICE_NAME
(instead of SID) and the value of SERVICE_NAME=db_name.db_domain. For
example, if your db_name=orcl01 and db_domain=world then
SERVICE_NAME=orcl01.world.
Janet Linsy wrote:
Hi,
After I issued lsnrctl start
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
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
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
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
13 matches
Mail list logo
