Don't you mean shutdown transactional? Shutdown immediate rolls back
existing jobs.

-----Original Message-----
From: Paul Murgatroyd
[mailto:oracledba-ezmlmshield-x72329457.[Email address protected]
Sent: Thursday, April 07, 2005 8:37 AM
To: LazyDBA Discussion
Subject: Re[2]: Shutting down the Concurrent Manager on 11.5.9 (Windows
2000)

The Concurrent Manager is simply a Job Queue for Oracle Apps 11i.

You can issue this command to stop the queue immediately:

CONCSUB apps/apps SYSADMIN 'System Administrator' SYSADMIN CONCURRENT
FND ABORT

ABORT tells the managers to terminate the managers immediately. When
the concurrent managers are terminated through the abort command, the
jobs that
they were running will be returned to pending status.

When you use SHUTDOWN, any jobs currently running will be allowed to
complete, but new jobs will not start. This is similarto a database
"shutdown immediate".

If you are doing cold backups, and have problems with the managers,
perhaps you should consider setting up a Workshift the deacticates all
the Concurrent Managers in advance of your backup window. That way, when
you issue the shutdown you find that because no jobs were running, the
shutdown is quick (without the need for an abort).

The alternative is to do hot backups, which I find is a much better
solution for an Apps 11i database. I can't imagine a single Production
Apps 11i database that would not be running in ARCHIVELOG mode.

Regards,

Paul



*********** ORIGINAL MESSAGE ***********

On 5/04/2005 at 11:00 AM henry Wollman wrote:

Yes, but a shutdown abort will need to be followed immediately by a
startup,
shutdown immediate so that the database will be consisten when backed
up.
does no good to backup an inconsistent database.


| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address
protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Sunny Yang [mailto:[Email address protected]
Sent: Tuesday, April 05, 2005 10:43 AM
To: [Email address protected]
Subject: RE: Shutting down the Concurrent Manager on 11.5.9 (Windows
2000)

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


You can consider using 'shutdown abort', it will kill all defunct
processes (incl. all FNDLIBR processes) and shut down db immediately.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page