Hi.
Can you find out if you are user reiserFS as File System.
Your problem looks very similar to those encountered when using this
particular file system.
Nico
-----Original Message-----
From: Luis Cardenas [mailto:Luis.[Email address protected]
Sent: Wednesday, May 30, 2007 1:50 PM
To: Nicolas de Fontenay
Subject: RE: Data File missing.
Nico,
server Linux red had 4.3 enterprise edition.
The tablespace for this datafile is no longer there, the file is not
visible in v$datafile
any suggestions?
Luis
-----Original Message-----
From: Nicolas de Fontenay
[mailto:nicolas.[Email address protected]
Sent: 30 May 2007 07:30
To: Luis Cardenas
Subject: RE: Data File missing.
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
Another question:
Is your server using Linux Suse for OS?
Nico
-----Original Message-----
From: Luis Cardenas
[Email address protected]
Sent: Wednesday, May 30, 2007 1:13 PM
To: LazyDBA Discussion
Subject: Data File missing.
Expertos,
got this error in my alert log:
Errors in file /u01/app/oracle/admin/QWEB1/bdump/qweb11_dbw0_6415.trc:
ORA-01186: Message 1186 not found; No message file for product=RDBMS,
facility=ORA; arguments: [76]
ORA-01157: Message 1157 not found; No message file for product=RDBMS,
facility=ORA; arguments: [76]
ORA-01110: Message 1110 not found; No message file for product=RDBMS,
facility=ORA; arguments: [76]
[/u01/app/oracle/product/10.1/db/dbs/ts_dba_ola_data01.dbf]
The database is up and running, when I query dba_data_files it brings
back the same error as above.
How to procede? Thanks
-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768840). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page