Friday, August 24, 2007

Certifications

People often ask me whether the Oracle Certifications are a worthy endeaver. I think it really depends on why you want one. They are sometimes helpful if you are looking for a job since some recruiters and employers require them. That mentality weeds out a lot of talented Oracle experts. My certifications have been current since Oracle 8 and I don't think it was ever a factor in getting employed. Personally I like an "Oracle quantified" goal and I use it as another excuse to read the Concepts and New Features guides when Oracle has a new release. I feel like I'm staying current and I always learn something about an old release that I didn't previously know. So, yes. I think they are worthy.

However, I don't think they are worth a grain of salt when it comes to sizing someone up. The other day I was interviewing a candidate who had a 9i certification. I usually reframe my questions if they do have a certification since they tend to have an idea what an Oracle instance is. This guy did not. He had eight years of Oracle experience and somewhere in the interview he said that a controlfile was needed to start an instance. I let it slide since I was trying to get something else out of him, but quickly pointed out that they were only needed to mount the database. He then went into a huge defense of how they were and then drew a line in the sand. I like this sort of a conviction in an interview. Unfortunately he was just wrong.

I booted up my laptop. Showed him what services I was currently running and then created a file called C:\TEMP\andy.pfile with one line:

DB_NAME = ANDY

I then set my ORACLE_SID to be ANDY and ran oradim:

oradim -new -sid andy -pfile C:\temp\andy.pfile

Logged into sqlplus as sys:

sqlplus / as sysdba

SQL> startup nomount pfile=C:\temp\andy.pfile
"ORACLE instance started."

SQL> select status from v$instance;
STATUS
------------
STARTED

SQL>select name from v$controlfile;
no rows selected

SQL>show parameter control_files
NAME TYPE VALUE
------------------------- ---------- -------------------------------------------
control_files string C:\ORACLE\ORA10G\DATABASE\CTL1 ANDY.ORA

SQL>host dir C:\ORACLE\ORA10G\DATABASE\CTL1ANDY.ORA Volume in drive C has no label. Volume Serial Number is 3445-7DFD
Directory of C:\ORACLE\ORA10G\DATABASE
File Not Found

Certifications aren't everything.

Wednesday, August 22, 2007

First post

I've decided to track my latest technology endeavers here on the the web. I may also post tips and other items that I find useful to me. If you see blatant errors please feel free to point them out to me. Also point out better ways to do things since I hate wasting my time.