Should the databases be shutdown before the listener or the other way
around.
A DBA here (actually at Service Provider) believes that the listener has to
be shutdown before the databases in 8i according to some documentation (they
can't recall).
I am proposing:
Set Oracle 817 environment
Why do you/they think it matters, regardless of the documentation?
You can shut them down in any order you want. Users just get a
different error if the listener is up vs. when it is down.
Starting up, if services are registered via local_listener or
mts_dispatchers, the listener should be up
There might be some docs somewhere but the issues are not as much
technical as procedural. If you shut the database down, leave the
listener up, and bring the database backup there are no connection
problems except when the db is down. This implies that the instance and
the listener are
David,
it just doesn't matter. why do you even feel the need to shut the listener
down?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, March 03, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
Should the databases be shutdown before the listener
Sometimes it does matter what is stopped rather than the order, but we
can't tell why the original poster was asking. It depends on your
environment. For example, one site I worked at had a separate listener
for every database in their environment. Their reasoning was they made
life easier for
Tom,
It is for the server auto-start/auto-shutdown procedures run by root.
From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Listener/Database shutdown sequence
Date: Mon, 03 Mar 2003 09:04:11 -0800
From: Jeremiah Wilton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Listener/Database shutdown sequence
Date: Mon, 03 Mar 2003 08:19:06 -0800
Why do you/they think it matters, regardless of the documentation?
You can
, the most successful path is the list.
Thx
David
From: Jeremiah Wilton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Listener/Database shutdown sequence
Date: Mon, 03 Mar 2003 08:19:06 -0800
Why do you/they think it matters
-shutdown procedures run by root.
From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Listener/Database shutdown sequence
Date: Mon, 03 Mar 2003 09:04:11 -0800
David,
it just doesn't matter. why do you
OK, after emphatically stating it doesn't matter, I thought of a
situation in which the order of shutting down could make a difference.
In this scenario, you first must be the kind of person who needlessly
insists on shutdown immediate (instead of abort). Second, you must
have a very heavy rate
10 matches
Mail list logo