Operating System - HP-UX
1748158 Members
4103 Online
108758 Solutions
New Discussion юеВ

ORA-27072: skgfdisp: I/O error HP-UX Error: 25

 

ORA-27072: skgfdisp: I/O error HP-UX Error: 25

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
5 REPLIES 5
Steven E. Protter
Exalted Contributor

Re: ORA-27072: skgfdisp: I/O error HP-UX Error: 25

Shalom,

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Jeff Crew
Advisor

Re: ORA-27072: skgfdisp: I/O error HP-UX Error: 25

Per Oracle Metalink lookup on these errors:
<>

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: : skgfdisp: I/O 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.).
Yogeeraj_1
Honored Contributor

Re: ORA-27072: skgfdisp: I/O error HP-UX Error: 25

hi,

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Kapil Jha
Honored Contributor

Re: ORA-27072: skgfdisp: I/O error HP-UX Error: 25

As Jeff said file is locked by some process.
You may check it by lsof utility.
BR,
Kapil
I am in this small bowl, I wane see the real world......
Venkatesh BL
Honored Contributor

Re: ORA-27072: skgfdisp: I/O error HP-UX Error: 25

Error 25 is ENOTTY. From the manpage of 'errno':

[ENOTTY] Not a typewriter. The (ioctl()) command is inappropriate to the selected device type.