| ORA-01219<< Need Expert [message #223269] |
Thu, 08 March 2007 04:02  |
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  |
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 #223757 is a reply to message #223748] |
Sun, 11 March 2007 01:56 |
Frank
Messages: 7901
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 |
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 #223925 is a reply to message #223917] |
Mon, 12 March 2007 05:01 |
martijn
Messages: 286
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 #224140 is a reply to message #223269] |
Tue, 13 March 2007 04:14 |
trantuananh24hg
Messages: 744
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
