In a previous post, I gave some Career Advice for the New Oracle DBA. We talked about building an environment where you can test. This is the second part of that series and it will be more of a hands on guide where we will step through installing Oracle Virtualbox.
Category: 2016 (Page 1 of 2)
When you are running Real Application Clusters, the distinction between the instance and the database becomes very clear. You now have an instance running on each server in the cluster that accesses a common database on shared storage. If you run oraenv with a newly installed RAC database, you will notice that you still have to make adjustments to environment variables to access your instance. We are going to continue the theme from my last post (using Oracle’s oraenv), and take a look at using Oracle oraenv with RAC.
When you install an Oracle code tree on a non-windows platform, Oracle includes a utility that allows you to change the OS environment and access different databases running on the machine. Let’s investigate using Oracle’s oraenv utility.
You’re a developer and its 10:30 am and you have just sat down from getting your second cup of coffee. Your boss comes out of her office and says that she needs to see you. Your mind goes to a bunch of possibilities, most of them are bad. She tells you that the DBA has quit and she needs you to step up and become the new DBA. Now what do you do? What you need is some advice for the new Oracle DBA!
Here is one of my posts from last year’s IOUG Tip Booklet titled 10 Questions (and answers) about RMAN Stored Scripts. Enjoy!
Today, most Oracle shops are using RMAN for backups. Why? Because it powerful, resilient and not very difficult to learn. It is an excellent tool to have in your DBA toolbox. Let’s add an additional tool to that toolbox that will help to make your job as a DBA a bit easier, RMAN stored scripts.
A part of your job as a DBA is maintaining database availability to match your service level agreements (SLA) with your customers. But keep in mind that this SLA can also impact any required downtime for maintenance. Throughout the years, Oracle has introduced many tools and features to reduce this maintenance downtime. Today we are going to take a look at a cool feature that will help you when you have to perform maintenance on a large table, online table redefinition.
The System Resource Verifier (aka sysresv) is an Oracle utility that gives you the status and OS resource information for a database instance. It shows you information on the shared memory and semaphore usage of the database and is extremely useful when you need to remove orphaned Oracle memory segments and avoiding a costly and time consuming reboot.
Let’s take a look at one of my early articles in the IOUG Tip Booklet. It is still relevant today…
In Oracle 9i, the spfile was introduced as a new method to store the initialization parameters. The use of the spfile helped to simplify the remote startup of a database and added options for the busy DBA. In this article, we will look at the spfile and how it is managed on UNIX/Linux and Windows.
As a DBA, you have a constant struggle between availability and maintenance. Oracle has added features over the years to give DBAs additional options for online maintenance. Oracle 12c has added a feature that is really cool and I have been waiting to have for a while. Online datafile moves!
I am honored and grateful to have been selected as the July 2016 IOUG Spotlight Member of the Month.
Update: The IOUG does not provide a link for past Spotlight Members, so here are the questions and answers from July 2016.
RSS - Posts