Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Career Advice

RE: Career Advice

From: Odland, Brad <Brad.Odland_at_qtiworld.com>
Date: Wed, 17 Dec 2003 12:14:27 -0800
Message-ID: <F001.005DA31F.20031217121427@fatcity.com>












If you need specifics for a home learning environment setting up Oracle 8.1.7.4 on a Gentoo linux box at home is a great learning exersize. (I've yet to do the Gentoo thing, RedHat right now)
 
(You need at least two computers at home...List how many computers do you have at home.....be honest...even the dead ones...)
 
And to do so without useing the Database configuration assistant. Then go through upgrades to 9.2.0.4
 
Set up some locally managed tablespaces, enable archive logging, write some hotbackup and coldbackup scripts, alter datafiles, make new ones, load some bogus data, do exports, imports. Drop table and recover them from exports, break the database, recover from backups....set up procedures for adding new users of pretend application. Create roles for developers, users and analysts...write a PL/SQL program to generate gobs of fake test data. Hotbackups everynight, nightly processing jobs, trunc tables and move data around....
 
Fiddle with connection manager, OMS, OEM, the agent and Oracle Names. Run various DBA tools TOAD, dbVisualizer do some connections with JDBC and setup apache with PHP and write a few goofy pages to query the data dictionary and format output to your browser. Convert OraHoo0.5 from Oracle function to OCI functions (that's a fun exercise)
 
All of that is free and downloadable with plenty of documentation. That experience alone will do a ton for you and keep you busy at home for months. pretty much all of the network, OS and database skills are covered. And you can say you've been exposed to performing these tasks and if you put all your scripts your write on a cd you can take it with you for a long time. We all have our pile o'scripts we take with from place to place.
 
Have fun!
 
Brad O.
 
-----Original Message-----
From: Saira Somani-Mendelin [mailto:saira_somani@yahoo.com]
Sent: Wednesday, December 17, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Career Advice

Is it that difficult though? Just to get familiar with it… if you’ve worked with other similar software before?

 

I guess you’d be looking at a lot of theory, and not nearly enough practice. But then, how do I get obtain these more attractive, marketable skills? I must start somewhere, no?

 

Thanks,

Saira

 

-----Original Message-----
From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On Behalf Of eric king
Sent: December 17, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Career Advice

 

That right, packaged software like SAP and PeopleSoftware should be learned in the real implementation or real usage case. By simply getting the software and use it yourself, it is very difficult to even grasp the basic idea about those business transactions.

----- Original Message -----

From: Jared.Still@radisys.com

To: Multiple recipients of list ORACLE-L

Sent: Wednesday, December 17, 2003 1:09 PM

Subject: Re: Career Advice

 


Your enthusiasm is admirable, but I think that it would be extremely
difficult for you to learn any of these packages without actually being
in an environment where they are used.

It may be that Tecsys is a complex set of apps on the same level
as SAP or Oracle Apps, and if so, then maybe that background
would prepare you to tackle this on your own.

Either way, it will be difficult without access to official support, which
you won't have unless you're in a working environment that includes
the app you are attempting to learn.

You would also not have exposure to the people that are actually
using the stuff, which is pretty important for software that is directly
used by most of the user community, unlike a database.

HTH

Jared



 

"Saira Somani-Mendelin" <saira_somani@yahoo.com>
Sent by: ml-errors@fatcity.com

 12/17/2003 09:44 AM
 Please respond to ORACLE-L

       
        To:        Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
        cc:        
        Subject:        Career Advice




As an applications analyst/junior dba, I feel I need to learn more but
I'm not sure of the direction I should take, so I'm asking for advice.

Should I become interested in Oracle Apps? Or should I learn another
suite like SAP or Siebel or PeopleSoft? The difficulty is that my
company does not use any of these. We use a smaller package by Tecsys
called Elite and they don't have as many customers - or should I say, as
many customers with deep pockets.

I know I can get my hands on a working copy of SAP, what about the
others? I believe you can purchase an evaluation copy of Apps from the
Oracle Store. Has anyone actually tried to train themselves on any of
these products? Has anyone installed Apps at home for testing?

Sorry if this question has been presented on the list before.

Thanks,
Saira

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Saira Somani-Mendelin
 INET: saira_somani@yahoo.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@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: Odland, Brad
  INET: Brad.Odland_at_qtiworld.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).
Received on Wed Dec 17 2003 - 14:14:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US