Dear Friends,
I faced a strange problem yesterday.
Iam using ASE 12.5.0.3 on solaris . while loading dump of tran log
Following error had come

Msg 4301, Level 16, State 2:
Server 'TEST', Line 3:
Database in use. A user with System Administrator (SA) role must have exclusive
use of DB to load transaction.

There was no user in the database because the status of the database is offline.
In sysdatabases table status2 column has 16 value.

Kindly let me know the reason of this problem

Thanks & Regards
Lalit

issues_sybase@hotmail.com (Lalit) wrote in message news:<7bcd3933.0309102036.20fb418f@posting.google. com>...
> Dear Friends,
> I faced a strange problem yesterday.
> Iam using ASE 12.5.0.3 on solaris . while loading dump of tran log
> Following error had come
>
> Msg 4301, Level 16, State 2:
> Server 'TEST', Line 3:
> Database in use. A user with System Administrator (SA) role must have exclusive
> use of DB to load transaction.
>
> There was no user in the database because the status of the database is offline.
> In sysdatabases table status2 column has 16 value.
>
> Kindly let me know the reason of this problem
>
> Thanks & Regards
> Lalit

I would also be interested in this as I have had exactly the same
problem I had to schedule downtime to re-boot the server.

Regards
Mark

markcurtis@yahoo.com (Mark) wrote in message news:<9105603e.0309110412.628977c1@posting.google. com>...
> issues_sybase@hotmail.com (Lalit) wrote in message news:<7bcd3933.0309102036.20fb418f@posting.google. com>...
> > Dear Friends,
> > I faced a strange problem yesterday.
> > Iam using ASE 12.5.0.3 on solaris . while loading dump of tran log
> > Following error had come
> >
> > Msg 4301, Level 16, State 2:
> > Server 'TEST', Line 3:
> > Database in use. A user with System Administrator (SA) role must have exclusive
> > use of DB to load transaction.
> >
> > There was no user in the database because the status of the database is offline.
> > In sysdatabases table status2 column has 16 value.
> >
> > Kindly let me know the reason of this problem
> >
> > Thanks & Regards
> > Lalit
>
> I would also be interested in this as I have had exactly the same
> problem I had to schedule downtime to re-boot the server.
>
> Regards
> Mark


I'm not sure if this is the cause, but please check for it: is
the sp_configure value for "open databases" lower than the actual
number of databases on your server (i.e. select count(*) from sysdatabases).
If so, ASE may be having to try to scavange a database descriptor - and
odd things have been known to happen when that is done. If you do find this,
please increase "open databases" to be larger than or equal to the actual
number of databases.

-bret