LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 10-13-2008, 09:27 AM   #1
linareja
LQ Newbie
 
Registered: Sep 2008
Location: Spain
Distribution: Red Hat Enterprise 4 AS
Posts: 19

Rep: Reputation: 0
ORA-01219: database not open: queries allowed on fixed tables/views only


I have following problem opening the database in oracle, could anyone tell me any idea about how to fix it? Thanks

bash-3.00$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Lun Oct 13 16:00:14 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1063426108 bytes
Fixed Size 452668 bytes
Variable Size 335544320 bytes
Database Buffers 716800000 bytes
Redo Buffers 10629120 bytes
ORA-00439: feature not enabled: Real Application Clusters


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

 
Old 10-13-2008, 09:37 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,190

Rep: Reputation: 6476Reputation: 6476Reputation: 6476Reputation: 6476Reputation: 6476Reputation: 6476Reputation: 6476Reputation: 6476Reputation: 6476Reputation: 6476Reputation: 6476
Quote:
Originally Posted by linareja View Post
I have following problem opening the database in oracle, could anyone tell me any idea about how to fix it? Thanks

bash-3.00$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Lun Oct 13 16:00:14 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1063426108 bytes
Fixed Size 452668 bytes
Variable Size 335544320 bytes
Database Buffers 716800000 bytes
Redo Buffers 10629120 bytes
ORA-00439: feature not enabled: Real Application Clusters


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

Yeah, your database isn't open. Have you contacted Oracle?
 
Old 10-13-2008, 09:45 AM   #3
linareja
LQ Newbie
 
Registered: Sep 2008
Location: Spain
Distribution: Red Hat Enterprise 4 AS
Posts: 19

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by TB0ne View Post
Yeah, your database isn't open. Have you contacted Oracle?
But, is not it supposed to be opened when the command 'startup' is introduced? Once I had the same problem and it was fixed creating the database again but I do not want to do it each time I have this problem!

Any special way to open it or something like this?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
ORA-01034: ORACLE not available ORA-27101? suresheva31 Linux - General 4 09-16-2015 11:56 AM
"ORA-12547: TNS:lost contact" when creating database in Oracle 10g Dtsazza Linux - Software 4 04-25-2009 09:54 AM
SQL: tables and queries in school project cold Programming 1 10-29-2005 07:58 PM
SQL: making queries from multiple tables ganninu Programming 1 01-08-2004 11:17 AM
Open source or not? What are your views? Wonderer Programming 7 11-04-2003 09:52 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:04 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration