Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: unable to create data dictionary views
Sybrand Bakker wrote:
>
> You are, AFAIK, the first to have problems with this.
Not so - there has been discussion here lately.
> There's nothing more to it than just run them,
If all works well. However it doesn't always.
If you are _really_ not getting any output from catalog.sql - I'd try dropping all the objects that it creates before trying to re-run the script. After re-running, try re-compiling all invalid objects again _without_ re-running the script again.
HTH.
> a step by step tutorial would
> contain only
> in svrmgr connected as internal (which is equivalent to SYS) you should
> issue a spool command (spool <anyfile>) to capture errors
> and run nothing else than
> catalog.sql
> and
> catproc.sql
>
> As you only state 'it doesn't work' without any specific error, no one will
> be capable of resolving this. Catalog.sql providing no or little output is
> normal
>
> Just some clues from your attached created database command
>
> 50K for online redolog is *way* too low, the default is 200 or 500k, however
> 5M each is more appropiate.
> With 50k redologs you will run into 'checkpoint not complete' situations
> immediately and as the database is in archivelog (which it shouldn't for
> this operation) the process probably will just hang, archiving is not
> automatically started. Create the database in noarchivelog and switch to
> archivelog later.
>
> Hth,
>
Received on Tue May 30 2000 - 00:00:00 CDT