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: OS Utilities
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.
RSS - Posts