General
cancel
Showing results for 
Search instead for 
Did you mean: 

error messages connecting to database

error messages connecting to database

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.

persistence is the road to success
6 REPLIES
Sukant Naik
Trusted Contributor

Re: error messages connecting to database

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
Who dares he wins
Volker Borowski
Honored Contributor

Re: error messages connecting to database

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
Trusted Contributor

Re: error messages connecting to database

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
Honored Contributor

Re: error messages connecting to database

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
Honored Contributor

Re: error messages connecting to database

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

Re: error messages connecting to database

T G Manikandan

Thanks for the information. My problem was a corrupted datafile.
persistence is the road to success