Cannot open [No such file or directory]


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cannot open [No such file or directory]
# 1  
Old 06-28-2012
Cannot open [No such file or directory]

I am seeking help on one script that I created to celan up database audit files. The error returned is

Code:
$./clean_audit.sh[41]: /opt/oracle/logs/audit_clean.log: cannot open [No such file or directory]

The same script is working on other 2 or 3 servers. But not working on other 4 servers. All servers are Oracle Linux. Here is my shell script:

Code:
#!/bin/ksh
# This shell performs a full clean audit files  of each DB that is running
export PATH=/opt/oracle/product/11.2.0.2/dbhome_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
export ORACLE_PATH=/opt/oracle/scripts/sql:$ORACLE_HOME/rdbms/admin
export SCRIPTSDIR=/opt/oracle/scripts
export SCRIPTSLOG=/opt/oracle/logs
export LOGFILE=$SCRIPTSLOG/audit_clean.log
export ORACLE_BASE=/opt/oracle
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
export ORATAB=/etc/oratab
export ORACLE_HOME=/opt/oracle/product/11.2.0.2/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH:/usr/contrib/bin


if [ -f $LOGFILE ]; then
  rm $LOGFILE
fi

orasids=`cat /etc/oratab | grep '11.2.0.2/dbhome_1:Y$' | awk -F: '{print $1}' -`

for sid in ${orasids[*]}
do
export ORACLE_SID=$sid
export SYSPW=`cat /opt/oracle/scripts/cron/.sys_pw_$ORACLE_SID`
echo "----------------------------------------------" >> $LOGFILE
echo "Job: Clean Audit files" >> $LOGFILE
echo "Database: $ORACLE_SID \t \t \t \t Hostname: `hostname`" >> $LOGFILE
echo "----------------------------------------------" >> $LOGFILE

sqlplus -s  << EOF
/ as sysdba
@/opt/oracle/scripts/sql/clean_audit.sql
exit
EOF
done
exit 0

Please tell me why log file cannot be created and opened and also other problems it may contains. Thank you very much

Last edited by radoulov; 06-28-2012 at 06:38 PM.. Reason: please use code tags
# 2  
Old 06-28-2012
I suspect it means what it says -- no such file or directory. If it were permission denied, it'd say permission denied. Find out where the file's actually being stored.

Alternately, I don't suppose carriage returns could've ended up in that file somehow?
# 3  
Old 06-28-2012
Try to touch that audit_clean.log in unix then it may fix your problem. I have the same before because i created that log in windows, after doing that it works, i have no idea :-)
# 4  
Old 06-28-2012
Thanks for both of you to advise. I have touched a audit_clean.log file in /opt/oracle/logs directory and checked to see there is no permission issue. But it still return the same error message. What is the solution?
# 5  
Old 06-28-2012
Quote:
Originally Posted by Corona688
Alternately, I don't suppose carriage returns could've ended up in that file somehow?
As in, what did you edit that script with, and how did you upload it?
# 6  
Old 06-28-2012
I ftp transfer the script from one server that run this script successfully. Then chmod 755. edit by vi.
# 7  
Old 06-28-2012
Try this anyway:
Code:
tr -d '\r' < oldscript > newscript
chmod 755 newscript
./newscript

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Linux open failed: No such file or directory error

Hi, The below commands works fine on serverB . /etc/profile; cd /export/home/user2/utils/plugin/ ./runme.shHowever, when i run the same commands from serverA it fails $ ssh -q user2@serverB ". /etc/profile; cd /export/home/user2/utils/plugin; ./runme.sh"Output Error: Please find the below... (8 Replies)
Discussion started by: mohtashims
8 Replies

2. Linux

Cannot open shared object file: No such file or directory

Hi, While running tcpdump command on my Fedora 16 machine I am get shared library issue. # tcpdump tcpdump: error while loading shared libraries: libcrypto.so.6: cannot open shared object file: No such file or directory # which tcpdump /usr/software/sbin/tcpdump I have tried... (3 Replies)
Discussion started by: muzaffar.k
3 Replies

3. Solaris

./curl -V showing fatal: libldap.so.5: open failed: No such file or directory

Hi Guys, I am facing this Error bash-2.03$ ./curl -V ld.so.1: curl: fatal: libldap.so.5: open failed: No such file or directory Killed bash-2.03$ while executing ./curl -V in /opt/sfw/bin directory. I am using Sun Solaris 10. which package upgrage can give me this missing... (9 Replies)
Discussion started by: manalisharmabe
9 Replies

4. Shell Programming and Scripting

Awk: cannot open file (No such file or directory)

Hello folks! I am new to Shell and awk scripting. This is my shell script that receives a string as an input from the user from the stdin. #!bin/sh printf "Enter your query\n" read query cmd=`echo $query | cut -f 1 -d " "` input_file=`echo $query | cut -f 2 -d " "` printf $input_file... (10 Replies)
Discussion started by: radiohead_
10 Replies

5. Shell Programming and Scripting

fatal: cannot open file `TNAME' for reading (No such file or directory)

Hi, I am running this command through a shell script and getting the error mentioned in the subject line: testing.awk -f x.txt TNAME My testing.awk file contains something like ++++++++++++++++++ #!/usr/bin/awk -f BEGIN{ TAB_NAME="INSERT_ONE_" ARGV ; } if ( $1=="JAM_ONE" &&... (1 Reply)
Discussion started by: kunwar
1 Replies

6. Red Hat

libodbc.so.1: cannot open shared object file: No such file or directory

We are trying to install third party software on this unix server... Here is the error message we are getting... error while loading shared libraries: libodbc.so.1: cannot open shared object file: No such file or directory It seems like odbc driver is not installed... >rpm -q unixODBC... (1 Reply)
Discussion started by: govindts
1 Replies

7. UNIX for Advanced & Expert Users

how to open a last modified file in a directory

how to directly open a last modified file in a directory? Please help (5 Replies)
Discussion started by: apsprabhu
5 Replies

8. Solaris

Error- ld.so.1: expr: fatal: libgmp.so.3: open failed:No such file or directory

Hi Friends I have a compiler(Sun Forte,I believe) running in my Solaris 9 box. since y'day my development team is finding this error when they compile: ld.so.1: expr: fatal: libgmp.so.3: open failed: No such file or directory I ran a search for this file and found it in one of my file... (2 Replies)
Discussion started by: Hari_Ganesh
2 Replies

9. Programming

libRmath.so: cannot open shared object file: No such file or directory

% locate Rmath /m/backup/backup/lib/R/include/Rmath.h /usr/lib/R/include/Rmath.h % gcc -g -o stand stand.c -I/usr/lib/R/include/ -lRmath -lm % ./stand ./stand: error while loading shared libraries: libRmath.so: cannot open shared object file: No such file or directory What's the trouble... (6 Replies)
Discussion started by: cdbug
6 Replies
Login or Register to Ask a Question