FAQ
Guys,

I have this new request to accomplish this and I haven't done this =
before. Would I need to setup oracle internet directory to active =
service directory? If the user is using client-server tools and is not =
going through 9ias - can I do this just through Net9?

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

Search Discussions

  • Grant Allen at Aug 24, 2004 at 6:14 pm
    Yes, you can just do it through the sqlnet layer.

    You'll need

    In client sqlnet.ora files

    SQLNET.AUTHENTICATION_SERVICES=3D (NTS)

    Other authent options can follow NTS, just make sure it's first in the =
    parentheses.

    In instance configuration (spfile or init.ora)

    Either

    OS_AUTHENT_PREFIX =3D ""

    Place whatever value you wish to prefix the usernames between the =
    quotes. Leave the quotes empty for a null prefix. This will allow =
    "loose" external validation, where any matching user name will be =
    allowed access (i.e. allows spoofing by LOCALMACHINE\username of =
    DOMAIN\username accounts).

    Or

    OSAUTH_PREFIX_DOMAIN =3D true

    When used in conjunction with 'CREATE USER "DOMAIN\username" identified =
    externally' will enforce "strict" external validation (i.e. avoids the =
    spoofing problem of the first method).

    Ciao
    Fuzzy
    :-)

    "Everything you think, do, and say
    was in the pill you took today."

    Zager and Evans
    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of
    Paula_Stankus_at_doh.state.fl.us
    Sent: Wednesday, 25 August 2004 05:33
    To: oracle-l_at_freelists.org
    Subject: RE: authenticate from Windows network account to=20
    backend Oracle
    database
    =20
    =20
    Guys,
    =20
    I have this new request to accomplish this and I haven't done this =3D
    before. Would I need to setup oracle internet directory to active =3D
    service directory? If the user is using client-server tools=20
    and is not =3D
    going through 9ias - can I do this just through Net9?
    =20
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    =20
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • DENNIS WILLIAMS at Aug 26, 2004 at 11:39 am
    Paula - Since I don't see where anyone responded to your email, I'll take a
    swing at it just based on personal observations, not experience:

    By Windows network account I assume you mean MS Active Directory.
    I understand Oracle client can be configured to use MS AD to validate
    users. However specific information is required in a format Oracle is
    expecting.
    Normally Oracle expects to use OID (Oracle Internet Directory). This is
    an LDAP-compliant authentication service. Since MS AD has an LDAP interface,
    in theory it is possible to replicate user information from OID to MS AD. In
    other words, use OID to maintain your userids and transfer that information
    to MS AD periodically. If anyone has accomplished this feat, please post!

    Prior discussions on this topic are available in the archives by searching
    on keywords such as LDAP, Novell, OID.

    Dennis Williams
    DBA

    Lifetouch, Inc.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Paula_Stankus_at_doh.state.fl.us
    Sent: Tuesday, August 24, 2004 2:33 PM
    To: oracle-l_at_freelists.org
    Subject: RE: authenticate from Windows network account to backend Oracle
    database

    Guys,

    I have this new request to accomplish this and I haven't done this =
    before. Would I need to setup oracle internet directory to active =
    service directory? If the user is using client-server tools and is not =
    going through 9ias - can I do this just through Net9?

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org

    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Mkb at Aug 26, 2004 at 3:07 pm
    Didn't see the earliet post. I'm just in the middle
    of trying to do something like this. It's in a very
    experimental stage at the moment but the goal is to
    eventually have Oracle users in OID only and have two
    directories: one AD and the other OID, and just as
    Dennis mentioned, to replicate user account info
    between the two so that they are synched up.

    One of my first goals right now is to get things
    configured such that I can login into SQL*Plus using
    an account that I have created in OID only i.e. the
    account exists in the OID directory but not in the
    database itself.

    Don't know how far I'll get, but right now, I'm having
    a bear of a problem just getting OID to accept SSL
    connections.

    I've been reading through all the documentaion and
    looking over the Metalink notes. The documentation
    points in a lot of different directions so you end
    going through many pages that refer back to some other
    doc and so on.

    Anyway, every time I seem to make progress, I end up
    hitting another problem some place.

    I've been able to setup my own certificate signing
    authority and seem to have most of the pieces in
    place. The only problem...the pieces don't seem to
    communicate over SSL.

    Hopefuly, by the time I'm done, I can post a write up,
    but don't hold your breath too long.

    --
    mohammed

    --- DENNIS WILLIAMS wrote:
    Paula - Since I don't see where anyone responded to
    your email, I'll take a
    swing at it just based on personal observations, not
    experience:

    1. By Windows network account I assume you mean MS
    Active Directory.
    2. I understand Oracle client can be configured to
    use MS AD to validate
    users. However specific information is required in a
    format Oracle is
    expecting.
    3. Normally Oracle expects to use OID (Oracle
    Internet Directory). This is
    an LDAP-compliant authentication service. Since MS
    AD has an LDAP interface,
    in theory it is possible to replicate user
    information from OID to MS AD. In
    other words, use OID to maintain your userids and
    transfer that information
    to MS AD periodically. If anyone has accomplished
    this feat, please post!

    Prior discussions on this topic are available in the
    archives by searching
    on keywords such as LDAP, Novell, OID.

    Dennis Williams
    DBA
    Lifetouch, Inc.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org

    On Behalf Of Paula_Stankus_at_doh.state.fl.us
    Sent: Tuesday, August 24, 2004 2:33 PM
    To: oracle-l_at_freelists.org
    Subject: RE: authenticate from Windows network
    account to backend Oracle
    database

    Guys,

    I have this new request to accomplish this and I
    haven't done this =
    before. Would I need to setup oracle internet
    directory to active =
    service directory? If the user is using
    client-server tools and is not =
    going through 9ias - can I do this just through
    Net9?
    __________________________________
    Do you Yahoo!?
    Read only the mail you want - Yahoo! Mail SpamGuard.
    http://promotions.yahoo.com/new_mail
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • McBain, Neil SITI-ITISEEEE at Aug 27, 2004 at 2:11 am
    I have not accomplished the feat, but we are rolling out OID here and I =
    was told by Oracle that to use Single Sign On with OID communicating =
    with Active Directory you need to use OID 9.0.4 minimum (part of 10g AS =
    9.0.4). I guess that is not to say that you could write your own =
    synchronisation LDAP interface that replicated AD to OID and vice versa =
    (not something I would consider fun !). We are only going to use OID as =
    a tnsnames.ora replacement just now as Oracle were unable to inform us =
    of one customer who was using Single Sign On through OID to AD, but we =
    have gone with OID 9.0.4 so that this is technically possible in the =
    future, although I can just see the finger pointing now when OID and AD =
    do not quite communicate the way they are meant to.

    Cheers,
    Neil.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
  • Thalis Kalfigopoulos at Aug 27, 2004 at 7:12 am
    Hi all,

    I'm looking for some advice on purchasing an Oracle book. To give you a short description:
    - I'm quite a new user (almost a month old which probably makes me something more than an embryo I
    guess)
    - Just finished Oreilly's "Oracle essentials" (3rd ed.)

    Testing on a 9.2

    I have a CS and DB background, no Oracle though. Oreilly's title has left me mostly satisfied (as
    have most of their titles). The concepts where mostly familiar. Now that I have more or less gotten
    lightly & slightly acquainted with the slang, notions, processes, ideas, acronyms etc. I'm looking
    for something more technical and DBA oriented.

    Please advise on book titles, esp. if you've read more than a couple of books on Oracle.

    TIA

    ps. I also have Oracle's "Oracle 9i Database Administration Fundamentals", both I and II.

    Thalis Kalfigopoulos
    IT Department
    Alumil S.A.
    E-mail: t.kalfigopoulos_at_alumil.com

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Cary Millsap at Aug 27, 2004 at 11:57 am
    Thalis,

    If your job description includes any responsibilities to optimize the
    performance of your system, then I really hope that Part I (Chapters 1
    through 4) of Jeff's and my book called Optimizing Oracle Performance is
    part of a good answer to your question.

    These chapters are completely non-technical (and shouldn't take you more
    than a couple hours to read), but--if we've done our job well--they set =
    your
    mind in the right direction for the task of improving system =
    performance.

    Cary Millsap
    Hotsos Enterprises, Ltd.
    http://www.hotsos.com
    * Nullius in verba *

    Upcoming events:
    - Performance Diagnosis 101: 9/14 San Francisco, 10/5 Charlotte, 10/26
    Toronto
    - SQL Optimization 101: 8/16 Minneapolis, 9/20 Hartford, 10/18 New =
    Orleans
    - Hotsos Symposium 2005: March 6-10 Dallas

    Visit www.hotsos.com for schedule details...

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org =

    On Behalf Of Thalis Kalfigopoulos
    Sent: Friday, August 27, 2004 6:42 AM
    To: oracle-l_at_freelists.org
    Subject: Books to suggest

    Hi all,

    I'm looking for some advice on purchasing an Oracle book. To give
    you a short description:
    - I'm quite a new user (almost a month old which probably makes me =
    something
    more than an embryo I
    guess)
    - Just finished Oreilly's "Oracle essentials" (3rd ed.)

    Testing on a 9.2

    I have a CS and DB background, no Oracle though. Oreilly's title has =
    left me
    mostly satisfied (as
    have most of their titles). The concepts where mostly familiar. Now that =
    I
    have more or less gotten
    lightly & slightly acquainted with the slang, notions, processes, ideas,
    acronyms etc. I'm looking
    for something more technical and DBA oriented.

    Please advise on book titles, esp. if you've read more than a couple of
    books on Oracle.

    TIA

    ps. I also have Oracle's "Oracle 9i Database Administration =
    Fundamentals",
    both I and II.

    Thalis Kalfigopoulos
    IT Department
    Alumil S.A.
    E-mail: t.kalfigopoulos_at_alumil.com

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Yechiel Adar at Aug 30, 2004 at 11:26 am
    I am also starting to try the AD OID connection with OID 9.0.4 based on
    Oracle promises. I would like to be notifies when you succeed in doing this.
    I will also post my findings to the list.

    Yechiel Adar
    Mehish
    ----- Original Message -----
    From: "McBain, Neil SITI-ITISEEEE"
    To:
    Sent: Friday, August 27, 2004 9:07 AM
    Subject: RE: authenticate from Windows network account to backend Oracle
    database
    I have not accomplished the feat, but we are rolling out OID here and I =
    was told by Oracle that to use Single Sign On with OID communicating =
    with Active Directory you need to use OID 9.0.4 minimum (part of 10g AS =
    9.0.4). I guess that is not to say that you could write your own =
    synchronisation LDAP interface that replicated AD to OID and vice versa =
    (not something I would consider fun !). We are only going to use OID as =
    a tnsnames.ora replacement just now as Oracle were unable to inform us =
    of one customer who was using Single Sign On through OID to AD, but we =
    have gone with OID 9.0.4 so that this is technically possible in the =
    future, although I can just see the finger pointing now when OID and AD =
    do not quite communicate the way they are meant to.

    Cheers,
    Neil.
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Chris Stephens at Aug 27, 2004 at 7:51 am
    Thalis,

    I think standard recommendation is to check out the concepts and admin
    guide as well as the Oracle docs for any other topic you may be
    interested in. Both are free and really lay a good foundation.

    After that the heavy hitters are expert one-on-one, effective oracle by
    design, oracle internals, optimizing oracle performance, oracle
    performance tuning, rman backup and recovery, oracle design, oracle sql
    high-performance tuning, practical oracle 8i. =20

    in addition, i highly recommend sql tuning from tow. I've just read
    through it once and it's really good. It's not specific to oracle but
    it has already contributed immeasurably to my understanding of sql. I
    wish something like this had been available a few years ago. I've spent
    the last 3 years as a dba and have always known that my true
    effectiveness was severely limited by my novice ability to tune
    sql....easily the most high-impact area from a performance perspective
    on most systems. ...it looks like it will take quite a bit of practice
    to become fluent but i'm confident that it is time well spent.

    Good luck!=20
    The fun never stops!
    chris

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Thalis Kalfigopoulos
    Sent: Friday, August 27, 2004 6:42 AM
    To: oracle-l_at_freelists.org
    Subject: Books to suggest

    Hi all,

    I'm looking for some advice on purchasing an Oracle book. To
    give you a short description:
    - I'm quite a new user (almost a month old which probably makes me
    something more than an embryo I
    guess)
    - Just finished Oreilly's "Oracle essentials" (3rd ed.)
    - Testing on a 9.2

    I have a CS and DB background, no Oracle though. Oreilly's title has
    left me mostly satisfied (as
    have most of their titles). The concepts where mostly familiar. Now that
    I have more or less gotten
    lightly & slightly acquainted with the slang, notions, processes, ideas,
    acronyms etc. I'm looking
    for something more technical and DBA oriented.

    Please advise on book titles, esp. if you've read more than a couple of
    books on Oracle.

    TIA

    ps. I also have Oracle's "Oracle 9i Database Administration
    Fundamentals", both I and II.

    Thalis Kalfigopoulos
    IT Department
    Alumil S.A.
    E-mail: t.kalfigopoulos_at_alumil.com

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org

    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Ryan_gaffuri_at_comcast.net at Aug 27, 2004 at 8:08 am
    save your money. go here (dont have the link to the 10g docs handy...)
    http://www.oracle.com/pls/db92/db92.homepage
    read the 'concepts' document. skip the stuff on java. oracle has very good. free documentation. downside is you have to read it online... i think you can buy it from them to get it in book form.
    If you really want to buy a book, try out 'Beginning Oracle Programming'. Skip the PL/SQL chapters, they aren't that good. Best chapters in the book are chapters 5-8.
    OCP books are not very good for learning Oracle. The free docs are much better.
    -------------- Original message --------------
    Hi all,
    I'm looking for some advice on purchasing an Oracle book. To give you a
    short description:
    - I'm quite a new user (almost a month old which probably makes me something
    more than an embryo I
    guess)
    - Just finished Oreilly's "Oracle essentials" (3rd ed.)
    - Testing on a 9.2
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Jo_holvoet_at_amis.com at Aug 27, 2004 at 8:57 am
    Why would you have to read online ?
    Choose the PDF and let Acrobat Reader save a local copy for printing.

    mvg/regards

    Jo

    ryan_gaffuri_at_comcast.net
    Sent by: oracle-l-bounce_at_freelists.org
    08/27/2004 14:47
    Please respond to oracle-l



    To: oracle-l_at_freelists.org
    cc:
    Subject: Re: Books to suggest

    save your money. go here (dont have the link to the 10g docs handy...)
    http://www.oracle.com/pls/db92/db92.homepage
    read the 'concepts' document. skip the stuff on java. oracle has very
    good. free documentation. downside is you have to read it online... i
    think you can buy it from them to get it in book form.
    If you really want to buy a book, try out 'Beginning Oracle Programming'.
    Skip the PL/SQL chapters, they aren't that good. Best chapters in the book
    are chapters 5-8.
    OCP books are not very good for learning Oracle. The free docs are much
    better.
    -------------- Original message --------------
    Hi all,
    I'm looking for some advice on purchasing an Oracle book. To give you a
    short description:
    - I'm quite a new user (almost a month old which probably makes me something
    more than an embryo I
    guess)
    - Just finished Oreilly's "Oracle essentials" (3rd ed.)
    - Testing on a 9.2
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Ryan_gaffuri_at_comcast.net at Aug 27, 2004 at 9:06 am
    the only book in that list that a beginner can follow easily is Practical 8i. The rest are more advanced and not good for starting off. Don't even touch internals books for a while... too much info for a beginner.
    the key to helping a new person is identify what is vitally important to learn first. Don't give too much information or people will not be able to retain it. People who have done something for a while forget how hard it is to get started in a new skill set. Everything is new.
    I watch the food channel alot when I diet(if i can't eat it, Iwant to watch other people eat it). I see Emeril Lagasse go 'bang, bang' and it comes out great. I make it and it tastes like crap.
    -------------- Original message --------------
    Thalis,

    I think standard recommendation is to check out the concepts and admin
    guide as well as the Oracle docs for any other topic you may be
    interested in. Both are free and really lay a good foundation.

    After that the heavy hitters are expert one-on-one, effective oracle by
    design, oracle internals, optimizing oracle performance, oracle
    performance tuning, rman backup and recovery, oracle design, oracle sql
    high-performance tuning, practical oracle 8i. =20
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • April Wells at Aug 27, 2004 at 10:05 am
    Beginner's books that will carry you through till you aren't a beginner
    anymore?

    easy...

    Oracle DBA 101
    by Marlene Theriault, Marlene L. Theriault, Rachel Carmichael
    Paperback: 563 pages
    Publisher: McGraw-Hill Companies; 1st edition (January 15, 2000)
    ISBN: 0072121203

    Oracle9i DBA 101
    by Marlene Theriault, Rachel Carmichael, James Viscusi
    Paperback: 500 pages
    Publisher: McGraw-Hill Osborne Media; 1 edition (June 25, 2002)
    ISBN: 0072224746

    April Wells
    Oracle DBA/Oracle Apps DBA
    Corporate Systems
    Amarillo Texas

    You will recognize your own path when you come upon it, because you will
    suddenly have all the energy and imagination you will ever need.
    ~ Jerry Gillies ~

    The information contained in this communication,
    including attachments, is strictly confidential
    and for the intended use of the addressee only;
    it may also contain proprietary, price sensitive,
    or legally privileged information. Notice is hereby
    given that any disclosure, distribution, dissemination,
    use, or copying of the information by anyone other
    than the intended recipient is strictly prohibited
    and may be illegal. If you have received this communication
    in error, please notify the sender immediately by
    reply e-mail, delete this communication, and destroy
    all copies.

    Corporate Systems, Inc. has taken reasonable precautions
    to ensure that any attachment to this e-mail has been
    swept for viruses. We specifically disclaim all liability
    and will accept no responsibility for damage sustained
    as a result of software viruses and advise you to carry
    out your own virus checks before opening any attachment.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
  • Gogala, Mladen at Aug 27, 2004 at 11:24 am
    April, you forgot to mention the collected works of Larry Wall, Tom
    Christiansen, Randall Schwartz and Damian Conway, published in so called
    "camel series". That should anybody busy for a while. I know that Jared,
    Cary and Rich Jesse have read them.

    --
    Mladen Gogala
    A & E TV Network
    Ext. 1216
    -----Original Message-----
    From: April Wells
    Sent: Friday, August 27, 2004 10:20 AM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: Books to suggest


    Beginner's books that will carry you through till you aren't
    a beginner anymore?

    easy...

    Oracle DBA 101
    by Marlene Theriault, Marlene L. Theriault, Rachel Carmichael
    Paperback: 563 pages
    Publisher: McGraw-Hill Companies; 1st edition (January 15, 2000)
    ISBN: 0072121203
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Bill thater at Aug 27, 2004 at 11:37 am

    Beginner's books that will carry you through till you aren't a beginner
    anymore?
    um... you haven't yet seen my copies of said books.;-) well used, notes in the margins [i still wish there were wider margins, and yes my Goddess i know why there aren't;-)] highlited. and still used.

    but then maybe i'm still a beginner.;-)

    --
    Bill "Shrek" Thater ORACLE DBA
    shrek_at_consulant.com
    "I'm going to work my ticket if I can..." -- Gilwell song

    ------------------------------------------------------------------------
    I am my beloved's, and my beloved is mine (Song of
    Solomon 6:3)

    --
    ___________________________________________________________
    Sign-up for Ads Free at Mail.com
    http://promo.mail.com/adsfreejump.htm

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • April Wells at Aug 27, 2004 at 12:54 pm
    Didn't mention a lot that I have and use very frequently... but the 101 is
    what I was given early on and the one that is absconded with most often off
    of my shelf, and what I have seen on the bookshelf of others who are very
    new to learning...

    April Wells
    Oracle DBA/Oracle Apps DBA
    Corporate Systems
    Amarillo Texas

    You will recognize your own path when you come upon it, because you will
    suddenly have all the energy and imagination you will ever need.
    ~ Jerry Gillies ~

    -----Original Message-----
    From: Gogala, Mladen
    Sent: Friday, August 27, 2004 10:12 AM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: Books to suggest

    April, you forgot to mention the collected works of Larry Wall, Tom
    Christiansen, Randall Schwartz and Damian Conway, published in so called
    "camel series". That should anybody busy for a while. I know that Jared,
    Cary and Rich Jesse have read them.

    --
    Mladen Gogala
    A & E TV Network
    Ext. 1216
    -----Original Message-----
    From: April Wells
    Sent: Friday, August 27, 2004 10:20 AM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: Books to suggest


    Beginner's books that will carry you through till you aren't
    a beginner anymore?

    easy...

    Oracle DBA 101
    by Marlene Theriault, Marlene L. Theriault, Rachel Carmichael
    Paperback: 563 pages
    Publisher: McGraw-Hill Companies; 1st edition (January 15, 2000)
    ISBN: 0072121203
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    The information contained in this communication,
    including attachments, is strictly confidential
    and for the intended use of the addressee only;
    it may also contain proprietary, price sensitive,
    or legally privileged information. Notice is hereby
    given that any disclosure, distribution, dissemination,
    use, or copying of the information by anyone other
    than the intended recipient is strictly prohibited
    and may be illegal. If you have received this communication
    in error, please notify the sender immediately by
    reply e-mail, delete this communication, and destroy
    all copies.

    Corporate Systems, Inc. has taken reasonable precautions
    to ensure that any attachment to this e-mail has been
    swept for viruses. We specifically disclaim all liability
    and will accept no responsibility for damage sustained
    as a result of software viruses and advise you to carry
    out your own virus checks before opening any attachment.

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mark W. Farnham at Aug 27, 2004 at 4:13 pm
    search list for "boos" (yep, the whole thread had no "k") in the June 28 to
    July 7 is timeframe for dang near comprehensive thread about the pros and
    cons of various Oracle boos.

    mwf

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of April Wells
    Sent: Friday, August 27, 2004 12:44 PM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: Books to suggest

    Didn't mention a lot that I have and use very frequently... but the 101 is
    what I was given early on and the one that is absconded with most often off
    of my shelf, and what I have seen on the bookshelf of others who are very
    new to learning...

    April Wells
    Oracle DBA/Oracle Apps DBA
    Corporate Systems
    Amarillo Texas

    You will recognize your own path when you come upon it, because you will
    suddenly have all the energy and imagination you will ever need.
    ~ Jerry Gillies ~

    -----Original Message-----
    From: Gogala, Mladen
    Sent: Friday, August 27, 2004 10:12 AM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: Books to suggest

    April, you forgot to mention the collected works of Larry Wall, Tom
    Christiansen, Randall Schwartz and Damian Conway, published in so called
    "camel series". That should anybody busy for a while. I know that Jared,
    Cary and Rich Jesse have read them.

    --
    Mladen Gogala
    A & E TV Network
    Ext. 1216
    -----Original Message-----
    From: April Wells
    Sent: Friday, August 27, 2004 10:20 AM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: Books to suggest


    Beginner's books that will carry you through till you aren't
    a beginner anymore?

    easy...

    Oracle DBA 101
    by Marlene Theriault, Marlene L. Theriault, Rachel Carmichael
    Paperback: 563 pages
    Publisher: McGraw-Hill Companies; 1st edition (January 15, 2000)
    ISBN: 0072121203
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    The information contained in this communication,
    including attachments, is strictly confidential
    and for the intended use of the addressee only;
    it may also contain proprietary, price sensitive,
    or legally privileged information. Notice is hereby
    given that any disclosure, distribution, dissemination,
    use, or copying of the information by anyone other
    than the intended recipient is strictly prohibited
    and may be illegal. If you have received this communication
    in error, please notify the sender immediately by
    reply e-mail, delete this communication, and destroy
    all copies.

    Corporate Systems, Inc. has taken reasonable precautions
    to ensure that any attachment to this e-mail has been
    swept for viruses. We specifically disclaim all liability
    and will accept no responsibility for damage sustained
    as a result of software viruses and advise you to carry
    out your own virus checks before opening any attachment.

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Niall Litchfield at Aug 31, 2004 at 2:57 am

    On Fri, 27 Aug 2004 11:44:22 -0500, April Wells wrote:
    Didn't mention a lot that I have and use very frequently... but the 101 is
    what I was given early on and the one that is absconded with most often off
    of my shelf,
    Now that is an interesting test - the books that are stolen test. I
    buy a *lot* of books - but most of them are novels so not entirely
    relevant here - but of the Oracle related books that I have, the ones
    I keep having to go looking for are Jonathan's Practical Oracle 8i,
    Steve Fuerstein's PL/SQL book and Christopher Lawson's The Art and
    Science of Oracle Performance Tuning.

    Millsap, Kyte and Tow remain sadly un-stolen.

    --
    Niall Litchfield
    Oracle DBA
    http://www.niall.litchfield.dial.pipex.com
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Carel-Jan Engel at Aug 31, 2004 at 3:03 am
    My Scaling 8i got stolen. I bought a new one, long before James put it
    on his site
    Best regards,

    Carel-Jan Engel

    ===
    If you think education is expensive, try ignorance. (Derek Bok)
    ===
    On Tue, 2004-08-31 at 10:02, Niall Litchfield wrote:

    Now that is an interesting test - the books that are stolen test. I
    buy a *lot* of books - but most of them are novels so not entirely
    relevant here - but of the Oracle related books that I have, the ones
    I keep having to go looking for are Jonathan's Practical Oracle 8i,
    Steve Fuerstein's PL/SQL book and Christopher Lawson's The Art and
    Science of Oracle Performance Tuning.
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Thalis Kalfigopoulos at Aug 31, 2004 at 5:50 am

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org On Behalf Of
    Niall Litchfield
    Sent: Tuesday, August 31, 2004 11:02 AM
    To: oracle-l_at_freelists.org
    Subject: Re: Books to suggest

    I keep having to go looking for are Jonathan's Practical Oracle 8i,
    Steve Fuerstein's PL/SQL book and Christopher Lawson's The Art and
    Science of Oracle Performance Tuning.

    --
    Niall Litchfield
    Oracle DBA
    http://www.niall.litchfield.dial.pipex.com
    Apparently Jonathan's "Practical Oracle 8i" is a pretty highly appreciated/respected/used book. On
    the other hand I am a bit worried about going for such an oudated[?] Oracle version even though I
    assume from the book's Contents that it talks about a lot of Oracle's internals/basics, which
    obviously haven't changed that dramatically even in 10g. Is my assumption safe or should I be
    worried about the "8i" in the title?

    TIA

    Thalis Kalfigopoulos
    IT Department
    Alumil S.A.
    E-mail: t.kalfigopoulos_at_alumil.com

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Carel-Jan Engel at Aug 31, 2004 at 5:59 am
    No Worries.
    Jonathan has a patch available for his book, to upgrade it to the latest
    Oracle version. The patch just replaces the 8i part of the picture with
    the original background. I saw this at Hotsos 2004. Publishers think
    they can boost sales by printing the latest version number on the cover.
    It's a pity that on the long term good books suffer from this policy.
    James even made his book free available in PDF on his website.

    Best regards,

    Carel-Jan Engel

    ===
    If you think education is expensive, try ignorance. (Derek Bok)
    ===
    On Tue, 2004-08-31 at 12:57, Thalis Kalfigopoulos wrote:

    Apparently Jonathan's "Practical Oracle 8i" is a pretty highly appreciated/respected/used book. On
    the other hand I am a bit worried about going for such an oudated[?] Oracle version even though I
    assume from the book's Contents that it talks about a lot of Oracle's internals/basics, which
    obviously haven't changed that dramatically even in 10g. Is my assumption safe or should I be
    worried about the "8i" in the title?

    TIA
    >

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Jonathan Gennick at Aug 31, 2004 at 7:18 am
    Tuesday, August 31, 2004, 7:07:41 AM, Carel-Jan Engel (cjpengel.dbalert_at_xs4all.nl) wrote:
    CJE> Publishers think
    CJE> they can boost sales by printing the latest version number on the cover.

    Ideally, IMHO, it's best to avoid listing any sort of
    version number on the cover of a book. However, if you do
    list a version number, it'd better be current. An old
    version number is the kiss of death. That may be
    unfortunate, but it really is true.

    Old copyright dates hurt also. People do look at those,
    apparently. Even when a book is still perfectly applicable,
    sales will drop as the book ages. It's not unusual for
    publishers to revise a book solely for the purpose of
    generating a more recent copyright date, because a newer
    date will generally boost sales.

    Best regards,

    Jonathan Gennick --- Brighten the corner where you are
    http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

    Join the Oracle-article list and receive one
    article on Oracle technologies per month by
    email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article,
    or send email to Oracle-article-request_at_gennick.com and
    include the word "subscribe" in either the subject or body.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
  • Niall Litchfield at Aug 31, 2004 at 6:45 am

    On Tue, 31 Aug 2004 13:57:38 +0300, Thalis Kalfigopoulos wrote:
    Apparently Jonathan's "Practical Oracle 8i" is a pretty highly appreciated/respected/used book. On
    the other hand I am a bit worried about going for such an oudated[?] Oracle version even though I
    assume from the book's Contents that it talks about a lot of Oracle's internals/basics, which
    obviously haven't changed that dramatically even in 10g. Is my assumption safe or should I be
    worried about the "8i" in the title?
    From the preface
    "My strategy for tackling problems is the same regardless of the
    version of Oracle with which I am working, so when you read this book
    you don't really have to worry about which version of Oracle you are
    using. "

    I have to say that I think if I were recommending a book to start with
    - especially for someone who is new to Oracle but not to the field in
    general - I'd go for Expert One on One Oracle from Tom Kyte.

    I haven't read DBA 101 (sorry Rachel) but that ought to be a pretty
    good foundation type book as well.

    --
    Niall Litchfield
    Oracle DBA
    http://www.niall.litchfield.dial.pipex.com
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Rachel Carmichael at Aug 31, 2004 at 7:28 am
    What? You mean to tell me you haven't bought a copy so I could get that
    $0.0001 in royalties?

    Seriously, we did try to make DBA 101 as basic as we could. And in
    general, we tried to make it version UNspecific. We did note where
    things were different between versions. Based on comments from readers
    of the first version, we did about a 60% rewrite of the 9i version --
    not to include the "cool" 9i stuff but to make concepts clearer. It's
    hard to include all the new stuff, while keeping the important old
    stuff, when you don't get an increased page count.

    Publishers feel, rightly or wrongly, however that the buying public
    wants the latest version number on the cover of the book.... So
    Jonathan's book, version unspecific that it is, loses because of that
    silly "8i" on the cover.

    Niall Litchfield wrote:
    On Tue, 31 Aug 2004 13:57:38 +0300, Thalis Kalfigopoulos
    wrote:
    Apparently Jonathan's "Practical Oracle 8i" is a pretty highly
    appreciated/respected/used book. On
    the other hand I am a bit worried about going for such an
    oudated[?] Oracle version even though I
    assume from the book's Contents that it talks about a lot of
    Oracle's internals/basics, which
    obviously haven't changed that dramatically even in 10g. Is my
    assumption safe or should I be
    worried about the "8i" in the title?
    From the preface

    "My strategy for tackling problems is the same regardless of the
    version of Oracle with which I am working, so when you read this book
    you don't really have to worry about which version of Oracle you are
    using. "

    I have to say that I think if I were recommending a book to start
    with
    - especially for someone who is new to Oracle but not to the field in
    general - I'd go for Expert One on One Oracle from Tom Kyte.

    I haven't read DBA 101 (sorry Rachel) but that ought to be a pretty
    good foundation type book as well.

    --
    Niall Litchfield
    Oracle DBA
    http://www.niall.litchfield.dial.pipex.com
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Niall Litchfield at Aug 31, 2004 at 8:09 am

    On Tue, 31 Aug 2004 05:33:19 -0700 (PDT), Rachel Carmichael wrote:
    What? You mean to tell me you haven't bought a copy so I could get that
    $0.0001 in royalties?
    Absolutely not - its written in American after all and I don't do
    foreign languages....
    Seriously, we did try to make DBA 101 as basic as we could. And in
    general, we tried to make it version UNspecific. We did note where
    things were different between versions. Based on comments from readers
    of the first version, we did about a 60% rewrite of the 9i version --
    not to include the "cool" 9i stuff but to make concepts clearer. It's
    hard to include all the new stuff, while keeping the important old
    stuff, when you don't get an increased page count.
    I do think that versions are important for some types of book, and DBA
    101 would be exactly one of those. I'm not for example a great fan of
    the 'self-managing database' tag line from our favourite software
    supplier, but management tasks for 10g are significantly different
    than those for 6.0.36 (where I started). Actually they are probably
    quite changed from 8i as well.

    Performance management is far less changed - do as little as possible
    as infrequently as possible would be a good adage here. - by version
    numbers. The same applies to good development practice and good
    design.
    Publishers feel, rightly or wrongly, however that the buying public
    wants the latest version number on the cover of the book.... So
    Jonathan's book, version unspecific that it is, loses because of that
    silly "8i" on the cover.
    I suspect that publishers are correct - anyone here interested in a
    7.3.4 book? Mogens obviously needs to write a v5 book but I suspect
    self-publishing is the way to go for that one. I also have some
    sympathy. If I ask in an online forum "how do I avoid fragmentation?"
    I'll get a bunch of response saying it isn't an issue if I'll only run
    with ULMTs, a bunch of responses asking why I think I have a
    fragmentation problem and a bunch of responses asking me to state the
    Oracle version *because it is relevant to my question*. All of these
    are sensible responses for a specific question - they also ought to be
    relevant for a book.

    I also agree with Jonathan's statement in his preface as an approach
    to Oracle Management, but still think the book is, to a lesser degree
    than most but still not insignificantly, version dependent (meaning
    not it is irrelevant for 9i/10g but that it is of less use for v8.0
    and below).

    --
    Niall Litchfield
    Oracle DBA
    http://www.niall.litchfield.dial.pipex.com
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mark W. Farnham at Aug 31, 2004 at 9:40 am
    Manual update method:

    Find a pen or marker that reasonably matches the book's cover background.

    Make light markings such that the "8" is obscured.

    Find a pen or marker of the correct shade and width to hand inscribe the
    typeface used for the "i".

    After the "i" write out "ntelligence."

    You have successfully improved the relationship of the book's title to the
    book's true contents.

    "Regards,"

    Mark W. Farnham

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Niall Litchfield
    Sent: Tuesday, August 31, 2004 7:50 AM
    To: oracle-l_at_freelists.org
    Subject: Re: Books to suggest

    On Tue, 31 Aug 2004 13:57:38 +0300, Thalis Kalfigopoulos
    wrote:
    Apparently Jonathan's "Practical Oracle 8i" is a pretty highly
    appreciated/respected/used book. On
    the other hand I am a bit worried about going for such an oudated[?]
    Oracle version even though I
    assume from the book's Contents that it talks about a lot of Oracle's
    internals/basics, which
    obviously haven't changed that dramatically even in 10g. Is my assumption
    safe or should I be
    worried about the "8i" in the title?
    From the preface
    "My strategy for tackling problems is the same regardless of the
    version of Oracle with which I am working, so when you read this book
    you don't really have to worry about which version of Oracle you are
    using. "

    I have to say that I think if I were recommending a book to start with
    - especially for someone who is new to Oracle but not to the field in
    general - I'd go for Expert One on One Oracle from Tom Kyte.

    I haven't read DBA 101 (sorry Rachel) but that ought to be a pretty
    good foundation type book as well.

    --
    Niall Litchfield
    Oracle DBA
    http://www.niall.litchfield.dial.pipex.com
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Paula_Stankus_at_doh.state.fl.us at Aug 27, 2004 at 2:22 pm
    Any good DBA will need to know PL/SQL - Steven Feuerstein with Bill =
    Pribyl

    Any good DBA is familiar with backups/recoveries - Oracle 9i RMAN Backup =
    and Recovery is good resource from Oracle Press.

    Any a metalink account for quick references - bugs, issues, scripts. =
    Not as in-depth and "all in one convenient" place as the books but a =
    good operational resource.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Cary Millsap
    Sent: Friday, August 27, 2004 11:31 AM
    To: oracle-l_at_freelists.org
    Subject: RE: Books to suggest

    Thalis,

    If your job description includes any responsibilities to optimize the
    performance of your system, then I really hope that Part I (Chapters 1
    through 4) of Jeff's and my book called Optimizing Oracle Performance is
    part of a good answer to your question.

    These chapters are completely non-technical (and shouldn't take you more
    than a couple hours to read), but--if we've done our job well--they set =
    =3D
    your
    mind in the right direction for the task of improving system =3D
    performance.

    Cary Millsap
    Hotsos Enterprises, Ltd.
    http://www.hotsos.com
    * Nullius in verba *

    Upcoming events:
    - Performance Diagnosis 101: 9/14 San Francisco, 10/5 Charlotte, 10/26
    Toronto
    - SQL Optimization 101: 8/16 Minneapolis, 9/20 Hartford, 10/18 New =3D
    Orleans
    - Hotsos Symposium 2005: March 6-10 Dallas

    Visit www.hotsos.com for schedule details...

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org =3D

    On Behalf Of Thalis Kalfigopoulos
    Sent: Friday, August 27, 2004 6:42 AM
    To: oracle-l_at_freelists.org
    Subject: Books to suggest

    Hi all,

    I'm looking for some advice on purchasing an Oracle book. To give
    you a short description:
    - I'm quite a new user (almost a month old which probably makes me =3D
    something
    more than an embryo I
    guess)
    - Just finished Oreilly's "Oracle essentials" (3rd ed.)

    Testing on a 9.2

    I have a CS and DB background, no Oracle though. Oreilly's title has =3D
    left me
    mostly satisfied (as
    have most of their titles). The concepts where mostly familiar. Now that =
    =3D
    I
    have more or less gotten
    lightly & slightly acquainted with the slang, notions, processes, ideas,
    acronyms etc. I'm looking
    for something more technical and DBA oriented.

    Please advise on book titles, esp. if you've read more than a couple of
    books on Oracle.

    TIA

    ps. I also have Oracle's "Oracle 9i Database Administration =3D
    Fundamentals",
    both I and II.

    Thalis Kalfigopoulos
    IT Department
    Alumil S.A.
    E-mail: t.kalfigopoulos_at_alumil.com

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    BEGIN-ANTISPAM-VOTING-LINKS
    ------------------------------------------------------
    Teach CanIt if this mail (ID 8444693) is spam:
    Spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D8444693&m=3D2cc13=
    98c68dc
    Not spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D8444693&m=3D2cc13=
    98c68dc
    Forget vote: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D8444693&m=3D2cc13=
    98c68dc
    ------------------------------------------------------
    END-ANTISPAM-VOTING-LINKS

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Ron Thomas at Aug 27, 2004 at 4:08 pm
    Also...

    Any good DBA will know shell scripting (The Korn Shell, Olczak), regex (Mastering Regular
    Expressions, Friedl), and perl (I'll let Jared fill in here).
    Thanks,
    Ron.

    "To really screw up Linux you have to work at it...To really screw up Windows, you have to work ON
    it."
    "The software said to install Windows 98 or better... So I installed linux."
    "Windows - How do you want to be exploited today?"

    Paula_Stankus_at_doh.state.fl.
    us
    Sent by: To
    oracle-l-bounce_at_freelists.o oracle-l_at_freelists.org
    rg cc

    Subject
    08/27/04 10:59 AM RE: Books to suggest

    Please respond to
    oracle-l_at_freelists.org

    Any good DBA will need to know PL/SQL - Steven Feuerstein with Bill =
    Pribyl

    Any good DBA is familiar with backups/recoveries - Oracle 9i RMAN Backup =
    and Recovery is good resource from Oracle Press.

    Any a metalink account for quick references - bugs, issues, scripts. =
    Not as in-depth and "all in one convenient" place as the books but a =
    good operational resource.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Cary Millsap
    Sent: Friday, August 27, 2004 11:31 AM
    To: oracle-l_at_freelists.org
    Subject: RE: Books to suggest

    Thalis,

    If your job description includes any responsibilities to optimize the
    performance of your system, then I really hope that Part I (Chapters 1
    through 4) of Jeff's and my book called Optimizing Oracle Performance is
    part of a good answer to your question.

    These chapters are completely non-technical (and shouldn't take you more
    than a couple hours to read), but--if we've done our job well--they set =
    =3D
    your
    mind in the right direction for the task of improving system =3D
    performance.

    Cary Millsap
    Hotsos Enterprises, Ltd.
    http://www.hotsos.com
    * Nullius in verba *

    Upcoming events:
    - Performance Diagnosis 101: 9/14 San Francisco, 10/5 Charlotte, 10/26
    Toronto
    - SQL Optimization 101: 8/16 Minneapolis, 9/20 Hartford, 10/18 New =3D
    Orleans
    - Hotsos Symposium 2005: March 6-10 Dallas
    - Visit www.hotsos.com for schedule details...

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org =3D

    On Behalf Of Thalis Kalfigopoulos
    Sent: Friday, August 27, 2004 6:42 AM
    To: oracle-l_at_freelists.org
    Subject: Books to suggest

    Hi all,

    I'm looking for some advice on purchasing an Oracle book. To give
    you a short description:
    - I'm quite a new user (almost a month old which probably makes me =3D
    something
    more than an embryo I
    guess)
    - Just finished Oreilly's "Oracle essentials" (3rd ed.)
    - Testing on a 9.2

    I have a CS and DB background, no Oracle though. Oreilly's title has =3D
    left me
    mostly satisfied (as
    have most of their titles). The concepts where mostly familiar. Now that =
    =3D
    I
    have more or less gotten
    lightly & slightly acquainted with the slang, notions, processes, ideas,
    acronyms etc. I'm looking
    for something more technical and DBA oriented.

    Please advise on book titles, esp. if you've read more than a couple of
    books on Oracle.

    TIA

    ps. I also have Oracle's "Oracle 9i Database Administration =3D
    Fundamentals",
    both I and II.

    Thalis Kalfigopoulos
    IT Department
    Alumil S.A.
    E-mail: t.kalfigopoulos_at_alumil.com

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    BEGIN-ANTISPAM-VOTING-LINKS
    ------------------------------------------------------
    Teach CanIt if this mail (ID 8444693) is spam:
    Spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D8444693&m=3D2cc13=
    98c68dc
    Not spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D8444693&m=3D2cc13=
    98c68dc
    Forget vote: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D8444693&m=3D2cc13=
    98c68dc
    ------------------------------------------------------
    END-ANTISPAM-VOTING-LINKS

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Ryan_gaffuri_at_comcast.net at Aug 31, 2004 at 8:10 am
    Thalis,
    You asked a simple question on what is a good book to get started and you got overwhelmed with suggestions from people saying you need to learn this and learn that. Those suggestions are overkill. Takes time to pick all that up. It sounds like to me that you got thrown into a position and need to get stuff done.
    You really don't need to go buy alot of books to do this. Anything with 'internals' in it should be totally avoided for a while. Not important at first.
    Here is the link to the 9.2 documentation. I dont have the 10g link handy, but you don't need it to learn the basics.
    http://www.oracle.com/pls/db92/db92.homepage
    The most important parts here are:
    SQL Reference: Has lots of examples. Everyone has syntax problems when they learn something new. You will use this alot. This is better than any SQL syntax book on the market.
    Concepts Document:
    http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/toc.htm
    Skim this. Look at the table of contents and get the big picture. Ignore the details. You won't retain it anyway. This will give you a good idea of what is going on. Its really too much information to focus on the details at first anyway. Don't worry about it. Just look at the big picture.
    After that read the application developers fundamentals. Skim it. Totally skip the stuff on java and xml unless you are using it. Too much information.
    Read Chapters
    2-5, 7-9,10-12,15
    Skip the rest.
    I also recommend doing this for about 10 minutes a day.
    select view_name
    from dba_views
    Start by looking for the 'table' views such as
    select view_name
    from dba_views
    where view_name like '%TAB%'
    and do describes and selects on them. Then go here and get an idea of what they mean. Don't memorize. Just play around. When you get curious do a google search for more info on something and ask questions here. This is really the best exercise I have found to learn about how the database works. Those views are the 'data dictionary' of the system.
    Use this documentation to learn them. Don't be overwhelmed. Just play around. Do that for 6 months 5 days a week for 10 minutes a day. You will be surprised what you know when you are done.
    http://www.oracle.com/pls/db92/db92.catalog_views?remark=homepage
    Don't go spending money on books. No need. No offense to any of the authors. I have read most of the books written by the people on this list and liked them.
    Thalis Kalfigopoulos
    IT Department
    Alumil S.A.
    E-mail: t.kalfigopoulos_at_alumil.com

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mark Pecaut at Aug 31, 2004 at 11:51 am

    On Tue, Aug 31, 2004 at 01:14:05PM +0000, ryan_gaffuri_at_comcast.net wrote:
    Thalis,
    Here is the link to the 9.2 documentation. I dont have the 10g link handy, but you don't need it to learn the basics. ...
    SQL Reference: Has lots of examples. Everyone has syntax problems when they learn something new. You will use this alot. This is better than any SQL syntax book on the market. ...
    Concepts Document:
    Don't go spending money on books. No need. No offense to any of the authors. I have read most of the books written by the people on this list and liked them.
    I agree with Ryan. The official Oracle documentation is good. When
    I was in the Peace Corps in Africa I had never used Oracle before and
    wanted to learn so I studied for the OCA exams by simply reading the
    SQL Reference and the Concepts (and skimming a few others..). I had
    the 1000+ page document printed on two reams of paper 'cause I couldn't
    afford... Well.. I'm getting off topic, but let's just say I'm still
    a beginner but my limited experience shows that the official
    documentation is quite good.

    -Mark

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

Related Discussions

People

Translate

site design / logo © 2022 Grokbase