Re: Drowning in Oracle...{Extreme Newbie}

If you're looking for a 'crib sheet' on basic DBA procedures, there probably isn't one.
A number of the steps involved in creating a database in Oracle are non-intuitive.
If you have time constraints, the most economical and reasonable method is to get
some knowledgable Oracle DBA to write you a script.

There are several general steps I follow when creating an Oracle database

1. Set the system kernel parameters (necessary for SCO, automatic in AIX, NT and Solaris, haven't done it on HP-UX systems...yet)
2. Edit the ora<SID>.init file and set the appropriate parmeters
3. Run svrmgrl, connect internal, and create the system datafile, RBS datafile, rollback segments and all the other datafiles which hold the data.
4. Run the catalog, catproc and pupbld scripts
5. Setup tnsnames.ora and listener.ora
6. Start the SQL listener
7. Make sure ORACLE_HOME and ORACLE_SID are set

These seven steps assume a level of knowledge that takes some time to fully comprehend
without destroying an oracle instance.

To explain these terms any further involves a level of technical jargon that you will probably
not learn in a short time, unless it is all you do.

If you have a more specific question perhaps it can be answered.

Oracle has a CD-ROM which includes all of their manuals. This CD is ususally free if you have an Oracle License. You may be able to buy the CD.
Oracle manuals Average about $75 each.

Kelly R. Kerr wrote:

> Hey all!
>
> Can anyone tell me some good resources to find out the "basics" of
> Oracle 8. (Like how to create a db, how to enter data into that db, and
>
> how to manipulate the data once I have it entered?) I know these may
> seem like simple questions, but I have been trying to get through
> "Oracle8: A Beginner's Guide" as well as the "Oracle Documentation" and
>
> for some reason it is not sinking in.
>
> Basically what I am looking for is a step by step list of how to set up
> a db and then access it. (As usual time is not on my side.) Any help
> would be greatly appreciated.
>
> --
> Kelly R. Kerr
> Multi-Scribe
> "Out the 10Base-T, through the router, down the T1, over the
> leased-line, off the bridge, past the firewall... nothing but Net."
Received on Sun Jan 03 1999 - 00:00:00 CST