Re: Just Installed But Now Shrugging

"Michael B. Allen" <mballen_at_erols.com> wrote in message news:slrn9j8ink.aer.mballen_at_nano.foo.net...
> Daniel A. Morgan wrote:
> >For someone seemingly clue less you did a remarkably good job.
 Catproc.sql was the
> >right script to run.
>
> Or stupid luck ;-P
>
> Well, it's doesn't matter now; I didn't create public rollback segments. I
> have wiped clean and starting anew. I've walked into and tripped over
> *every* trap there is(which I think is a Good Thing since I'm just
> hacking) But I actually got to the point where I created a table!
>
> > Anything related to Oracle 6 is useless and most of 7 not
> >worth reading though much is similar.
>
> Actually the SQL 6 book has served well enough with groups.google.com
> supplimenting.
>
> >I strongly urge you to do
> >what you should have done in the first place. Read the installation
 instructions on
>
> I can't remember where I got the CD but it was a Red Hat promotional
> mailer or insert. It's got a REALLY crappy Java installer that chokes at
> every turn(at one point I was laughing out loud). The "Intallation Guide"
> wouldn't help me prime a campfire.
>
> >the CD and buy a good beginners DBA book and PL/SQL programming book.
>
> Is Teach Yourself PL/SQL In 21 Days so bad that I should go out and
> buy something else? I could probably dig up a coffee stained PL/SQL
> manual for Oracle 7, how's that? I found a recommendation for 'Oracle:
> The Complete Reference' by Koch and Loney. What do you recommend for
> Oracle DBA and PL/SQL texts?
>
> >This group can help you and provide support ... but it can not possibly
 get you
> >from where you are to where you need to be.
>
> Ok, well, one more question(it's a specific one this time):
>
> Regarding sql files to run after creating a new database, I know it's
> roughly:
>
> connect internal
> @$ORACLE_HOME/rdbms/admin/catalog.sql
> @$ORACLE_HOME/rdbms/admin/catproc.sql
> @$ORACLE_HOME/rdbms/admin/catdbsyn.sql
>
> connect system/change_on_install
> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
>
> What else and in what order?
>
> Thanks for your help,
> Mike

Catdbsyn should be obsolete, as there are now public synonyms.

I would not forget catexp.sql for internal in the rbms/admin dir (actually I run that usually immediately after catrproc) I would also open a spool file before starting any of those scripts. They will continue what ever happens.

I would also not forget utlxplan in the same directory. Can be run by anyone, usually I create one plan_table in the SYSTEM account and assign public synonyms and grants.

Then you need plstrce.sql from the sqlplus/admin directory to enable set autotrace in sql*plus.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Jun 23 2001 - 07:24:04 CDT