Home » RDBMS Server » Server Administration » ORA-01219<< Need Expert
ORA-01219<< Need Expert [message #223269] Thu, 08 March 2007 04:02 Go to next message
UAE1
Messages: 10
Registered: March 2007
Location: UAE
Junior Member

Dear all,

im looking forward from all of you to help me in this case of ORacle problem.

i recived an error maessage :-

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

i try to solve it but still looking for the soluation

i hope any one from you who has any idea and expert in this problem ...

plase reply me as soon as you can ...

Regard's
UAE1
Re: ORA-01219<< Need Expert [message #223280 is a reply to message #223269] Thu, 08 March 2007 04:44 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
How much more explicit must an error message get.

Your database is not Open.
If you are the DBA, try 'ALTER DATABASE OPEN'
If you're not the DBA, ask him to finish starting up the database.
Re: ORA-01219<< Need Expert [message #223748 is a reply to message #223269] Sat, 10 March 2007 21:47 Go to previous messageGo to next message
UAE1
Messages: 10
Registered: March 2007
Location: UAE
Junior Member

we did alter the database but still the same problem!!

Re: ORA-01219<< Need Expert [message #223757 is a reply to message #223748] Sun, 11 March 2007 01:56 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I find it quite hard to believe that you (successfully) altered your database and still get the same error.
Why don't you copy-paste your sql session in which you show us the error-message, you opening the database and the query and its result again?
Re: ORA-01219<< Need Expert [message #223772 is a reply to message #223269] Sun, 11 March 2007 04:58 Go to previous messageGo to next message
UAE1
Messages: 10
Registered: March 2007
Location: UAE
Junior Member

actuly u didnt get what i meant ..

we did alter but nothing shows up .. we got this ERror ORA-01219

i did you command but its not running !!

if you have any other command may it help would be better ...

the problem is we cant open the database file ... any help in this case ??
Re: ORA-01219<< Need Expert [message #223917 is a reply to message #223269] Mon, 12 March 2007 04:52 Go to previous messageGo to next message
UAE1
Messages: 10
Registered: March 2007
Location: UAE
Junior Member

no one can help ??

Re: ORA-01219<< Need Expert [message #223925 is a reply to message #223917] Mon, 12 March 2007 05:01 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Send a copy-paste from exactly what you have done (from the point you try to login to the database).

Maybe we than can see where something is going wrong.

As Frank and JRowbottom allready pointed out.... somehow the database is not open.
The task now is to see how you can do open your database.
Re: ORA-01219<< Need Expert [message #224045 is a reply to message #223269] Mon, 12 March 2007 13:42 Go to previous messageGo to next message
salaku
Messages: 9
Registered: March 2007
Junior Member
Paste the ouput of

select status,startup_time from v$instance;

from sqlplus session

Re: ORA-01219<< Need Expert [message #224140 is a reply to message #223269] Tue, 13 March 2007 04:14 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
I think your DB had a problem with controlfile. You should show total of the message and its relation when you open database. Sometime damaged controlfile without multiplex causes the problems.

Previous Topic: Split Partitioning in Oracle 9i
Next Topic: upgrade to 10g
Goto Forum:
  


Current Time: Tue Dec 06 11:55:52 CST 2016

Total time taken to generate the page: 0.10694 seconds