error messages connecting to database

[Evella Dawson]

We have migrated our datafiles,logfiles,backup control files to a STORAGE AREA NETWORK server.
The migration was from WINNT 4.0 server Oracle 8.0.4. I was trying to point to the SAN storage server. I am getting the current error messages:
ORA-00604error occured at recursive SQL level 1
ORA-00376:file 6 canot be read at this time
ORA-01110:data file 6:'P:\database\databasenameORA-02002:error while writing to audit trail.

It seem like my controlfile is corrupted, just guessing.

[Sukant Naik]

Hi,

What is the OS where you have migrated your database ?

You need to run the following command

SVRMGR> alter database backup controlfile to trace;

This command will create a trace file, which will contain the control file. So find out what the datafiles have been set to and accordingly change the control file.

-Sukant

[Volker Borowski]

Hi,

you might need to rearange the drive letters, if you now have partitions on the SAN.

I.E. if you had
local
d: e: f:
and moved these to
p: q: r:
now, you will have to reassign the
drive letters in the nt diskmanager so that everything is located correctly again.
The other option would be to create a new controlfile and let oracle know, that the location changed.

Hope this helps
Volker

[Jeanine Kone]

The message does not seem to be indicating (to me anyway) a problem with the controlfile. It just looks like it cannot access the specified datafile (while it was trying to insert into the audit table?).

When exactly are you getting this error? When trying to start the database? When you say you were trying to "point to" the SAN storage, were you renaming the datafiles - ot just starting up with the same exact file names?

[T G Manikandan]

Hello Dawson,
I looks to me like the cannot access the datafile might be the datafile is not present in the path specified.

It is looking for a non existing datafile

[T G Manikandan]

Dawson,
Are you getting errors during startup of the database.
Can you please post your alert.log file and some explanation what was done and when did you get this error.

I also suspect whether one of the datafiles of the rollback
tablespace is offine.

Reply back

Thanks

[Evella Dawson]

T G Manikandan

Thanks for the information. My problem was a corrupted datafile.