Oracle 8.1.7 tracefile: errno=13

[Andreas D. Skjervold]

Hi

I'm getting the following trace file on my 8.1.7 databases upon each startup:

Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
JServer Release 8.1.7.0.0 - 64bit Production
ORACLE_HOME = /oracle/product/8.1.7
System name: HP-UX
Node name: bico_utv
Release: B.11.00
Version: U
Machine: 9000/800
Instance name: TEST8i
Redo thread mounted by this instance: 0
Oracle process number: 0
8787

User does not have permission : errno=13

Anyone been there?

Andreas

[Alexander M. Ermes]

Hi there.
Check the rights for your Oracle directories.
One of them ( tracefile directory ) may either not be owned by oracle or does not have the right mode or does not even exist.
Rgds
Alexander M. Ermes

[Magdi KAMAL]

Hi Andreas,

errno 13 is PERMISSION DENIED.
Have a look on /usr/conf/h/errno.h.

You may have problems due to :
1. Not having the right user name.
2. Not having the right group name.
3. Permission on directories and files.

Magdi

[T G Manikandan]

Hello,
Make the user as a member of the dba group.
Retry the operation.

Thanks
GM

[Andreas D. Skjervold]

Hi again!

My directories is owned by the oracle sw owner (login:oracle8i) and group oinstall.
All directories have 755 rights.
Tracefile directories seem OK too.

User oracle8i is member of dba group and has oinstall as primary group.

[AlHassani Mohamed]

it is a question of authorization problems, how most have found. You must examine:
whether the Oracle-user that correct group is assigned.
whether the oper-roup is installed or defined.
whether the start pocedure are assigned to the correct user.
whether if S-bit is be set
whether other mistakes in the oracle-tracefile like ora-00942 are taken down.
mo.

[Andreas D. Skjervold]

Hi
Oracle Support is now looking into this, as I can't find anything wrong with permissions, ownership etc.

I'll let you know.

[T G Manikandan]

Hello,
Just try the permissions to the directories as
775.
have a go!
These permissions will also give full rights to the oracle group.

GM

[Andreas D. Skjervold]

Have tried 775, and didn't reslove the problem...

[T G Manikandan]

Hello,
Check the permissions of the archive log directories if your database is running in archivelog mode.
Also check the trace directory permissions.
Open your init.ora file and find the directory path you have mentioned there and respectively check the permissions for them.
Thanks
G Manikandan

[Jorge E. Litzmann]

If it's not to late, here you have a work around about it.

[Sanjay_6]

Hi Andreas,

Anything under /Oracle should be owned by User Oracle and the group to which oracle belong. We have set the group to dba.

Also look for the permission of these files and directories which should be owned by oracle and group dba
/etc/oratab
/etc/listener.ora
/var/opt/oracle
/usr/local/bin

Also check for the permission of the temp directories /temp and /tmp. Also /var/tmp.

Hope this helps.

Thanks

[Kawah Cheung]

Hi,

I am getting the same problem. Did you Oracle or yourself manage to find a solution?

Rgds,
Kawah

[Andreas D. Skjervold]

Hi

Didn't find a solution.
Have applied patchset 8.1.7.3.0 and the trace still comes.
But everything runs smoothly and bases are seldom started som this is infact not a problem anyway (just an anoyance)

rgds
Andreas

[John Dixon_1]

Hi,
bit of a long shot this one...

Have you got the log_archive_trace parameter set in initTEST8i.ora?
Try setting this to zero to disable tracing.

cheers,
John

[Kawah Cheung · Accepted solution]

Hi, I managed to find a solution to this with the help of the tusc command.

tusc -afpo /tmp/tusc.out sqlplus [enter]
username: /as sysdba
Connected to an idle instance.
SQL> startup

This produces a trace, and shows you what is actually happening when you issue the oracle startup command. Looks like junk but pretty useful when you know what to look for. when "permissions" are involved, searching for "ERR#13" will normally direct you to the right place, when analysing tusc output file. What was happening in my case was that oracle did not have permission to /dev/async (asynchronous io). Once permission were amended, no more trace files were being produced. Tusc is not an HP utility - you can download it from http://eigen.ee.ualberta.ca/hppd (hit search button and search for tusc).

All the best.

Kind Regards,
Kawah

[Volker Borowski]

WOW,
finally a solution for a nine month old thread.
Something you should report in DAN's success thread !

(N/A) for this please
Volker

[Andreas D. Skjervold]

Well you might call it a success but realy this was just an minor disturbance, so I don't think it really counts that much.

Thanks anyway everybody!

Andreas