Re: Who is connected?

Margaret Burwell (aj739_at_FreeNet.Carleton.CA) wrote:

: This problem arose just the other day.
 

: We have Oracle installed on a DEC Alpha running OpenVMS. Daily backups
: are timed to start each morning at 7:00 am when the operator comes on duty
: and can mount the necessary tape. The job closes down each instance and
: then prompts the operator to mount the proper tape. Yesterday morning,
: one of the databases could not be closed. We believe it was because a
: user was still connected somewhere. I deleted the backup job. Now nobody
: could connect to that database because shutdown was in progress. I
: completed the shutdown using shutdown abort instance and then started the
: database up so people could connect.
 

: Before shutting down the instance, I should have checked to see who was
: connected, but hindsight is 20/20. Is there any way - after the fact - to
: find out who was connected at the crucial time?

the simplest way I know would be to select from v$session just prior to shutting down and saving that somewhere.

it sounds like you are doing shutdown normal...might want to do a shutdown immediate instead.

Johnny Chan
Independent Oracle Specialist Received on Mon Sep 25 1995 - 00:00:00 CET