Stange ls reply 1

[Gloups]

Hi list, i've a strange ls reply with some oracle data files. I'm sure you'll find the problem.

here commes a part of the output ou ls -l on my directory:

ls -l /data/oradata1/INFOT/tudata
...
...
...
-rw-r----- 1 oracle oinstall 2936020992 Sep 12 13:22 situ10072005C.dbf
-rw-r----- 1 oracle oinstall 9017761792 Sep 12 13:25 situ10092005.dbf
-rw-r----- 1 oracle oinstall 4613742592 Sep 12 13:25 situ11082005C.dbf
-rw-r----- 1 oracle oinstall 2516590592 Sep 12 13:25 situ12062005.dbf
-rw-r----- 1 oracle oinstall 3145736192 Sep 12 13:25 situ12092005.dbf
-rw-r----- 1 oracle oinstall 5242888192 Sep 12 13:24 situ13072005C.dbf
...
...
...


If i try a spécific le on file situ12062005.dbf

ls -l /data/oradata1/INFOT/tudata/situ12062005.dbf

it replies:

/data/oradata1/INFOT/tudata/situ12062005.dbf not found


file commande replies
/data/oradata1/INFOT/tudata/situ12062005.dbf: cannot open



There is a problem i haven't found but all datas contained in this data file seems to be online accessing with oracle request.

 

[hirschaj]

I have seen an issue like this before. The problem probably lies in the permision on the mount point. When you get a chance, unmount that filesystem and open up the permissions on the mount point so that it is world readable and world executable. Re-mount the filesystem and see if the problem persists.


Jim Hirschauer

http://www.aixexpert.com

 

[Gloups]

I'll try that, but it's still strange that only certain files appears like that in the same filesystem

 

[kHz]

You may want to try an fsck on the filesystem. It may have become corrupted which would explain the problems you are encountering with an `ls.`

 

[alexhu]

Try an ls -b on your file. It may have special characters in the filename. I seem to remember this does not stop Oracle from working

Alex

 

[Gloups]

i've already tested with ls -b. There is'nt any special char in the name of the file

 

[Gloups]

I've just checked the file system and all is ok ...

 

[p5wizard]

long shot: perhaps there's one or more trailing blanks in the file names?

$ ls -l|grep test
-rw-rw-r--   1 user01   staff          1 Sep 13 14:13 test 
drwxrwxrwx   2 user01   staff        512 Jul 31 1998  testdir

$ ls -l test
ls: 0653-341 The file test does not exist.

$ ls -l 'test '
-rw-rw-r--   1 user01   staff          1 Sep 13 14:13 test 

$ for i in test*
do
echo "'$i'"
done
'test '
'testdir'

These blanks don't show up in an ls -d - well they do show up, but are just hard to see

$ ls -bl|grep test
-rw-rw-r--   1 user01   staff          1 Sep 13 14:13 test 
drwxrwxrwx   2 user01   staff        512 Jul 31 1998  testdir

$ ls -bl|grep test|sed 's/  *$/BLANKSHERE/'
-rw-rw-r--   1 user01   staff          1 Sep 13 14:13 testBLANKSHERE
drwxrwxrwx   2 user01   staff        512 Jul 31 1998  testdir

But be careful, I would not rename the files if they are in use by Oracle, apparently Oracle has created the files like this (perhaps you typed the blanks in the filename box when creating 'em) and expects them to be there like this!


HTH,

p5wizard

 

[Gloups]

That's true p5wizard ijust found it before reading you reply

Thank's all