Problem solve Get help with specific problems with your technologies, process and projects.

Questions regarding Oracle software and executables in various environments

I have related questions regarding Oracle software and Oracle executables (e.g., Pro*C) install in the following environments:
A. Compaq Tru64 UNIX v4.0F
B. 2-node ASE cluster v1.6
C. RA8000 shared SCSI (AdvFS; several RAIDed disks)
D. normal operation: Oracle7 and Oracle8 databases and Pro*C apps running on primary node
E. OPS not used

I thought you might be able to comment on/answer a few questions or know a colleague who has had Oracle/ASE Failover-Clustering/RAID experience. The shared disks are attached to only one server/node at a time. Oracle database files reside on shared disks. At failover, via configured STOP and START scripts, the databases are shut down and disks re-mount on backup node; and databases re-started on backup node. Also, Pro*C apps are stopped on primary node and re-started on backup node by the same failover STOP and START scripts. Failover and the single Disk Service that causes the failover is fairly straightforward if Oracle software (e.g., Oracle7, Oracle8, Oracle Developer v6.0) are installed on each node separately; i.e., on local disks--and I tend to want to install Oracle software (Oracle7, Oracle8, Oracle Developer, etc.) on each set of local/private disks per each node. Am I correct in thinking that for a single install of all required Oracle software on the shared disks; failover of databases and apps will not function without special configuration; e.g., multiple ASE services, multiple Oracle Homes on the shared disks, etc.?

It sounds like you've developed quite the custom configuration. This type of architecture can sure test one's mettle.

To my knowledge, Oracle Corp. does not officially support shared disks for both the RDBMS software and the database files. There have been many instances where one has gotten the whole thing to work. So I know that your current direction is plausible and can be accomplished. But keep in mind that Oracle may not support certain technical issues should you run into problems. Their first response may be something like "We do not support that feature. Please change your configuration."

Installing the Oracle software on shared storage will be more complicated. It is easier to install separately on each of the two systems.

The only writeable file in the ORACLE_HOME subdirectory that is updated when running an Oracle database is the sgadef .dbf (pre-Oracle 8i) or lk (Oracle 8i). This is assuming that your followed OFA recommendations when installing your software. The technical reasons why it will/won't work generally fall under the realm of network connectivity to shared drives. This is a gray area and as such is why Oracle doesn't support this configuration.

Now all of this assumes that you are not trying to start both database instances against the same datafiles at the same time. Unless you run Oracle Parallel Server, you will not be able to run multiple instances against the same database.

Again, others have gotten this to work on shared or networked drives. But Oracle does not support this configuration. Your best bet would be to install them locally.

For More Information

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.