16 апреля 2008 г.

Ошибка после установки патча 10.2.0.3

После апгрейда 10.2.0.1 до 10.2.0.3, база не поднялась с такой ошибкой:

ORA-00202: control file: '/zones/u01/app/oracle/oradata/OASDB/control01.ctl'
ORA-27037: unable to obtain file status
SVR4 Error: 25: Inappropriate ioctl for device


Платформа: Solaris 10. Вырезка из металинка:
"The 10.2.0.3 patchset code changes attempted to use directio() calls in a manner not supported by the filesystem.

This issue affects VxFS filesystems which are typically managed by Veritas or Solstice. This issue may also affect QFS filesystems and SAM-FS filesystems. It is not known to affect UFS filesystems even if they are managed by Veritas or Solstice."

Решение: установка пачта 5752399.