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 ORACL
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 ORACL8
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
listene
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 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
Hamid - The following is a low probability of solving your problem, but
maybe you have exhausted the most likely fixes.
As I recall from your original question, listener816 works and uses
port 1521. listener817 doesn't work and uses port 1522. Could this be your
problem? Why don't you shu
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
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 liste
My problem still NOT solved, I have setup lister817 separatley and check my
tnsname.ora also when I try to start the listener817 got the listener
already started message but when I run lsnrctl services , I can not see the
service in the list.
My next test is to add the 817 listener to 816 and star
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
(w/enviro
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, Apr
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 envir
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
configu
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_LISTEN
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
> configu
15 matches
Mail list logo