Oracle error after HP UX patch updation

[Syed Salman Mansoor]

I recently updated my HP UX 11.23 to latest available patches. Everything seems to be working fine but on Oracle 9i following error occured while creating archives.

Errors in file /oracle/home/admin/pibassrv/bdump/pibassrv_arc1_557.trc:

ORA-19502: write error on file "/backup/archives/1_85.arc", blockno 1 (blocksize=1024)

ORA-27072: skgfdisp: I/O error

HPUX-ia64 Error: 22: Invalid argument

Can anybody have any clue?

[T G Manikandan]

You need to check the disk for the mountpoint /backup, check whether its online.

Also check syslog.log to see additional information for this error.

[Jozef_Novak]

Hello,

I did a quick search on this topic, all results suggest to check the file that is unable to be written to. This might include incorrect file permissions, filesystem full or a disk HW error.

Jozef

[Syed Salman Mansoor]

/backup filesystem is mounted. Space is also available and permission is 644 with owner is oracle.

[T G Manikandan]

ls -ld /backup
ls -ld /backup/archives

it should be 755 and not 644, please check.

[Steven E. Protter]

Shalom,

Try relinking oracle.

That usually solvesproblems like this.

SEP

[T G Manikandan]

Steven is right, relinking oracle should solve most of these issues unless you did not explicitly change permissions for these directories.

[Syed Salman Mansoor]

Yes. /backup have 755 and /backup/archive have 777.

[rariasn]

Hi,


Stop all Oracle process, and

$ relink all

rgs.

[Syed Salman Mansoor]

I relinked the oracle binaries but still facing same issue. If I make datafiles and archives < 4 MB it works fine. But when it exceeds this size again same issue occurs. Please advice as this is my production database.