Re: waiting for logins to complete.

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 - 01:14:29 CDT