01-06-2016
2,100,
402
Join Date: Apr 2009
Last Activity: 11 February 2020, 10:24 AM EST
Posts: 2,100
Thanks Given: 26
Thanked 402 Times in 360 Posts
By "database management", do you mean "database administration", as in Oracle DBA?
If that's the case, then Oracle DBA guys usually don't do a lot of programming. And Oracle programmers usually don't do a lot of DBA work.
I say "usually" because there is a select breed of niche "developer DBAs" who can do both. In a large corporation, you may not find opportunities to do both. In smaller companies or startups, such opportunities are more.
Oracle is certified a few *nixes - Oracle Enterprise Linux, Solaris etc. but can run on virtually any Linux distro. If you are doing Oracle DBA work on *nix, then you should:
- know the file and directory structure of the *nix installation
- use commands to navigate around, find files, search/replace in files, zip, rename etc.
- do backup, recovery, using Oracle's utilities etc. on *nix.
- be comfortable with basic shell scripting - usually bash or ksh
If you are an Oracle programmer (who writes SQL, PL/SQL etc.) on *nix, then you should be *very* comfortable with shell scripting, sed, awk and/or scripting languages.
That's because once a SQL script is written, deploying and/or scheduling it in a *nix environment requires a little bit of scripting glue work.
As an example, if you want to connect to Oracle and execute your SQL script for a bunch of dates, spool the results to different files, aggregate the results, mail them to interested parties and then tar gzip the files, version them and move them to an archive directory, then you'd need pretty decent shell scripting skills.
Pick up a good book on Unix or Linux and understand the basics, how the filesystem is structured, what the commands are, how to use them etc.
Learn shell scripting - bash and ksh should be enough for a start.
Learn awk.
Install a Linux system as a VM (or even a dual boot), install Oracle and get comfortable with startup, shutdown, sqlplus etc.
Check this site for posts on Oracle and Linux - there are members here who work on Oracle on Linux. Look at the problems and see how they are solved.
Hope that helps.