SQL Server DBA learning Oracle

  • Hello,

    The DBA position (me) at our organization has, up to this point, been solely responsible for SQL Server systems, with support for our Oracle systems contracted out. With budget constraints, I am now being asked to support our Oracle 10g systems on HP-UX.

    We have server management teams to handle the OS and healthy operation of the server and I won't need to handle day-to-day OS management, though I am comfortable with UNIX daemons, vim, cron(tab), etc..

    Where I fall short is in knowledge of Oracle and specifically how it is implemented in our environment. The latter I'll pick up over time through experience, but I'm reaching out for any advice from community who manage both or have been in a similar situation:

    - What training resources would you recommend?

    - What has your experience, if any, with Oracle University been like?

    - Is there anything available specifically in the realm of SQL Server to Oracle transition?

    - Any books or other resources which you find valuable?

    Of course, experience is the best teacher! I'll actually be doing more in our environment as time goes on, but thought I'd also reach out to the community for your thoughts and advice. This question has been asked before in this forum, but it was a couple of years ago so I read the advice there and decided to ask again to gather some fresh input.

    Any helpful information you have would be appreciated! Thanks!

  • Oracle software is free for educational purposes so you are entitled to download and install Oracle on a home computer so to train yourself.

    Oracle documentation is free and public, please check http://www.oracle.com/pls/db112/homepage

    If you are going to be doing production support familiarize yourself with backup/recovey; it can be done using either RMAN or your own scripts. Also familiarize yourself with performance tunning, in this area focus on Explain plan, Trace/tkprof and AWR reports.

    On the scripting side, be aware that Oracle SQL and PL/SQL have different syntax - familiarize yourself with the concept of packages.

    Hope this helps.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • Thanks for the advice, Pablo.

    I already have a couple of Virtualbox VMs on my local machine running Oracle environments for playing in - these have been very helpful.

    I am also working my way through Oracle's documentation, particularly the 2-day DBA guide, which is their recommended reading. It's a joke that they call it "2-day" as there's a ton of information in there! It has been useful.

  • You can also find an application that uses an oracle database for training purposes.It dd help me a great deal.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • I was thinking of becoming bilingual so asked one of our Oracle guys, he reccomended the following books as a starting point:

    Oracle Database 11g DBA Handbook (Oracle Press) - Bob Bryla

    Beginning Oracle Database 11g Administration: From Novice to Professional (Expert's Voice in Oracle) - Iggy Fernandez

  • SQLDBA360 (4/17/2012)


    I was thinking of becoming bilingual so asked one of our Oracle guys, he reccomended the following books as a starting point:

    Oracle Database 11g DBA Handbook (Oracle Press) - Bob Bryla

    Beginning Oracle Database 11g Administration: From Novice to Professional (Expert's Voice in Oracle) - Iggy Fernandez

    Did you read these? How helpful were they?

  • As an oracle dba from ranging from 7.32 to 10.2, I've been reading up on 11G via the 2 day DBA documentation as well.

    http://docs.oracle.com/cd/B28359_01/server.111/b28301/backrest.htm

    It's a good place to start.

    I'm no longer working with oracle (only sql server).

    There are multiple ways to configure Oracle, as you probably know.

    In any configuration, you need to make sure you have things like:

    1) a backup of all datafiles when the database is shut down, including control files and pfile/spfile.

    2) a process to backup controlfile to trace (I had this file emailed to me daily via unix script).

    3) Make sure it is archivelog mode and that disk space doesn't get overwhelmed with archive logs.

    4) Make sure redo file groups are redundant.

    5) RMAN performing backups.

    Do you have a DR server? Are you applying archive/redo logs?

    I had a unix script to zip up files, ftp them to the DR site, unzip each file before it was applied, and then move it to a backup directory and zip it back up. They would be purged after a week thanks to extra disk space.

    Of note: 11G is just now allowing compression of redologs to DR sites.

    I also had a gap resolution script to check for missing archivelogs. The WAN would occassionally go down.

    The script would check for the last sequence applied on the DR server and if the next log was available.

    If it wasn't, the script would go to the production server via ftp and pull it over.

    *****

    Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P

  • Thanks, Eric!

    We have no true DR site, though our leadership is currently looking into one. We run a lot of high availability clustering, specifically through HP ServiceGuard on our UNIX systems.

  • I would also run logical backups (exports or datapump exp) fairly regularly. These are very helpful for "oops" moments-someone deletes a table accidentally, etc.

    Also, setting up a flashback area might help too, if you have the available space.

  • if you're planning to learn then aim for the OCP qualification, you'll pick up a lot more if you aim at passing the exam

    https://blogs.oracle.com/certification/entry/0118

    MVDBA

  • oh - also if you have the budget for in house training then you might want to talk to a company based in Nottingham called "Quantix"

    http://www.quantix-uk.com/

    I worked for them for a few years and the oracle consultants they have are among the best in europe.

    MVDBA

  • Aloha

    I saw your posting and thought I would reply, I was a similar boat, SQL Server DBA/Oracle

    Oracle and SQL Server are different beasts, I think having a knowledge of Oracle will help with SQL Server knowledge.

    As people have mentioned Oracle website has a wealth of knowledge

    http://tahiti.oracle.com/

    Ask Tom oracle is a great website, he answers questions - the archives may help

    http://asktom.oracle.com

    Burleson consulting

    http://www.dba-oracle.com/

    If you have metalink (oracle support site) that's a nice one also. Lots of artcles.

    The Oracle training has been watered down with the invention of oracle Enterprise Manger (OEM)

    But ORACLE WORKSHOP I is very good (I took it in San Francisco,CA). I would not say WORKSHOP II is as useful, of course my teacher could have just been terrible. ** keep in mind you can get a refund if your instructor is BAD, regretably I did not for workshop II

    In my opinion I would get a feel of installing/and reading up on the basics of Oracle before going to the Oracle Workshop I class so that you are able to learn more about the differences.

    Also I went to a seminar once by a company called Scalability Experts (a Microsoft partner I think) And they shared comparisons of SQL Server and Oracle. Try to google the article, that might help give some fundamental details of how they are similar.

    As far as books, I think a book amazon with good reviews will probably get you started. Not all authors are the same in their writing style.

    Good luck!

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • As an accidental Oracle dba myself (coming from sql server 2000) I've found the Oracle concepts most interesting to grasp what the main differences are.

    After that backup/restore (rman, needs excercise. Remember the databaseID) or transfering data (expdmp/impdp).

    Things to avoid in Oracle: Working as sysdba (you bypass some safety code), When Other Excpetion.

    Works case-sensitive (mostly), be careful with the control file,databaseid, init-parameters and System/Sysaux tablespaces (extra attention audit goes most likely in those)

    Oracle isn't so flexible as SQL Server on resetting/moving/shrinking databases (in my experience). Beware that in 10g you can also activate licensed features by accident (dba_hist... part of the paid diagnostic/tuning pack) and you will need a lot of tools/scripts (like monitoring growth).

    Oracle works wonderfully but seems to require more administration, also a lot of interesting features are moved to the expensive enterprise level (and they don't have an MSDN program).

    Any books or other resources which you find valuable?

    Most are already posted in this topic.

    Oracle support aka Metalink is the official resource for patches,documents but requires an oracle login + active support contract. Beware that 10g is "out of support" by now.

    Oracle resources

    ta.bu.shi.da.yu

    Oracle has also an online magazine

    Oracle developer section with free oracle sql developer

    Search around for Oracle Statspack, free background monitoring instead of paid AWR[/url]

    Linked server between MSSQL and Oracle

    Had succes with orafaq as an active forum, but be prepared to format your code and post your OS. Other resources are already in this topic. Tom Kyte from Ask Tom is also a name to remember.

    Other:

    Use the new Oracle Scheduled jobs (DBMS_SCHEDULER) which have logging instead of Oracle jobs (DBMS_JOB)

    Try to boost your HP-UX skills for troubleshooting

    Have up to date statistics for the optimizer (review standard scheduled job).

    Oracle doesn't reclaim space automatically and scans till the "high water mark".

    Learn the basic diagnostics, "sqlplus" is quite reliable to connect to the oracle instance but not unicode ready.

    There is no auto-commit (only autocommit with DDL statements, and those DDL have no "wait till unlocked" feature)

    "NLS" session settings should match the client (or the file when importing one)

    Use the proper to_date, to_char, to_number (has a 3th parameter for decimals) functions

    Undo without guarantee caused some trouble (snapshot too old)

    More when I find my favorites on Oracle.

  • Elizabeth Good (5/4/2012)


    I would also run logical backups (exports or datapump exp) fairly regularly. These are very helpful for "oops" moments-someone deletes a table accidentally, etc.

    Also, setting up a flashback area might help too, if you have the available space.

    IF somebody is able to "delete a table accidentaly" then the problem relates to bad security and bad testing.

    Also, dumps created by either (exp or expdp) will not allow for point-in-time recovery not to mention that referencial integrity might be compromised if just a table (or a few tables) are "recovered" this way.

    Fix the problem, do not try a bandaid.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • This was removed by the editor as SPAM

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply