oracle directory permssions and listener 2004-10-12 - By Hans Forbrich
On Tuesday 12 October 2004 12:28, Mohammad N. Tina wrote:
> Hi Hans,
> thanks for your post,
> oracle services runing by oracle user and not by root, i used to have
> oracle8i on sco unix and my listener is working fine..i don't think that
> there is a big difference between 8i and 9i...at least for basic setup.
Your original post states
ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL level 1
ORA-01116 (See ORA-01116.ora-code.com): error in opening database file 1
ORA-01110 (See ORA-01110.ora-code.com): data file 1: '/home/asy/rdbms/ASYDB/sys01ASYDB.dbf'
ORA-27041 (See ORA-27041.ora-code.com): unable to open file
Linux Error: 13: Permission denied
Additional information: 3
THAT set of errors has absolutely nothing to do with the listener, hence my
evident pre-coffee frustration (for which I apologize).
My tirade was to state that by the time the error has occurred, the listener
is totally out of the picture, and your client is comunicating with the
dedicated server process, in a manner similar to using the Bequeath adapter
locally to the server.
The base 'Oracle' error is ORA-27041 (See ORA-27041.ora-code.com), which simply states that the Oracle
dedicated process encountered Linux Error #13
The file it is attempting to open looks like the system tablespace. The error
"unable to open file" indicates there is something wrong with the path, the
path-user interaction, or the file itself. I am surprised that you are not
getting an error during database startup.
All indications I have are that Linux Error 13 is related to NFS - are you
mounting the Oracle directory tree under NFS by any chance?
Finally - what does the alert.log show around the startup and error?
/Hans
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
