Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange problem releasing inodes

Re: Strange problem releasing inodes

From: EdStevens <quetico_man_at_yahoo.com>
Date: 28 Jan 2007 11:30:40 -0800
Message-ID: <1170012640.573978.155280@a75g2000cwd.googlegroups.com>

On Jan 27, 5:07 pm, "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote:
> On Jan 26, 10:06 am, "EdStevens" <quetico_..._at_yahoo.com> wrote:
>
>
>
> > OS: SunOS 5.10,Sun-Fire-V440
> > Oracle: 10.2.0.1.0
>
> > A couple of months ago we had an issue on this server with the OS
> > claiming we were running out of space on the file system holding most
> > of the Oracle files. Closer investigation showed 'some sort of
> > problem with the inodes'. We stopped the db, the SA ran some
> > utility, and the space usage dropped from 98% to around 50%.
>
> > A couple of weeks ago, began getting indications were were in the same
> > situation. Files are not growing, but reported FS usage is. Another
> > repair operation was scheduled for last night. As soon as we stopped
> > the databases the SA reported that reported FS usage immediately
> > dropped.
>
> > As far as database usage on this server, we have three databases. One
> > is rather small, vanilla db backing a packaged app (Clarity/Niku); one
> > is a physical standby running in recovery mode, and the third is an
> > 8.1.7.4 that serves as a proxy client between the app and the physical
> > standby in the event it becomes the primary. (Long story. Short
> > version is app was written in Pro*C 8.1, then the source code lost.
> > Solution is to put up an 8.1.7.4 for the app to connect to, and use
> > synonyms and a db link to pass all activity through to the 10.2 db
> > where the data actually resides.) We have a shell script that runs
> > daily (via cron) to delete old archive logs a few days after they have
> > been applied to the physical standby. Since the archivelogs are
> > written to a new directory each day
> > (/db01/archive/epspd/arc/<SID>/archivelog/<yyyymmdd>, the delete is
> > actually deleting the date-based directory, not the enumerated
> > archivelog files:
>
> > find ${TARGET_DIR} \( -name "*" -type d \) -mtime +$RETAIN_DAYS -exec
> > rm -rf {} \;
>
> > Any ideas?
>
> > BTW, today is my last day on this job -- starting a new job on Monday.
> > Of course, I'll be able to follow and participate in this thread, but
> > won't be able to work a TAR with MetaLink or actually follow up with
> > the SA's here. But I thought this was a pretty interesting problem
> > that was worth some discussion.Ok you had an earlier problem that involved oracle and "you believe"
> that the system administrator "did something".
>
> Not quite sure that's the followup I would want to see from someone
> posting on cdos so frequently. Don't you get a bigger bank from your
> buck by knowing all the details of a problem?
>
> Posting on cdos when a similar problem occurs isn't exactly the same
> thing as getting all the details when a problem happens the first
> time.
>
> I would expect that you might get a better idea of what is involved by
> calling the system administrator and "even though you are leaving"
> asking them for a complete explanation. Buying them a beer might be a
> good way of getting to the point of being able to ask your question.

That's one of the big reasons I left that job. Getting information from the SA is nigh unto impossible. Don't get me started on a litany .. ;-) Suffice it to say there is a pronounced lack of cooperation and information sharing among the various groups. Received on Sun Jan 28 2007 - 13:30:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US