Friday, August 17, 2007

find: cannot stat odbc while running changePerm.sh

> ./changePerm.sh

-------------------------------------------------------------------------------
Disclaimer: The purpose of this script is to relax permissions on some of the
files in the database Oracle Home so that all clients can access them.
Please note that Oracle Corporation recommends using the most restrictive file
permissions as possible for your given implementation. Running this script
should be done only after considering all security ramifications.
-------------------------------------------------------------------------------

-n Do you wish to continue (y/n) [n]:
y
find: cannot stat odbc

Finished running the script successfully
Please see /tmp/changePerm_err.log for errors and /tmp/changePerm.log for the log of events


--excerpt from Note:453603.1

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3
This problem can occur on any platform.

Symptoms

-- Problem Statement:
While running changePerm.sh on 10.2.0.3, getting following error
find: cannot stat odbc
Finished running the script successfully
Please see /tmp/changePerm_err.log for errors and /tmp/changePerm.log


Cause

Most likely cause of this problem is there is no odbc directory inside $ORACLE_HOME.
The changePerm.sh script cannot find the folder odbc and the log files /tmp/changePerm_err.log for errors and /tmp/changePerm.log are 0 bytes


Solution

-- To implement the solution, please execute the following steps::
Ignore the error message
The script has been run successfully. The permissions inside $ORACLE_HOME should be relaxed.