Re: waiting for logins to complete.

Shutdown immediate is enough to shutdown the database in a consistent state. The only time you'd want to startup/shutdown a second time is if the first time you did a shutdown abort, which will leave the db in an inconsistent state. The reason for the shutdown hanging could be that someone or something was actually logged in, ie the second shutdown is a shutdown normal. The shutdown normal waits for all users currently connected to disconnect themselves on their own, shutdown normal does not force them to. If you wish to keep your shutdown script as it is, put in startup restrict instead of just startup, this should block all logins except for DBA's with priv's.

HTH,
Pete's

faheemrao_at_yahoo.com (FaheemRao) wrote in message news:<43b58913.0110232214.5b8f9f71_at_posting.google.com>...
> Ok One of the suspecious thing is that your Data file for Index is
> offline even though it was online before running of scripts.
>
> Now how do you take backup of your datafiles , do you use a backup
> utility or you had a batch file for that as well.
>
> One idea would be that your Backup routine runs before your Database
> shutdown scripts. so actually the backup procedure is trying to Copy
> the Oracle Data files before database is actually shutdown. and then
> in the that time your shutdown scripts tries to shutdown Database.
>
> I am not sure is this is the case with you.
>
>
> Faheem Rao
>
>
>
> Lionel Mandrake <nobody_at_nospam.noway.nohow> wrote in message news:<3BD62BDF.4010308_at_nospam.noway.nohow>...
> > Last time I saw anything like this was when the Oracle Intelligent Agent
> > was running. As soon as the Oracle server started the Intelligent Agent
> > would attempt to create a session. Don't know if you're runnging the
> > Intelligent Agent or not... I also agree with Kevin Brand, in that a
> > backup of a shutdown immediate is a valid cold backup...
> >
> > HTH
> >
> > Anthony Hogan wrote:
> >
> > > Hi all,
> > > I'm running 8.1.7.0 SE on win 2000.
> > > For our nightly cold backups I shut down the database using a batch
> > > program to call this script:
> > >
> > > connect internal/oracle_at_database
> > > alter database create standby controlfile as
> > > 'C:\oracle\oradata\nomina\xx' reuse;
> > > alter system archive log current;
> > > shutdown immediate
> > > startup
> > > shutdown
> > > exit
> > >
> > > It's been running fine for months but last night it hung on the second
> > > shutdown.
> > >
> > > AlertLog <snip>
> > > Shutting down instance (immediate)
> > > License high water mark = 6
> > > Mon Oct 22 23:01:14 2001
> > > ALTER DATABASE CLOSE NORMAL
> > > Mon Oct 22 23:01:14 2001
> > > SMON: disabling tx recovery
> > > SMON: disabling cache recovery
> > > Mon Oct 22 23:01:16 2001
> > > Thread 1 closed at log sequence 2251
> > > Mon Oct 22 23:01:17 2001
> > > Completed: ALTER DATABASE CLOSE NORMAL
> > > Mon Oct 22 23:01:17 2001
> > > ALTER DATABASE DISMOUNT
> > > Completed: ALTER DATABASE DISMOUNT
> > > archiving is disabled
> > > Mon Oct 22 23:01:19 2001
> > > ARCH shutting down
> > > ARC0: Archival stopped
> > > Starting up ORACLE RDBMS Version: 8.1.7.0.0.
> > > ....
> > > ....
> > > Completed: alter database open
> > > Shutting down instance (normal)
> > > License high water mark = 2
> > > Mon Oct 22 23:06:43 2001
> > > SHUTDOWN: waiting for logins to complete.
> > > ....
> > >
> > > I had to shutdown abort when I arrived this morning. When I opened the
> > > DB one of my index datafiles was offline.
> > >
> > > I know there were no users trying to connect and I'm at a loss as to why
> > > the DB should hang.
> > >
> > > Could anyone shed some light on this?
> > >
> > > Thanks in advance,
> > > Anthony Hogan
> > > hogananthony_at_hotmail.com
> > >
Received on Wed Oct 24 2001 - 07:34:35 CDT