"SET UID" not set for oracle executable ?

From: Prem Khanna J <premj_at_rediffmail.com>
Date: 10 Aug 2004 11:10:00 -0000
Message-ID: <20040810111000.16241.qmail@webmail30.rediffmail.com>

Hi All,
the env is oracle EBS 11.5.9/ Database 9.2.0.4/AIX5.2L

i am facing the error below on instance

ORA-01110: data file 401: '/home01/db02/dev02data/perfstatd01.dbf'
ORA-01114: IO error writing block to file 401 (block # 1)
ORA-27041: unable to open file

IBM AIX RISC System/6000 Error: 13: Permission denied Additional information: 3

further study about this error on metalink revealed that i have to check my file permission of oracle executable.it is as below.

-rwxrwxr-x 1 dev01 dba /home01/db01/dev01/9.2.0/bin/oracle*

i dont find "SET USER ID" set on this file,whereas for oracle executables of other instances on the same machine has it properly set

-rwsrwxr-x 1 dev02 dba /home01/db02/dev02/9.2.0/bin/oracle*

when & why does this happen ? How do i prevent this error ? Any help would be of immense help.TIA.

Regards,
Prem.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Aug 10 2004 - 06:05:44 CDT