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

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/
  Received on Thu Feb 01 2001 - 02:26:56 CST