- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle error
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
тАО05-19-2004 04:41 PM
тАО05-19-2004 04:41 PM
Oracle error
I am facing below problem in HPUX 11i in Superdome server.
The below is oracle trace.......
Node name: bscstest
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: MIS
Redo thread mounted by this instance: 0
Oracle process number: 0
3074
*** SESSION ID:(16.36) 2004-05-20 08:32:58.569
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-01114: IO error writing block to file 202 (block # 138985)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 25: Not a typewriter
Additional information: 138985
ORA-01114: IO error writing block to file 202 (block # 138985)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 25: Not a typewriter
Additional information: 138985
can anybody help on this
Thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2004 05:31 PM
тАО05-19-2004 05:31 PM
Re: Oracle error
You have an IO problem in db-file 202.
SELECT file_name from dba_datafiles where file_number = 202;
(from memory. Check column names with 'describe dba_datafiles').
Once you have the file_name try for example a copy or dd to /dev/null to confirm the io problem.
You'll probably need to restore the backups and recover with archive logs.
good luck,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2004 05:44 PM
тАО05-19-2004 05:44 PM
Re: Oracle error
check whether any of the disks have gone bad.
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2004 05:55 PM
тАО05-19-2004 05:55 PM
Re: Oracle error
1. There is no error in syslog regarding disk faliure.
2. File no 202 does not exists in database.
point which i like to mention here in that we had recreated database after a crash on manday........
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2004 05:56 PM
тАО05-19-2004 05:56 PM
Re: Oracle error
Then test the "problem disk"!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2004 06:04 PM
тАО05-19-2004 06:04 PM
Re: Oracle error
Filesystem is 61% used.....
and disk status is fine
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2004 06:16 PM
тАО05-19-2004 06:16 PM
Re: Oracle error
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2004 06:19 PM
тАО05-19-2004 06:19 PM
Re: Oracle error
looks like some permission issue looking at Oracle Metalink:
Problem Explanation: ====================
If you created another user and the permissions on the datafiles that you are trying to migrate are 600 you can not perform a data migration. When the permissions are changed to 660 the migration completes successfully.
Solution Description:
=====================
You need to change the permissions on the datafiles to 660.
You must change the permissions on the datafiles you are trying to migrate to 660. Change to the directory where the datafiles are and type the following:
chmod 660 datafile.dbf
Solution Explanation:
=====================
If another user was created and you are trying to migrate a file as the new user you must have read and write permissions to the file.
hope is helps.
regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2004 07:54 PM
тАО05-19-2004 07:54 PM
Re: Oracle error
can you try to do a full database export?
If there is a problem with a table in particular, you may trap it there!
Then if it is a database block corruption or the like, you can still try to move the table to another tablespace (alter table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2004 08:19 PM
тАО05-20-2004 08:19 PM
Re: Oracle error
202 is the file# (file ID). Do the following to see the state,name, etc... of the datafile:
select *
from v$datafile
where file# = 202
And thiso one to see more about the specific block:
select *
from dba_extents
where block_id = 138985