Re: Just Installed But Now Shrugging

The Oracle Documentation is indispensable, but it is not really organized step-by-step for the beginner. Do read the Concepts guide. It will give you part of the foundation (terminology and concepts) you'll need to understand the rest of the manuals.

"Oracle: the Complete Reference" Koch and Loney is a good text... Reference, yes. Complete, not quite. It does cover the basics.

I'd have to say that you're on the right track. Getting Oracle software installed, an instance started and a database created shows the kind of self-initiative needed to become a proficient DBA. Keep at it.

I'd suggest you keep an annotated log of all of the SQL statements that you run... why you ran which statements, and what worked and what didn't. There is absolutely no substitute for the experience you are gaining.

As for mount points and file system layouts, there are two fundamental reasons for using multiple disk drives, file systems and mount points: recoverability (the ability to "recover" the database in the event of a failure) and improved performance (effectively distributing i/o across the available controllers and disks.)

a few suggestions:

for "normal" work, do NOT use the SYS userid... only use SYS for running the /rdbms/admin scripts that require these to be run as SYS.

change the default tablespace for users other than SYS to something other than SYSTEM (e.g. USERS or TOOLS) do not create user objects in the SYSTEM tablespace.

here are a few more statements to get you started:

CREATE USER mallen1
IDENTIFIED BY secret1
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP; GRANT CONNECT TO mallen;
GRANT RESOURCE TO mallen;
REVOKE UNLIMITED TABLESPACE from mallen; ALTER USER mallen QUOTA unlimited ON USERS;

CREATE USER mallen2
IDENTIFIED BY secret2
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP; GRANT CREATE SESSION TO mallen2;
GRANT ALTER SESSION TO mallen2;
GRANT CREATE SYNONYM TO mallen2;

CONNECT mallen1/secret1
CREATE TABLE mytable (mycol VARCHAR2(5)); CREATE VIEW myview AS
SELECT mycol FROM mytable;

GRANT SELECT,INSERT,UPDATE,DELETE ON myview TO mallen2;

CONNECT mallen2/secret2

INSERT INTO mallen1.myview (mycol) VALUES ('test1'); COMMIT;
SELECT * FROM mallen1.myview;

keep at it! this oracle stuff is not easy... but it's not impossible either!

HTH "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
>
Received on Sat Jun 23 2001 - 10:42:29 CDT