Re: Database not loading

From: <mastertivoli_at_my-deja.com>
Date: Tue, 06 Feb 2001 10:49:00 GMT
Message-ID: <95okqr$pp0$1@nnrp1.deja.com>

Here is the error log from Best/1:
Summary of Run:
-Running script c:\visdata\scripts\newdaily.b1a 2/5/01 8:18 AM ...

BEST/1 Automator : 3 error(s), 0 warning(s) BEST/1 Automator : Run script finished at 2/5/01 2:01 PM

Full Log:

Running script c:\visdata\scripts\newdaily.b1a 2/5/01 8:18 AM ...

Target Database : Running events for target database: BEST1_ON_BUSTER... Populate : Running Populate Event (2/5/01 8:18:29 AM) on BEST1_ON_BUSTER...

          Populate : Populate all values
          Populate : 0 Tandem Measurements input matching input files
were found
          Populate : 0 NetWare Measurements input matching input files
were found
          Populate : 0 OS/2 Measurements input matching input files were
found
          Populate : 2 DistSys Measurements input matching input files
were found
          Populate : Appending DistSys Measurements data from input
file: c:\visdata\incomm~1\203xall.vis... at 08:18:30
e->       Populate : Error( 543 ):  : Population of input file:

c:\visdata\incomm~1\203xall.vis incomplete. Record 98973, table USERS Database is full

Populate : Appending DistSys Measurements data from input file: c:\visdata\incomm~1\204xall.vis... at 13:41:17

          Populate : Stopping current run...
e->       Populate : Error( 549 ):  : Population of input file:

c:\visdata\incomm~1\204xall.vis incomplete. Record 6202, table CTRLD CANCEL message received
e-> Populate : Fatal Error( -8003 ): No input files were successfully populated.

Populate : Event list on BEST1_ON_BUSTER aborted at (2/5/01 2:01:06 PM).

BEST/1 Automator : 3 error(s), 0 warning(s) BEST/1 Automator : Run script finished at 2/5/01 2:01 PM Summary of Run:
-Running script c:\visdata\scripts\newdaily.b1a 2/5/01 2:40 PM ...

BEST/1 Automator : 3 error(s), 0 warning(s) BEST/1 Automator : Run script finished at 2/6/01 1:31 AM

Full Log:

Running script c:\visdata\scripts\newdaily.b1a 2/5/01 2:40 PM ...

Target Database : Running events for target database: BEST1_ON_BUSTER... Populate : Running Populate Event (2/5/01 2:40:33 PM) on BEST1_ON_BUSTER...
Populate : Loaded database library using description file: c:\best1\odbdescr.txt.

          Populate : Populate all values
          Populate : 0 Tandem Measurements input matching input files
were found
          Populate : 0 NetWare Measurements input matching input files
were found
          Populate : 0 OS/2 Measurements input matching input files were
found
          Populate : 2 DistSys Measurements input matching input files
were found
          Populate : Appending DistSys Measurements data from input
file: c:\visdata\incomm~1\203xall.vis... at 14:40:34
e->       Populate : Error( 501 ):  : Population of input file:

c:\visdata\incomm~1\203xall.vis incomplete. Record 98972, table USERS Cannot allocate memory

Populate : Appending DistSys Measurements data from input file: c:\visdata\incomm~1\204xall.vis... at 20:03:07 e-> Populate : Error( 501 ): : Population of input file: c:\visdata\incomm~1\204xall.vis incomplete. Record 98646, table USERS Cannot allocate memory

Populate : 0 VM Measurements input matching input files were found

Populate : 0 CICS Measurements input matching input files were found

Populate : 0 Informix Measurements input matching input files were found

Populate : 0 Oracle Measurements input matching input files were found

Populate : 0 AS/400 Predictions input matching input files were found

Populate : 0 SNA Measurements input matching input files were found

Populate : 0 AS/400 Measurements input matching input files were found

Populate : 0 DB2 Measurements input matching input files were found

Populate : 0 LAN Measurements input matching input files were found

Populate : 0 OpenVMS Predictions input matching input files were found

Populate : 0 Data Set Measurements input matching input files were found

Populate : 0 MVS Measurements input matching input files were found

Populate : 0 Sybase Measurements input matching input files were found

Populate : 0 OpenVMS Measurements input matching input files were found

Populate : 0 Windows NT Measurements input matching input files were found

Populate : 0 MVS/VM Predictions input matching input files were found

Populate : 0 DistSys Predictions input matching input files were found

Populate : 0 IMS Measurements input matching input files were found
e-> Populate : Fatal Error( -8003 ): No input files were successfully populated.

Populate : Event list on BEST1_ON_BUSTER aborted at (2/6/01 1:31:39 AM).

BEST/1 Automator : 3 error(s), 0 warning(s) BEST/1 Automator : Run script finished at 2/6/01 1:31 AM

In article <95mfdv$rnv$1_at_nnrp1.deja.com>, mastertivoli_at_my-deja.com wrote:
> The owner of the tablespace has a system privilege of Unlimited
> Tablespace.
>
> The tablespace itself:
> Inital Size 131072kb
> Next Size 65536kb
> Minimum Size 131072kb
> Increment Size by 50%
> Minimum Num 1
> Maximum Num Value 2147483645
>
> I have checked all the logfiles on the oracle server and I do not see
> any that containe any errors.
>
> We are trying something now and if it fails I will post the entire log
> (it is short) here.
>
> Louis
>
> In article <3a7e73f9$1_at_news.iprimus.com.au>,
> "Howard J. Rogers" <howardjr_at_www.com> wrote:
> > Good idea, Stephan -though he would have to have one monster of a
> > PCTINCREASE for it to want a next extent of over 80% of 3Gb!
> >
> > I wish the guy would include the EXACT error message text.
Transcriptions
> > don't wash, at the end of the day.
> >
> > Regards
> > HJR
> >
> > "Stephan Langer" <slanger_at_dixi-wc.de> wrote in message
> > news:3A7E7145.15FF7ED1_at_dixi-wc.de...
> > > hi,
> > >
> > > what are the tables pct_increase and next sizes? Can it be they
overflow
> > > (and are rolled back so you don't see it afterwards?)
> > >
> > > hth Stephan
> > >
> > > mastertivoli_at_my-deja.com schrieb:
> > >
> > > > I am not getting an oracle error. I am getting an error in
Best/1. The
> > > > error it is saying is the USERS table is full.
> > > >
> > > > When I check all the tables (including system tables) that even
have the
> > > > name user in it I do not find any table that is full. I checked
the
> > > > table space that best/1 is loading in to and it is about 20%
full
( out
> > > > of 3 gig). I also checked the system tables and they are not
even
> > > > close to being filled.
> > > >
> > > > My DBA and I are just scratching our heads on this one.
> > > >
> > > > Thanks,
> > > >
> > > > Louis
> > > >
> > > > "Van Messner" <vmessner_at_bestweb.net> wrote:
> > > > > What's the actual message you get - Oracle error number and
the
message
> > > > > text?
> > > > >
> > > > > <mastertivoli_at_my-deja.com> wrote in message
> > > > > news:95f56q$jhh$1_at_nnrp1.deja.com...
> > > > > > I have an oracle 8.1.6 data base on solaris 2.6 that is just
failing. I
> > > > > > try to load data in to it and the program doing the load
seems
to
run
> > > > > > for a little while then just dies saying the user table is
full.
> > > > > >
> > > > > > I have check to the best of my knowledge and my DBA has
check
and we
do
> > > > > > not see any table or table space that is full.
> > > > > >
> > > > > > We are not seeing any other messages good or bad to tell us
where to
> > > > > > look. Would any of you have any idea of what I could look
check.
> > > > > >
> > > > > > If it matters the program doing the load is Best/1 from BMC.
It is
> > > > > > using the oracle 8i client on NT4.0 sp6a to load the db on
solaris.
> > > > > >
> > > > > > Thanks,
> > > > > > Louis
> > > > > >
> > > > > >
> > > > > > Sent via Deja.com
> > > > > > http://www.deja.com/
> > > > >
> > > > >
> > > >
> > > > Sent via Deja.com
> > > > http://www.deja.com/
> > >
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Feb 06 2001 - 04:49:00 CST