databases
running
on = higher version, unless you need multiple listeners for other
reasons Net8 Admin Guide should have enough information.
- Kirti
-Original Message-
Sent: Wednesday, October 16, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
DBAs,
Any quick start guides
=lightening)(PORT=1526))
When the above line was present in init.ora of the database (db7)
for whcih the second listener is configured, the database Auto registered
with the new listener. So, now I could connect to the database through
the new listener only!
Multiple Listeners
There has been much discussion regarding single or multiple
listeners and there seems to be a split between those who advocate one method
over the other.
I am currently working at a site with a large number of systems/databases.
They are well organised and one of the standards
-Original Message-
Okay, I will concede the point. Sometimes having multiple
listeners can be
a good thing.
An example:
(NOTHING)/etc ps -eo args | grep smon
ora_smon_CATT2
ora_smon_CRCD1
ora_smon_CRCT1
ora_smon_DEMO
ora_smon_DEVL
ora_smon_DRTD
ora_smon_DRTD1
ora_smon_DRTT
On most servers I have only one database on the node.
Where I do have multiple databases, I have seperate ORACLE_HOMEs. Where I
have
seperate ORACLE_HOMEs, I have seperate Listeners.
There's really not much of an effort in managing multiple listeners --
after all
you have to issue a seperate
DBAs,
Any quick start guides / scripts / notes for having multiple version
listeners on same Solaris box?
Scenario :
I am in process of upgrading.
There are two databases on a machine db6 and db7
db6 - 8.1.6
db7 - 8.1.6
db6 and db7 use the listener of version 8.1.6
Now,
db7
1st thing i do when upgrading db's on a server is to start using the new listener.
just have your 816 db's use the 817 listener.
hth,
gene
[EMAIL PROTECTED] 10/16/02 02:12PM
DBAs,
Any quick start guides / scripts / notes for having multiple version
listeners on same Solaris box?
Scenario
You can use the 'higher' version of the listener for all databases running
on = higher version, unless you need multiple listeners for other
reasons Net8 Admin Guide should have enough information.
- Kirti
-Original Message-
Sent: Wednesday, October 16, 2002 1:13 PM
To: Multiple
Rachna,
Do yourself a favor - use the most recent listener for all databases. Have
only one listener running on a machine and use that for all databases on
that machine. In your case, use the 817 listener.
In the long run, it will be much easier and less confusing.
Hope this helps.
Tom
-Original Message-
Any quick start guides / scripts / notes for having multiple version
listeners on same Solaris box?
It works fine. Here is an example of some commands to put into a general
Oracle startup script.
export
Thanks for the inputs.
This is how I did it.
1. There are two listener.ora files
/opt/app/oracle/product/816/listener.ora : FILE816
/opt/app/oracle/product/817/listener.ora : FILE817
FILE817 is a copy of FILE816
2. Entries for db7 are removed from FILE816
FILE816 listner name is
Hmm,
The db7 (upgraded to 817) automatically registers itself to listener.
Why?
And, changing the PORT, wouldn't I need to change all tnsnames.ora ?
Nabil, your and Kirti's suggestion for one listener has this
particular benefit.
Still thinking.I am.
- Original Message -
]]
Sent: Wednesday, October 16, 2002 1:21 PM
To: LazyDBA.com Discussion
Subject: Re: Multiple Listeners
Thanks for the inputs.
This is how I did it.
1. There are two listener.ora files
/opt/app/oracle/product/816/listener.ora : FILE816
/opt/app/oracle/product/817/listener.ora
I respectfully disagree. I am currently working on a Sun 4500
cluster with Veritas. The cluster services each maintain their
own nic/ip, that's 1 per instance. Obviously, each instance
also has its own listener. This has been very easy to implement
and not at all confusing. It also avoids
for all databases running
on = higher version, unless you need multiple listeners for other
reasons Net8 Admin Guide should have enough information.
- Kirti
-Original Message-
Sent: Wednesday, October 16, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
DBAs,
Any quick start
-Original Message-
The db7 (upgraded to 817) automatically registers itself to listener.
Why?
And, changing the PORT, wouldn't I need to change all tnsnames.ora ?
Nabil, your and Kirti's suggestion for one listener has this
particular benefit.
I have seen later versions of
That's because of the new feature of Auto Registration with Listener...
I guess, it's about time to review docs for changes in 8i Release 2
(8.1.7)... there could be more such surprises :)
- Kirti
-Original Message-
Sent: Wednesday, October 16, 2002 2:50 PM
To: Multiple recipients of
databases running
on = higher version, unless you need multiple listeners for other
reasons Net8 Admin Guide should have enough information.
- Kirti
-Original Message-
Sent: Wednesday, October 16, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
DBAs,
Any quick start guides
. There
is no need to run multiple listeners on the same server, especially when
the versions are just one release off from each other (e.g. 8.1.6 and
8.1.7). A single listener and a single Intelligent Agent should be all
that is needed. It may be clever to see if multiple listeners can run, but
even Oracle
Administrator
Replacements Ltd.
-Original Message-
Sent: Wednesday, October 16, 2002 2:40 PM
To: Multiple recipients of list ORACLE-L
You can use the 'higher' version of the listener for all databases running
on = higher version, unless you need multiple listeners for other
reasons Net8
-Original Message-
even Oracle will tell you that running multiple listeners is
worse than
foolish.:)
Please supply the link to Oracle's article with this statement.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL PROTECTED
-Original Message-
Sent: Wednesday, October 16, 2002 4:20 PM
A single listener and a single Intelligent Agent should be all
that is needed. It may be clever to see if multiple listeners can run, but
even Oracle will tell you that running multiple listeners is worse than
foolish
-Original Message-
but
even Oracle will tell you that running multiple listeners is
worse than
foolish.:)
Trust me, you only need one version of the Listener up.
From O'Reilly's Oracle Net8 Configuration and Troubleshooting book, pages
70 - 71, under the sub-topic Why Use
You are right Kirti
This is a new feature of 8i. It also does it in 9i.
Ramon
-Original Message-
Kirti
Sent: Wednesday, October 16, 2002 3:15 PM
To: Multiple recipients of list ORACLE-L
That's because of the new feature of Auto Registration with Listener...
I guess, it's about time
Okay, I will concede the point. Sometimes having multiple listeners can be
a good thing. Although running older versions of the listener may not be.
But you pay your money and you take your chances. Thank you for those who
cited published sources. Please remember: what an Oracle analyst
Congratulations !!
Now one more point---
If one uses default listener name (listener) and default port (1521),
databases (8i,+) will auto register with this listener first.
Either do not use default names and ports, or make sure that you set your
init.ora parameters (service_names?)
correct if I'm wrong, but this is how it works on my 8.1.6 instances.
-Original Message-
Aschenbrenner
Sent: Monday, July 16, 2001 6:27 PM
To: Multiple recipients of list ORACLE-L
Edward,
Yes, you can setup multiple listeners. Here is an example:
LISTENERDB1 =
(DESCRIPTION_LIST
.
John
-Original Message-
From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]]
Sent: 17 July 2001 00:41
To: Multiple recipients of list ORACLE-L
Subject: RE: Multiple Listeners
If you are using external procedures, the listener for them should be
different as well. The external
PROTECTED]]
Sent: 17 July 2001 00:41
To: Multiple recipients of list ORACLE-L
Subject: RE: Multiple Listeners
If you are using external procedures, the listener for them should be
different as well. The external procedures run under the authority of the
user which started the listener
ing Oracle 816 64bit on a Solaris 8 box.
I have three databases on the system with one LISTENER for all
of them. Is it possible to configure multiple listeners,
one for each database? We have tried in the past with no
success... If there is a document on the web somebody could
point me to, that wo
Hello All,
I am currently running Oracle 816 64bit on a Solaris 8 box. I have three
databases on the system with one LISTENER for all of them. Is it possible
to configure multiple listeners, one for each database? We have tried in
the past with no success... If there is a document on the web
listeners?
-Original Message-
From: Edward W. Carr [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 5:42 PM
To: Multiple recipients of list ORACLE-L
Subject: Multiple Listeners
Hello All,
I am currently running Oracle 816 64bit on a Solaris 8 box.
I have three
databases
Edward,
Yes, you can setup multiple listeners. Here is an example:
LISTENERDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521))
)
)
)
LISTENERDB2 =
(DESCRIPTION_LIST =
(DESCRIPTION
:42 PM
To: Multiple recipients of list ORACLE-L
Subject: Multiple Listeners
Hello All,
I am currently running Oracle 816 64bit on a Solaris 8 box.
I have three
databases on the system with one LISTENER for all of them.
Is it possible
to configure multiple listeners, one for each
Mladen,
I can think of numerous reasons to have multiple listeners. For
example, imagine a server with several databases where you sometimes
wanted to restrict outside access on just one database. Meanwhile still
allowing local users on that server to access that particular database
. I'd give each listener
a specific name like 'listener_node_name' so that you can have everything in
one file and use only what is needed. Kinda of like Alan suggested, but with
different hostnames. I think he was thinking on multiple listeners on one host,
not multiple listeners on multiple hosts
However, to answer the question, you need to name the listeners something
other then listener and you need to have them listening on different ports.
When you use the lsnrctl command you have to reference the listener you
are dealing with.
There are reasons to have multiple listeners
of their choice. What would you benefit from
having 3 listeners?
-Original Message-
From: Edward W. Carr [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 5:42 PM
To: Multiple recipients of list ORACLE-L
Subject: Multiple Listeners
Hello All,
I am currently running Oracle 816 64bit
]
-Original Message-
Sent: Monday, July 16, 2001 4:01 PM
To: Multiple recipients of list ORACLE-L
Mladen,
I can think of numerous reasons to have multiple listeners. For
example, imagine a server with several databases where you sometimes
wanted to restrict outside access on just one database
-
From: Edward W. Carr [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 5:42 PM
To: Multiple recipients of list ORACLE-L
Subject: Multiple Listeners
Hello All,
I am currently running Oracle 816 64bit on a Solaris 8 box.
I have three
databases on the system with one LISTENER for all
You just place the different listeners in the listener.ora file.
Denise Gwinn
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
41 matches
Mail list logo