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: WebDB Solaris Install Bug?

Re: WebDB Solaris Install Bug?

From: Bryan Baker <Bryan.E.Baker_at_nwd02.usace.army.mil>
Date: 2000/03/28
Message-ID: <8bqomu$3b0$1@goo.nwd.usace.army.mil>#1/1

I had a similar problem

The problem is caused by the fact the table WWV_SITEBUILDER_DDL$ reached its   maximum number of extents when installing WebDB. You can check this in file
  sbddl.log in directory <webdb_home>\orainst:

     ORA-01631: max # extents (121) reached in table WEBDB.WWV_SITEBUILDER_DDL$   You must drop the created site, truncate the table WWV_SITEBUILDER_DDL$,   and set a higher next extent parameter before reloading the data.   Once done, you will be able to recreate the site correctly.

  Bryan Baker

Jason Archambeau <jarchambeau_at_email.msn.com> wrote in message news:uAEUvMIk$GA.268_at_cpmsnbbsa02...
> I need a little help....
>
> I am an experinced Oralce DBA but this has me at a loss:
>
> Installation of WebDB 2.1 on Solaris 2.6 (Sparc Ultra 10 - 1 gig of Ram).
> Oracle 8.1.5
> Installation goes smooth and all questions answered correctly.
> WebDB accountname: WebDb (used for the DAD)
> Port: 9999
>
> At post install, when I try to connect to the http:myserver:9999/webdb, I
> get the challenge dialog, but the WebDB Listener gives me this error:
>
> ora-6564
> object webdb.home doesn't exist
> ora-6512
>
> Now I know what these errors mean, but I can't track the source. It seems
> that their should be a package or proc named home in the webdb schema.
 The
> fact that it doesnt' exist is throwing the call to the PL/SQL gateway off
> and this causes the main webdb page to screw up. I have installed this
> product on NT about 5 times and never get this problem. I checked the
 state
> of the webdb schema and it has 161 objects and all have status of "VALID"
>
> Is there a bug in the Solaris install scripts?
>
> Please help before i look for a bullet........
>
>
> Thanks
>
>
Received on Tue Mar 28 2000 - 00:00:00 CST

Original text of this message

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