- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- error messages connecting to database
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2002 04:29 AM
тАО07-03-2002 04:29 AM
error messages connecting to database
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2002 04:47 AM
тАО07-03-2002 04:47 AM
Re: error messages connecting to database
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2002 04:55 AM
тАО07-03-2002 04:55 AM
Re: error messages connecting to database
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2002 07:42 AM
тАО07-03-2002 07:42 AM
Re: error messages connecting to database
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-04-2002 02:49 AM
тАО07-04-2002 02:49 AM
Re: error messages connecting to database
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-04-2002 03:01 AM
тАО07-04-2002 03:01 AM
Re: error messages connecting to database
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-04-2002 01:39 PM
тАО07-04-2002 01:39 PM
Re: error messages connecting to database
Thanks for the information. My problem was a corrupted datafile.