473,321 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

ORA-01219: database not open

I am working on Oracle database 10G. My database was working fine till last night but today when i tryed to connect, it was showing me following error:
ORA-01219: database not open: queries allowed on fixed tables/views only

So I did the following steps from command prompt:

Expand|Select|Wrap|Line Numbers
  1. C:\>sqlplus
  2.  
  3. SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jul 7 10:49:58 2011
  4.  
  5. Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
  6.  
  7. Enter user-name: / as sysdba
  8.  
  9. Connected to:
  10. Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
  11. With the Partitioning, OLAP and Data Mining options
  12.  
  13. SQL> shutdown abort
  14. ORACLE instance shut down.
  15. SQL> startup
  16. ORACLE instance started.
  17.  
  18. Total System Global Area  251658240 bytes
  19. Fixed Size                  1289964 bytes
  20. Variable Size             163578132 bytes
  21. Database Buffers           79691776 bytes
  22. Redo Buffers                7098368 bytes
  23. Database mounted.
  24. ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
  25. ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
  26.  
  27.  
  28.  
  29. SQL> select * from dba_users;
  30. select * from dba_users
  31.               *
  32. ERROR at line 1:
  33. ORA-01219: database not open: queries allowed on fixed tables/views only
  34.  
  35.  
  36. SQL> select open_mode from v$database;
  37.  
  38. OPEN_MODE
  39. ----------
  40. MOUNTED
  41.  
  42.  
Then I tried to open the database but I got errors:

Expand|Select|Wrap|Line Numbers
  1. SQL> alter database open;
  2. alter database open
  3. *
  4. ERROR at line 1:
  5. ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
  6. ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
  7.  
  8.  
  9.  
I checked this path but it is not available physically

Expand|Select|Wrap|Line Numbers
  1. SQL> recover database until cancel;
  2. ORA-00283: recovery session canceled due to errors
  3. ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
  4. ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
  5. ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
  6.  
So, what is the problem?
may someone explaine and fix this problem?

regards
Osman
Jul 7 '11 #1
4 29435
rski
700 Expert 512MB
What changed since the last time oracle started successfuly?
Did you remove manually or rename any oracle files?
Does the file C:\ORACLE\TABLE_SPACES\SWT_TBLSPC exist?


If you or somebody removed that file a dn you are sure it is not needed you can try below
Expand|Select|Wrap|Line Numbers
  1. alter database datafile 7 offline drop;
  2. alter database open;
  3.  
Jul 11 '11 #2
I'm not sure if there is any changes for oracle files.
The file C:\ORACLE\TABLE_SPACES\SWT_TBLSPC does not exist.

this file was not important
So I executed the statements above, and the problem has been solved.

But I have a question, what is the solution for this problem if I need the deleted file?

THANKS.
Jul 11 '11 #3
rski
700 Expert 512MB
If you need the deleted file you will have to recover data backup.
Jul 11 '11 #4
Thanks alot rski for your help.

osman.
Jul 13 '11 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Galina | last post by:
Hello I have created a trigger not to let records with certain fields null to be inserted into the table: BEGIN IF :new.RUL_CODE is null or :new.FES_UINS_CODE is null or :new.FES_UIO_CALOCC is...
6
by: John | last post by:
Hi Right password -> ORA-12154: TNS:Could not resolve service name wrong password => ORA-01017: invalid username/password; logon denied Tested on a Windows XP client connecting to Oracle on...
1
by: Adam Ruth | last post by:
I'm using OCI on Mac OS X and I've run into a strange problem with my TNSNAMES.ORA file. My TNSNAMES.ORA file has one entry INV4II and it works fine. However, it will only work if that is the...
6
by: bdj | last post by:
Hello! I have at set of tnsnames.ora. I wich to make an union, e.g. a single file of it. How can I do that easy? Greetings Bjørn
2
by: mpatel6 | last post by:
I had this error in alert log and my instance was down, anybody can help me? Errors in file /u01/app/oracle/admin/sotstest/bdump/sotstest_p004_626740.trc: ORA-07445: exception encountered: core...
0
by: kalpanaanand | last post by:
I am new to Oracle 9i client. i tried to log in but i am getting this error. this is my listenerfile # LISTENER.ORA Network Configuration File: C:\ProgramFiles\oracle\NETWORK\ADMIN\listener.ora #...
2
by: Dwie | last post by:
Dear All, I'm a new in Oracle DB. I'm using Windows 2000 as server and Windows XP as client. I installed Oracle Enterprise on server and Oracle 8.1 on clients. I have some client with 2 different...
5
by: Nitvar | last post by:
When i am trying to connect to oracle it is giving me these two errors ORA-12224: TNS:no listener ORA-01034: ORACLE not available I am new to oracle ,plz help I am using solaris 5.6 and...
3
nabh4u
by: nabh4u | last post by:
HI everyone, I an getting the following errors when i execute my procedure. SQL> exec PROCEDURE_NAME BEGIN PROCEDURE_NAME; END; * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error:...
1
by: hoonig | last post by:
I have this traditional error "ORA-12560:TNS:Protocol Adapter Error" when trying to connect to my Oracle 8i databases on Netware (i.e when i load svrmgr31, plus81, etc...) Listener seems to work...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.