When you track it you will see that something caused it to get near a limit.
For example each time you kick off an import it will ask for memory to do
the import.
"richie" <richchri_at_erols.com> wrote in message
news:9a436674.0306180905.732a645b_at_posting.google.com...
> For all that care:
>
> to get around this i lowered the shared_pool_size in the orainit
> file freeing up more free ram to other processies (which i guess
> oracle couldn't then spwan off hence the ora-03113 error). what
> bothers me is that this database was up and running with no problem
> for months. it's strickly backup storage. we do not develope on it,
> no processies use it. so it's not like the ram usage requirements
> went up in the last few months. now with oracle you allocate the
> fixed amount of ram it can eat up, is this not correct? so it
> shouldn't of been trying to use anymore ram then was already allocated
> for it?
>
>
>
> richchri_at_erols.com (richie) wrote in message
news:<9a436674.0306160618.3203e5d1_at_posting.google.com>...
> > Every now and then I have this problem where i can't import anything
> > any longer into the database. It will just hang at the same spot.
> > Then eventually come back with an error shown below. In the past
> > restarting the database would clear up the issue and the import would
> > work. However, restarting the database doesn't appear to help
> > anylonger. There are no errors in the alert<sid>.log or any other log
> > that I can find. Any help would be greatly appreciated as this issue
> > is really starting to get on my nerves! Thanks in advance for your
> > help.
> >
> >
> > . . importing table "ACCESS_FLAGS"
> > 4 rows
> > imported
> > . . importing table "BILL_DETAIL_MAP"
> > 40 rows
> > imported
> > . . importing table "BILL_SECTIONS"
> > 7 rows
> > imported
> > . . importing table "BROWSER_OPTIONS"
> > 9 rows
> > imported
> > . . importing table "BUTTON_WEIGHT"
> > 30 rows
> > imported
> > . . importing table "CALL_RECORDS_200305_1"
> > IMP-00058: ORACLE error 3113 encountered
> > ORA-03113: end-of-file on communication channel
> > IMP-00058: ORACLE error 3114 encountered
> > ORA-03114: not connected to ORACLE
> > IMP-00000: Import terminated unsuccessfully
Received on Wed Jun 18 2003 - 12:09:38 CDT
