|
Home > Archive > microsoft.public.cert.mcdba > November 2003 > any Oracle guys here
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
any Oracle guys here
|
|
|
| Howdy all. I was wondering how many of you MCDBA's have
also got Oracle experience. As it stands Im an MCDBA but
its
time for me to start learning something new. Now here's
the kicker. Im not really fond of programming. I came into
the
DBA world as a paper MCDBA and got lucky enough to be able
to keep my job. However Ive come to realize that
programming
(stored procs, not VB or anything) and me just dont mix. I
like it for a short time but then it makes me want to go
nuts.
I dont mind doing it here and there or even writing some
occasional vbs for dts. Ive been fortunate enough that I
dont
need to do it very often. Anyways, Im at the crossroad
between learning either more networking(MCSA) or some
Oracle(OCP).
So my question(finally) is are there any MCDBA's here that
also double as the Oracle guy? Do you have tons of
scripting
and programming to look forward to every day? Im already
familiar with db admin/ design concepts and certainly dont
want
to forget all about it. But am I doomed to a life of
coding as an Oracle guy? Ive looked through some jobs
posts for
Oracle dba's and they need to know some scripting. I guess
what Im curiuos about is can I get away without having to
spend most of my days writing stored procs? It seems from
looking @ job postings for SQL dba's that lots of stored
proc writing is the norm but not so much for the Oracle
guys. Is this correct?
TIA, Chris
| |
| Leigh Kendall 2003-11-07, 1:24 am |
| I do unfortunately, almost 90% Oracle currently. I much prefer SQL Server
though.
If you don't like coding, you're going to hate Oracle. Everything, and I
mean EVERYTHING is harder and more laborious in Oracle. Very script
intensive.
Given your comment, I'd say you're more apt to like doing Network Admin type
work. If you don't love to code, then go for the hardware stuff.
HTH,
--
Leigh Kendall MCSD, MCDBA
"chris" <anonymous@discussions.microsoft.com> wrote in message
news:00be01c3a49c$ffac4800$a60
1280a@phx.gbl...
> Howdy all. I was wondering how many of you MCDBA's have
> also got Oracle experience. As it stands Im an MCDBA but
> its
> time for me to start learning something new. Now here's
> the kicker. Im not really fond of programming. I came into
> the
> DBA world as a paper MCDBA and got lucky enough to be able
> to keep my job. However Ive come to realize that
> programming
> (stored procs, not VB or anything) and me just dont mix. I
> like it for a short time but then it makes me want to go
> nuts.
> I dont mind doing it here and there or even writing some
> occasional vbs for dts. Ive been fortunate enough that I
> dont
> need to do it very often. Anyways, Im at the crossroad
> between learning either more networking(MCSA) or some
> Oracle(OCP).
> So my question(finally) is are there any MCDBA's here that
> also double as the Oracle guy? Do you have tons of
> scripting
> and programming to look forward to every day? Im already
> familiar with db admin/ design concepts and certainly dont
> want
> to forget all about it. But am I doomed to a life of
> coding as an Oracle guy? Ive looked through some jobs
> posts for
> Oracle dba's and they need to know some scripting. I guess
> what Im curiuos about is can I get away without having to
> spend most of my days writing stored procs? It seems from
> looking @ job postings for SQL dba's that lots of stored
> proc writing is the norm but not so much for the Oracle
> guys. Is this correct?
>
> TIA, Chris
| |
| Mohammed Farouk 2003-11-07, 10:24 am |
| you said you came into dab as a paper mcdba and you are lucky that you are
keeping your current job ,can I know what your current job is , i am just
curious 
| |
| chris 2003-11-07, 11:24 am |
| Out of curiostiy, do you do lots of scripting, stored proc
writing, or both? Also I recently got a copy of Oracly 9i
and it has a GUI similar to EM that looked pretty good.
Cant that be used for most tasks?
>-----Original Message-----
>I do unfortunately, almost 90% Oracle currently. I much
prefer SQL Server
>though.
>
>If you don't like coding, you're going to hate Oracle.
Everything, and I
>mean EVERYTHING is harder and more laborious in Oracle.
Very script
>intensive.
>
>Given your comment, I'd say you're more apt to like doing
Network Admin type
>work. If you don't love to code, then go for the hardware
stuff.
>
>HTH,
>
>--
>Leigh Kendall MCSD, MCDBA
>
>"chris" <anonymous@discussions.microsoft.com> wrote in
message
> news:00be01c3a49c$ffac4800$a60
1280a@phx.gbl...
into[color=blue]
able[color=blue]
mix. I[color=blue]
that[color=blue]
dont[color=blue]
guess[color=blue]
to[color=blue]
from[color=blue]
>
>.
>
| |
| chris 2003-11-07, 12:24 pm |
| DBA stuff mostly.(95%) Replication, Log Shipping,
security, perf tuning, design. Some coding but not too
much.
>-----Original Message-----
>you said you came into dab as a paper mcdba and you are
lucky that you are
>keeping your current job ,can I know what your current
job is , i am just
>curious
>
>
>.
>
| |
| Leigh Kendall 2003-11-08, 8:24 pm |
| Right now, predominantly stored procedure development.
The Oracle EM sucks IMO. First off, you need to upgrade your workstation
just to run it, since it's Java. Second, it just sucks. Oh, did I already
mention that it sucks?
Programming against Oracle is fine, not really much different than SQL
Server; if you know one, it's a snap to pick up the other. DB Admin though
is worlds apart. Oracle, IMHO, has for years kept the DBA aspects of Oracle
very convoluted to keep up the image of it being difficult, which it is, and
to keep the consulting revenue flowing into their consulting divisions.
Just my $.02...
"chris" <anonymous@discussions.microsoft.com> wrote in message
news:06c201c3a54a$76ead410$a00
1280a@phx.gbl...[color=blue]
> Out of curiostiy, do you do lots of scripting, stored proc
> writing, or both? Also I recently got a copy of Oracly 9i
> and it has a GUI similar to EM that looked pretty good.
> Cant that be used for most tasks?
>
> prefer SQL Server
> Everything, and I
> Very script
> Network Admin type
> stuff.
> message
> into
> able
> mix. I
> that
> dont
> guess
> to
> from
| |
|
| I am coming from programming field and now studying myself with books in
MCDBA and also curious the nature of jobs of a DBA.
Chris, are you always use the Enterprise Manager to do the stuffs you
mentioned: replication, log shipping...?
"chris" <anonymous@discussions.microsoft.com> wrote in message
news:011601c3a54a$b300e890$a10
1280a@phx.gbl...[color=blue]
> DBA stuff mostly.(95%) Replication, Log Shipping,
> security, perf tuning, design. Some coding but not too
> much.
>
> lucky that you are
> job is , i am just
| |
| chris 2003-11-10, 11:24 am |
| I wrote my own Log Shipping.
>-----Original Message-----
>I am coming from programming field and now studying
myself with books in
>MCDBA and also curious the nature of jobs of a DBA.
>Chris, are you always use the Enterprise Manager to do
the stuffs you
>mentioned: replication, log shipping...?
>
>"chris" <anonymous@discussions.microsoft.com> wrote in
message
> news:011601c3a54a$b300e890$a10
1280a@phx.gbl...
>
>
>.
>
| |
| keyur shah 2003-11-10, 4:25 pm |
| That isnt absolutely correct.. It all depends whether you are a DBA
working as Database Developer or pure Administrator.
Most DBA usually land up in writing stored procs and managing them.
Keyur Shah
Verizon Communications
732-423-0745
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
|
| I've used Oracle from a programming point of view. - I hate the client
software!
Programming Oracle databases with VB.NET, for example is quite easy. The
Oracle data provider is very similar to the SQL server data provider. SQL
syntax is quite different. Although I prefer working with an SQL server, I
find the Oracle SQL syntax to be easier to use (Especially where multiple
table joins are concerned).
Most my programs are written to work with an SQL server (mostly because MS
Access databases seem to corrupt quite easily and I don't know the first
thing about UNIX!)
"keyur shah" <keyur@softwareklinic.com> wrote in message
news:uChoH38pDHA.372@TK2MSFTNGP11.phx.gbl...
> That isnt absolutely correct.. It all depends whether you are a DBA
> working as Database Developer or pure Administrator.
>
> Most DBA usually land up in writing stored procs and managing them.
>
>
>
> Keyur Shah
> Verizon Communications
> 732-423-0745
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
|
|
|
|
|