Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2006
    Posts
    6

    Unanswered: ls -ltr hangs with oracle

    I am not a Oracle person but our db person is saying when she types ls -l or ls -ltr in the directory where her dbs files are that everything hangs.They always have to reboot the system to clear it up. Has anybody seen this problem before? Is it a log files issue or a problem on the unix server?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is it a log files issue or a problem on the unix server?
    Most likely an OS issue.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2006
    Posts
    9
    Quote Originally Posted by okdalst
    I am not a Oracle person but our db person is saying when she types ls -l or ls -ltr in the directory where her dbs files are that everything hangs.They always have to reboot the system to clear it up. Has anybody seen this problem before? Is it a log files issue or a problem on the unix server?
    It seems hard drive issue.

  4. #4
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Quote Originally Posted by okdalst
    when she types ls -l or ls -ltr
    Well then the "t" and "r" options are not relevant to the problem, are they?

    Does the "l" option make any difference either or is that another red herring?

  5. #5
    Join Date
    Mar 2006
    Posts
    9
    -l option = long list (permission, user:group, size, date-time,filename...)
    -t option = time
    -r option = recursive order

    Combination of -ltr = list all files (except hidden) and sort by time - newest file will be at bottom.

  6. #6
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Quote Originally Posted by sbinh
    -r option = recursive order
    Reverse order I think

    Recursive is -R

  7. #7
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    As you said that this happens in directory where .DBS files are, I wonder if this also happens in any other directory which is also "heavy loaded" - I mean, database files are (I suppose) quite large in size.

    Can you reproduce such a scenario putting large files into another directory (for example, a few backup files or something like that) and try this command there? If it hangs again, I'd say that it is about operating system (just like Anacedent said) and has nothing to do with Oracle (pure coincidence).

  8. #8
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    I'm not holding my breath for scientific analysis from someone who encounters a problem after entering "ls -ltr" in a directory containing Oracle files and concludes that "ls -ltr" causes problems with Oracle.

    Perhaps the command "ls -ltr" always hangs with Oracle on the last Friday in March.

  9. #9
    Join Date
    Mar 2006
    Posts
    6
    Quote Originally Posted by WilliamR
    I'm not holding my breath for scientific analysis from someone who encounters a problem after entering "ls -ltr" in a directory containing Oracle files and concludes that "ls -ltr" causes problems with Oracle.

    Perhaps the command "ls -ltr" always hangs with Oracle on the last Friday in March.

    Found out it was a AIX 5.1.0.0 problem with Oracle. Once it's updated to the latest OS patch, problem solved. Thanks to all repliers on this for the help and ideas...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •