Error: /u01/proddb/proddb/11.2.2/bin/sqlplus: Permission denied

Problem:

執行每月 WIP 報表，出現下列錯誤訊息:

[@ wip_rpt]$ gen_wip_prod_def.sh 2016 OCT 1 31
APPS Password:
WIP Defect Analysis Daily Report Generate: 01-OCT-2016
./gen_wip_prod_def.sh: line 23: /u01/proddb/proddb/11.2.2/bin/sqlplus: Permission denied
cat: ./output/ddata/dtemp-01-OCT-2016.txt: No such file or directory

Solution:

更改 sqlplus 權限:

[root@erp ~]# cd /u01/proddb/proddb/11.2.2/bin/
[root@erp bin]# ls -l sqlplus
-rwxr-x--- 1 proddba proddba 9181 Apr  4  2013 sqlplus
[root@erp bin]# chmod 755 sqlplus