Re: unable to create data dictionary views

You are, AFAIK, the first to have problems with this. There's nothing more to it than just run them, 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,

Sybrand Bakker, Oracle DBA

Peter Schupp <Peter.Schupp_at_object-it.de> schreef in berichtnieuws 39257B48.F41432D_at_object-it.de...
> Hi,
> although I got the right hint from this group I'm still not able to
> create my dictionary views. Can somebody help me please:
> - @dbmsstdx.sql seems to work alright (I connect as user SYS)
> - @catalog.sql starts but doesn't say anything more, I have to
> kill the processes - CTRL-C, CTRL-D doesn't work)
> the same with @catproc.sql and
> @catproc.sql.
> What's missing? is there something about the sizes of my rollback
> segments or datafiles? Do I have to bring some speacial files
> explicitely online? Does anybody know a step by step tutorial for this?
>
> I create my database this way:
> create database VIS1
> logfile group 1 ('oit1log11.log', 'oit1log12.log') size
> 50K,
> group 2 ('oit1log21.log', 'oit1log22.log') size
> 50K
> datafile 'oit1_00.dbf' size
> 10M
> maxlogfiles 5
> maxloghistory 100
> maxdatafiles 10
> maxinstances 2
> archivelog
> ;
>
> I also created some more rollback segments and another tablespace and
> some more logfiles.
> and they are vieable by using
> select member from sys.v$logfile;
> select name from sys.v$datafile;
> select name from sys.v$controlfile;
>
> Thanks for any help
>
> _______________________________________________________________________
>
> mailto:Peter.Schupp_at_object-it.de
>
> STZ object-IT
> Postfach 10 43 62
> D-70038 Stuttgart
>
> PGP Key available at: http://wwwkeys.de.pgp.net
> _______________________________________________________________________
>
>
>
>
Received on Fri May 19 2000 - 00:00:00 CDT