Home » RDBMS Server » Server Administration » ORA-01219: database not open: queries allowed on fixed tables/views only (Window Xp, 10.2.0.1.0)
ORA-01219: database not open: queries allowed on fixed tables/views only [message #341360] Mon, 18 August 2008 09:34 Go to next message
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.
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
alter database open;
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 Go to previous messageGo to next message
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'

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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
newbieavi wrote on Mon, 18 August 2008 08:02
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'




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?
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 Go to previous messageGo to next message
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)
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show parameter archive

Regards
Michel
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: oracle trace
Next Topic: Shrink UNDO tablespace
Goto Forum:
  


Current Time: Sun Dec 11 02:28:11 CST 2016

Total time taken to generate the page: 0.04015 seconds