Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 8.1.7 tracefile: errno=13

SOLVED
Go to solution
Andreas D. Skjervold
Honored Contributor

Oracle 8.1.7 tracefile: errno=13

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
17 REPLIES
Alexander M. Ermes
Honored Contributor

Re: Oracle 8.1.7 tracefile: errno=13

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Magdi KAMAL
Respected Contributor

Re: Oracle 8.1.7 tracefile: errno=13

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
Honored Contributor

Re: Oracle 8.1.7 tracefile: errno=13

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

Thanks
GM
Andreas D. Skjervold
Honored Contributor

Re: Oracle 8.1.7 tracefile: errno=13

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.

Only by ignoring what everyone think is important, can you be aware of what everyone ignores!

Re: Oracle 8.1.7 tracefile: errno=13

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.
the world of unix is beautifull
Andreas D. Skjervold
Honored Contributor

Re: Oracle 8.1.7 tracefile: errno=13

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

I'll let you know.
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
T G Manikandan
Honored Contributor

Re: Oracle 8.1.7 tracefile: errno=13

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
Honored Contributor

Re: Oracle 8.1.7 tracefile: errno=13

Have tried 775, and didn't reslove the problem...
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
T G Manikandan
Honored Contributor

Re: Oracle 8.1.7 tracefile: errno=13

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
Occasional Advisor

Re: Oracle 8.1.7 tracefile: errno=13

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

Re: Oracle 8.1.7 tracefile: errno=13

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
Advisor

Re: Oracle 8.1.7 tracefile: errno=13

Hi,

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

Rgds,
Kawah
If in doubt, ask!
Andreas D. Skjervold
Honored Contributor

Re: Oracle 8.1.7 tracefile: errno=13

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
John Dixon_1
Advisor

Re: Oracle 8.1.7 tracefile: errno=13

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
Advisor
Solution

Re: Oracle 8.1.7 tracefile: errno=13

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
If in doubt, ask!
Volker Borowski
Honored Contributor

Re: Oracle 8.1.7 tracefile: errno=13

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
Honored Contributor

Re: Oracle 8.1.7 tracefile: errno=13

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!