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.
Category: Oracle on Linux
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.
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.
RSS - Posts