Re: Re: Oracle 8i or 9i ?

Les Ayudo,

                Install£ both of them and learn both of them.

Regards
zhu chao
msn:chao_ping_at_163.com
www.happyit.net
www.cnoug.org(China Oracle User Group)

• 2003-02-17 11:28:00 ,you wrote£º=======

>I'm going to go ahead w/ the Oracle 8i course. I spoke w/ the course
>instructor and he also advised me to take the 8i course because Oracle8i is
>what is out there. So my question is:
>
>Should I install Oracle 8i or 9i at home? What would u guys do? I would
>love to learn both.
>
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Sunday, February 16, 2003 5:23 AM
>
>
>> hello
>>
>> ... and offers more features like xml database, bulk query, can be set
>compatible to 8i, ...
>>
>> if you can choose take 9i. that's what we did.
>>
>> BUT: nothing is flawless. Be prepared for patches and "pitfalls" - even in
>9i rel 2.
>>
>> We run 9i and 8i on NT5 and Solaris 8 and 9 and linux. patches and
>pitfalls in the UNIX world are almost the same, little differences to the NT
>world.
>>
>>
>> Apologies for any typing mistakes I failed to notice.
>>
>>
>> Markus Reger
>>
>> Oracle Applications DBA
>> Webmaster
>> MBC
>>
>> University for Music and Performing Art
>> Vienna
>> >>> ddoralist_at_hotmail.com 02/16/03 06:05 AM >>>
>> If its just the basic's I think 9i is actually easier than the older
>> versions. For example using Undo Management instead of trying to learn the
>> use of Rollback segments. Of course with Oracle (like most vendors) you
>can
>> get bogged down when the kitchen sink has been tossed at you on the
>install
>> CD's. It can seem overwhelming.
>>
>>
>> >From: "Les Ayudo" <info_at_lesayudo.com>
>> >Reply-To: ORACLE-L_at_fatcity.com
>> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> >Subject: Re: Oracle 8i or 9i ?
>> >Date: Sat, 15 Feb 2003 17:33:39 -0800
>> >
>> >Is 9i a lot more difficult to learn than 8i? Can i use what I learned on
>8i
>> >on 9i?
>> >
>> >--pachanga
>> >----- Original Message -----
>> >To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>> >Sent: Saturday, February 15, 2003 2:43 PM
>> >
>> >
>> > > Les,
>> > >
>> > > Something to consider on which to choose is the market pentration for
>9i
>> > > implementations. I work for a large insurance company which has zero
>9i
>> > > implementations. In fact as far as I know the key system I work on
>will
>> > > probably be the first one (Oracle 7.3.4 -> 9i) going in Q3/Q4. Most
>of
>> >our
>> > > systems are 8 with some on 8i. Clients are funny in not wanting to
>part
>> >with
>> > > money to perform database upgrades. If they don't see any benefit from
>> >it.
>> > >
>> > > On that basis, you might want to consider at least learning something
>> >about
>> > > 8i as it would be very likely you would run into a client that is
>using
>> >it.
>> > > Though going the 8i classes then upgrading to 9i does feel like a lot
>of
>> > > work. Something I hate. :-)
>> > >
>> > > David Davis
>> > > Manulife Financial
>> > >
>> > >
>> > > >From: "Les Ayudo" <info_at_lesayudo.com>
>> > > >Reply-To: ORACLE-L_at_fatcity.com
>> > > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> > > >Subject: Re: Oracle 8i or 9i ?
>> > > >Date: Fri, 14 Feb 2003 15:53:46 -0800
>> > > >
>> > > >Thanks, that got me happy since I do have a couple years of windows
>> > > >experience ;)
>> > > >So now, i have 1 vote for oracle 8i and one for 9i. Any other
>> >opinions?
>> > > >----- Original Message -----
>> > > >To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>> > > >Sent: Friday, February 14, 2003 1:54 PM
>> > > >
>> > > >
>> > > > > Les - Oh you wanted the hard questions answered as well. Given
>that
>> >you
>> > > > > mentioned you were a MS sys admin, I'd say that would give you a
>leg
>> >up.
>> > > >A
>> > > > > lot of shops have combined DBA/Sys admins for MS. That might be
>your
>> > > >easiest
>> > > > > transition. I hate to say this, especially on this list, but you
>may
>> > > >want
>> > > >to
>> > > > > look at adding MS SQL certification just to give you more options,
>> >like
>> > > >the
>> > > > > target employer might have Oracle and MS SQL. Depending on your
>> >salary
>> > > > > demands, your chances of getting on as a newbie DBA are probably
>> >okay.
>> >A
>> > > >lot
>> > > > > depends on your networking ability, good resume, no criminal
>record
>> >that
>> > > >can
>> > > > > be easily traced ;-), good personal hygiene, charm in interviews,
>> > > > > persistence, and just plain luck.
>> > > > > The ecommerce side has had a real dose of reality in the last
>> >couple
>> > > >of
>> > > > > years, but is still there. Consider just getting some Oracle
>> >experience
>> > > >and
>> > > > > then moving over to ecommerce. Most companies still have some type
>> >of
>> > > > > ecommerce area. Otherwise, in your spare time, learn everything
>you
>> >can
>> > > > > about ecommerce from the marketing drivel down to HTML.
>> > > > > These are obviously not well-informed opinions, but worth every
>> >penny
>> > > >you
>> > > > > paid ;-)
>> > > > >
>> > > > > Dennis Williams
>> > > > > DBA, 40, 100 DBA
>> > > > > Lifetouch, Inc.
>> > > > > dwilliams_at_lifetouch.com
>> > > > >
>> > > > >
>> > > > > -----Original Message-----
>> > > > > Sent: Friday, February 14, 2003 3:19 PM
>> > > > > To: Multiple recipients of list ORACLE-L
>> > > > >
>> > > > >
>> > > > > Thanks for the replies guys, I really appreciate it. Can i get
>some
>> > > >input
>> > > > > on these 2 questions:
>> > > > >
>> > > > > What chances am I looking at to
>> > > > > > getting hired as a newbie DBA once I graduate?
>> > > > > >
>> > > > > > I want to get into the Ecommerce side of Oracle (connecting DBs
>to
>> > > > > > websites/portals?). Which certification/path should I be
>> > > > > > following? Thanks in advance!!
>> > > > >
>> > > > > THANKS, I'M STARTING TO LIKE THIS LIST ALREADY!!!!!
>> > > > >
>> > > > > ----- Original Message -----
>> > > > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>> > > > > Sent: Friday, February 14, 2003 12:35 PM
>> > > > >
>> > > > >
>> > > > > > Les - Here is an idea for you. Think up a trivial application
>for
>> >a
>> > > > > > database. Maybe your home albums or DVDs. Try to make it a
>little
>> > > > > > relational, like have an "artist" table. Force yourself to work
>> >with
>> > > >it.
>> > > > > At
>> > > > > > the right time I was secretary of a bowling league, so each year
>I
>> > > >rewrote
>> > > > > a
>> > > > > > league management program in a different language, whatever I
>> >needed
>> > > >to
>> > > > > > learn. I went through Oracle, COBOL, Perl, C, all in different
>> >years.
>> > > >The
>> > > > > > point is that by playing "user" you get a good feel for why the
>> >heck
>> > > > > > somebody would use a database to begin with.
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > > Dennis Williams
>> > > > > > DBA, 40, 100 DBA
>> > > > > > Lifetouch, Inc.
>> > > > > > dwilliams_at_lifetouch.com
>> > > > > >
>> > > > > > -----Original Message-----
>> > > > > > Sent: Friday, February 14, 2003 2:00 PM
>> > > > > > To: Multiple recipients of list ORACLE-L
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > > I'm more of a windoz SA and have been working with a little Unix
>> >here
>> > > >&
>> > > > > > there for hte past 2yrs.... (RH, Mandrake, Solaris). What I
>> >really
>> > > >want
>> > > > > to
>> > > > > > accomplish is to switch to Unix and Databases. My goal is to
>use
>> >my
>> > > > > > certifcation as a way to get my foot in the door of the DB world
>> >and
>> > > >after
>> > > > > a
>> > > > > > couple of years, do some consulting. I downloaded oracle 9i for
>> > > >Solaris
>> > > > > and
>> > > > > > have yet to install it because I wanted to read up on Oracle
>1st.
>> > > >Will
>> > > > > > install it this weekend ;)
>> > > > > >
>> > > > > > I want to work with DBs because I think it's always going to be
>> >about
>> > > > > > managing information and the need is never going to die. I
>don't
>> >know
>> > > >of
>> > > > > > any midsize companies who would survive w/o some type of DB and
>> >after
>> > > > > being
>> > > > > > laid off twice, I'm reconsidering going into a different IT
>> >career.
>> > > > > >
>> > > > > > ----- Original Message -----
>> > > > > > To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list
>> > > >ORACLE-L
>> > > > > > Sent: Friday, February 14, 2003 8:34 AM
>> > > > > >
>> > > > > >
>> > > > > > The $3000 is true if he takes them through 'oracle' university
>but
>> >not
>> > > >if
>> > > > > > the local community college offers the classes.
>> > > > > >
>> > > > > > What I did (and it seemed to work fine) for my 8i certification
>is
>> >to
>> > > >go
>> > > > > to
>> > > > > > the community college bookstore and just buy the 'official'
>> >manuals
>> > > >and
>> > > > > > never signed up for the classes. I was lucky enough to already
>> >have
>> >a
>> > > >jr
>> > > > > > dba position so I was getting the real-world experience and I
>had
>> >a
>> > > >fairly
>> > > > > > decent idea of how oracle worked at a very basic level.
>(although
>> >I
>> > > >will
>> > > > > > say that my confidence in what I know has dropped dramatically
>in
>> >the
>> > > >last
>> > > > > > several months since I joined this list and began reading book's
>> >such
>> > > >as
>> > > > > > steve adams' 'oracle internals' and jonathan lewis's 'oracle 8i
>> > > >building
>> > > > > > efficient databases'...which has spawned an enormous interest in
>> > > > > continuing
>> > > > > > to improve my knowledge of all things oracle)
>> > > > > >
>> > > > > > What really, really erks me is the fact that these
>certifications
>> >have
>> > > > > been
>> > > > > > cheapened by people who relay specific test questions and even
>> >entire
>> > > > > exams
>> > > > > > over the internet. People should be in it for the
>knowledge....not
>> > > >just
>> > > >to
>> > > > > > get that certificate. I'd be scared sh#tless if I found a job
>> >where
>> >I
>> > > > > > pretended to be a dba and justified it by my certification only
>to
>> >be
>> > > > > given
>> > > > > > actual dba responsibilities. ...i'd rather work at a coffee
>shop
>> >and
>> > > >not
>> > > > > > have to deal with the stress (but that's just me)
>> > > > > >
>> > > > > > Anyways, I'm rambling now.
>> > > > > >
>> > > > > > Chris
>> > > > > >
>> > > > > > Oh yeah....a BIG OL THANKS to the pros on this list that put up
>> >with
>> > > > > > questions from people like me! Your knowledge is GREATLY
>> >appreciated.
>> > > > > >
>> > > > > > Have a good one.
>> > > > > >
>> > > > > > -----Original Message-----
>> > > > > > Sent: Friday, February 14, 2003 9:49 AM
>> > > > > > To: Multiple recipients of list ORACLE-L
>> > > > > >
>> > > > > > 9i will cost you more in the long run because you have to take 4
>> >exams
>> > > > > > at $150 each plus a $3000 course to get OCP.
>> > > > > >
>> > > > > > 8i then upgrade to 9i will cost you less but requires you to
>take
>> >up
>> > > > > > to 6 exams at $150 each but no more $3000 course.
>> > > > > >
>> > > > > > --
>> > > > > > Lyndon Tiu
>> > > > > >
>> > > > > >
>> > > > > > Quoting Les Ayudo <info_at_lesayudo.com>:
>> > > > > >
>> > > > > > > Hello,
>> > > > > > >
>> > > > > > > I'm thinking of going to school to get Oracle certified.
>There
>> >are
>> > > > > > > 2 schools in my area that are offering Oracle certs but one
>> >offers
>> > > > > > > Oracle 8i courses w/ an upgrade to 9i, while the other offers
>> >all
>> > > > > > > 9i courses. If i go to the schools who offers 9i courses,
>would
>> >I
>> > > > > > > miss out on valuable 8i knowledge? Which school should I
>> >attend?
>> > > > > > > The courses will last about 7 or 8 months. Also, is this a
>good
>> > > > > > > "in demand" field to get into? What chances am I looking at
>to
>> > > > > > > getting hired as a newbie DBA once I graduate?
>> > > > > > >
>> > > > > > > I want to get into the Ecommerce side of Oracle (connecting
>DBs
>> >to
>> > > > > > > websites/portals?). Which certification/path should I be
>> > > > > > > following? Thanks in advance!!
>> > > > > > >
>> > > > > >
>> > > > > >
>> > > > > > --
>> > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > > > > > <http://www.orafaq.net>
>> > > > > > --
>> > > > > > Author: Lyndon Tiu
>> > > > > > INET: ltiu_at_alumni.sfu.ca
>> > > > > >
>> > > > > > Fat City Network Services -- 858-538-5051
>> >http://www.fatcity.com
>> > > > > > <http://www.fatcity.com>
>> > > > > > San Diego, California -- Mailing list and web hosting
>> >services
>> > > > >
>> > > ---------------------------------------------------------------------
>> > > > > > To REMOVE yourself from this mailing list, send an E-Mail
>message
>> > > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
>> >in
>> > > > > > the message BODY, include a line containing: UNSUB ORACLE-L
>> > > > > > (or the name of mailing list you want to be removed from). You
>> >may
>> > > > > > also send the HELP command for other information (like
>> >subscribing).
>> > > > > >
>> > > > > > --
>> > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > > > > > --
>> > > > > > Author: DENNIS WILLIAMS
>> > > > > > INET: DWILLIAMS_at_LIFETOUCH.COM
>> > > > > >
>> > > > > > Fat City Network Services -- 858-538-5051
>> >http://www.fatcity.com
>> > > > > > San Diego, California -- Mailing list and web hosting
>> >services
>> > > > >
>> > > ---------------------------------------------------------------------
>> > > > > > To REMOVE yourself from this mailing list, send an E-Mail
>message
>> > > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
>> >in
>> > > > > > the message BODY, include a line containing: UNSUB ORACLE-L
>> > > > > > (or the name of mailing list you want to be removed from). You
>> >may
>> > > > > > also send the HELP command for other information (like
>> >subscribing).
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > >
>> > > > > --
>> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > > > > --
>> > > > > Author: Les Ayudo
>> > > > > INET: info_at_lesayudo.com
>> > > > >
>> > > > > Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>> > > > > San Diego, California -- Mailing list and web hosting
>> >services
>> > > > >
>> >---------------------------------------------------------------------
>> > > > > To REMOVE yourself from this mailing list, send an E-Mail message
>> > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
>in
>> > > > > the message BODY, include a line containing: UNSUB ORACLE-L
>> > > > > (or the name of mailing list you want to be removed from). You
>may
>> > > > > also send the HELP command for other information (like
>subscribing).
>> > > > > --
>> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > > > > --
>> > > > > Author: DENNIS WILLIAMS
>> > > > > INET: DWILLIAMS_at_LIFETOUCH.COM
>> > > > >
>> > > > > Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>> > > > > San Diego, California -- Mailing list and web hosting
>> >services
>> > > > >
>> >---------------------------------------------------------------------
>> > > > > To REMOVE yourself from this mailing list, send an E-Mail message
>> > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
>in
>> > > > > the message BODY, include a line containing: UNSUB ORACLE-L
>> > > > > (or the name of mailing list you want to be removed from). You
>may
>> > > > > also send the HELP command for other information (like
>subscribing).
>> > > > >
>> > > > >
>> > > > >
>> > > >
>> > > >--
>> > > >Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > > >--
>> > > >Author: Les Ayudo
>> > > > INET: info_at_lesayudo.com
>> > > >
>> > > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> > > >San Diego, California -- Mailing list and web hosting services
>> > > >---------------------------------------------------------------------
>> > > >To REMOVE yourself from this mailing list, send an E-Mail message
>> > > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> > > >the message BODY, include a line containing: UNSUB ORACLE-L
>> > > >(or the name of mailing list you want to be removed from). You may
>> > > >also send the HELP command for other information (like subscribing).
>> > >
>> > >
>> > > _________________________________________________________________
>> > > MSN 8 with e-mail virus protection service: 2 months FREE*
>> > > http://join.msn.com/?page=features/virus
>> > >
>> > > --
>> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > > --
>> > > Author: david davis
>> > > INET: ddoralist_at_hotmail.com
>> > >
>> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> > > San Diego, California -- Mailing list and web hosting services
>> > > ---------------------------------------------------------------------
>> > > To REMOVE yourself from this mailing list, send an E-Mail message
>> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> > > the message BODY, include a line containing: UNSUB ORACLE-L
>> > > (or the name of mailing list you want to be removed from). You may
>> > > also send the HELP command for other information (like subscribing).
>> > >
>> > >
>> > >
>> >
>> >--
>> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> >--
>> >Author: Les Ayudo
>> > INET: info_at_lesayudo.com
>> >
>> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> >San Diego, California -- Mailing list and web hosting services
>> >---------------------------------------------------------------------
>> >To REMOVE yourself from this mailing list, send an E-Mail message
>> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> >the message BODY, include a line containing: UNSUB ORACLE-L
>> >(or the name of mailing list you want to be removed from). You may
>> >also send the HELP command for other information (like subscribing).
>>
>>
>> _________________________________________________________________
>> Add photos to your messages with MSN 8. Get 2 months FREE*.
>> http://join.msn.com/?page=features/featuredemail
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: david davis
>> INET: ddoralist_at_hotmail.com
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Markus Reger
>> INET: reger_at_mdw.ac.at
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>>
>>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Les Ayudo
> INET: info_at_lesayudo.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

• = = = = = = = = = = = = = = = = = = =

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  INET: chao_ping_at_vip.163.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).