Re: ORA-01219: database not open: queries allowed on fixed tables/views only

Thanks, Frank.

It turned out to be that I had to clear the unarchived logs. The db was unable to open one of the redo log files and causing the db to fail on open.
This error message is a little cryptic. In SQL server, it tells you when the log is full.

thanks for your help

In article <3A791DD0.A72D03F3_at_ntsource.com>,   Frank Hubeny <fhubeny_at_ntsource.com> wrote:
> The database you are trying to connect to is not available. If the
 database
> is on the NT machine use sqlplus and connect as sysdba
 ("change_on_install"
> is the default password and you may need to set ORACLE_SID if there
 is more
> than one database on the machine):
>
> connect sys/change_on_install as sysdba
>
> Then try to open the database:
>
> alter database open;
>
> If you get a message saying that the database is already open, then
 this is
> not the instance you are having trouble with. Otherwise, check the
 event
> log and services to try to determine why the database did not startup
 when
> you rebooted.
>
> If the database you are running the query against is on a remote
 machine ask
> whomever is in charge of that machine to open the database.
>
> Frank Hubeny
>
> alvie_at_my-deja.com wrote:
>
> > OS: NTsp6
> > Oracle: 8.1.5
> >
> > While running a query in a development environment, the server
 returned
> > this message:
> >
> > ORA-01219: database not open: queries allowed on fixed tables/views
 only
> >
> > I've re-booted, re-started all oracle services and still get this
 error.
> >
> > Any ideas?
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 01 2001 - 08:45:16 CST