- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ORA-27072: skgfdisp: I/O error HP-UX Error: 25
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
тАО10-17-2007 01:04 AM
тАО10-17-2007 01:04 AM
ORA-27072: skgfdisp: I/O error HP-UX Error: 25
I'm seeing the following errors & I'm wondering if anyone knows what the HP-UX Error: 25 is trying to tell me. I know a #28 is no space on the device, but I can't find any info on #25.
I'm also assuming that the file 422 is an Oracle file number (can someone confirm that). I believe this was a datafile for a temporary tablespace that I dropped & refined, so I can't verify it. I know longer see a file #422 in our instance.
Thanks!
ORA-01114: IO error writing block to file 422 (block # 98082)
ORA-27072: skgfdisp: I/O error HP-UX Error: 25: Not a typewriter Additional information: 98082
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2007 01:51 AM
тАО10-17-2007 01:51 AM
Re: ORA-27072: skgfdisp: I/O error HP-UX Error: 25
When Oracle shells the the OS, there is no tty or terminal information or environment or anything. This should not stop the script from functioning.
For some reason the script is trying to use a device that is not present. You MAY be able to fix this by editing the oracle script and sourcing in an environment and some stty information.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2007 04:14 AM
тАО11-26-2007 04:14 AM
Re: ORA-27072: skgfdisp: I/O error HP-UX Error: 25
<
This document explains the common causes for the following errors:
A scheduled job failed with an error in the alert log about a file being locked by another process.
ORA-12012: error on auto execute of job 41
ORA-01114: IO error writing block to file 3 (block # 886627)
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
<
This error usually comes accompanied with error:
Which is caused by read/write/readv/writev system call returned error, additional
information indicates starting block number of I/O
The operating system is reporting the error : O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
In brief, NT-33 is an error_lock_violation indicating that a portion of the data file is locked by another NT process.
This is NOT an Oracle problem as the data file is locked at the OS level by another process other than Oracle.
You should also check whether there is software that accesses the database files in order to see why the files are reported as being locked (i.e. : a Virus Scanner etc.).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2007 02:44 PM
тАО11-26-2007 02:44 PM
Re: ORA-27072: skgfdisp: I/O error HP-UX Error: 25
Yes. File 422 is the file corresponding to a tablespace in your database. You can find more information about that using the following query:
select * from dba_data_files where file_id
=422;
E.g.
FILE_NAME :
+DG_DATA/mydb/datafile/dxlarge01.281.627235031
FILE_ID : 16
TABLESPACE_NAME : DXLARGE01
BYTES : 2988441600
BLOCKS : 364800
STATUS : AVAILABLE
RELATIVE_FNO : 16
AUTOEXTENSIBLE : YES
MAXBYTES : 34359721984
MAXBLOCKS : 4194302
INCREMENT_BY : 6400
USER_BYTES : 2983198720
USER_BLOCKS : 364160
ONLINE_STATUS : ONLINE
(nb. we are using ASM so the file name is displayed differently)
hope this helps!
You need to post additional information concerning what has been done before the error occurred. Check also if the file is on the file system.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2007 03:11 PM
тАО11-26-2007 03:11 PM
Re: ORA-27072: skgfdisp: I/O error HP-UX Error: 25
You may check it by lsof utility.
BR,
Kapil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2007 03:28 PM
тАО11-26-2007 03:28 PM
Re: ORA-27072: skgfdisp: I/O error HP-UX Error: 25
[ENOTTY] Not a typewriter. The (ioctl()) command is inappropriate to the selected device type.