OraFAQ Forum: Server Administration » ORA-01219: database not open: queries allowed on fixed tables/views only

Home » RDBMS Server » Server Administration » ORA-01219: database not open: queries allowed on fixed tables/views only (Window Xp, 10.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01219: database not open: queries allowed on fixed tables/views only [message #341360]

Mon, 18 August 2008 09:34

newbieavi
Messages: 5
Registered: July 2008
Location: bhopal

Junior Member

hello experts,

i tried logging into my database running on windows xp after about 20 days.

i am facing issues while firing the queries

SQL> select * from global_name;
select * from global_name
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only

please advise.

Report message to a moderator

Re: ORA-01219: database not open: queries allowed on fixed tables/views only [message #341362 is a reply to message #341360]

Mon, 18 August 2008 09:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

alter database open;

Report message to a moderator

Re: ORA-01219: database not open: queries allowed on fixed tables/views only [message #341365 is a reply to message #341360]

Mon, 18 August 2008 10:02

newbieavi
Messages: 5
Registered: July 2008
Location: bhopal

Junior Member

Yes I tried that before too but its giving as:

SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-16014: log 3 sequence# 289 not archived, no available destinations
ORA-00312: online log 3 thread 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG'

Report message to a moderator

Re: ORA-01219: database not open: queries allowed on fixed tables/views only [message #341368 is a reply to message #341365]

Mon, 18 August 2008 10:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

newbieavi wrote on Mon, 18 August 2008 08:02

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Thank you for sharing.
Is the disk full?
Is archive mode enabled?

Report message to a moderator

Re: ORA-01219: database not open: queries allowed on fixed tables/views only [message #341371 is a reply to message #341360]

Mon, 18 August 2008 10:32

newbieavi
Messages: 5
Registered: July 2008
Location: bhopal

Junior Member

Disk is 70Gb free.

SQL> select dbid, name, log_mode from v$database;

DBID NAME LOG_MODE
---------- --------- ------------
1171023529 ORCL ARCHIVELOG

DB is running in archive mode(i think if this is the correct way to see)

Report message to a moderator

Re: ORA-01219: database not open: queries allowed on fixed tables/views only [message #341372 is a reply to message #341371]

Mon, 18 August 2008 10:37

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

show parameter archive

Regards
Michel

Report message to a moderator

Re: ORA-01219: database not open: queries allowed on fixed tables/views only [message #341373 is a reply to message #341360]

Mon, 18 August 2008 10:41

newbieavi
Messages: 5
Registered: July 2008
Location: bhopal

Junior Member

here's is the output of the cmd

SQL> show parameter archive

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------------------
archive_lag_target                   integer     0
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_2                   string
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------------------
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------------------
log_archive_dest_state_9             string      enable
log_archive_duplex_dest              string
log_archive_format                   string      ARC%S_%R.%T
log_archive_local_first              boolean     TRUE
log_archive_max_processes            integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0
remote_archive_enable                string      true
standby_archive_dest                 string      %ORACLE_HOME%\RDBMS

how to interpret this output?

[Updated on: Mon, 18 August 2008 10:46] by Moderator

Report message to a moderator

Re: ORA-01219: database not open: queries allowed on fixed tables/views only [message #341374 is a reply to message #341373]

Mon, 18 August 2008 10:48

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This shows there is no available destination to archive.
You have to set at least LOG_ARCHIVE_DEST.

Next time use code tags as I edited your post, it is easier to read.

Regards
Michel

Report message to a moderator

Previous Topic:	oracle trace
Next Topic:	Shrink UNDO tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 19:44:58 CST 2024