Oracle ACFS

[Former Member]

Hi,

I apologize for the question as I'm sure experience DBAs have done this a million times.

We are creating our first SAP - Oracle RAC environment.  As such we will be using ACFS which is new to me.

On this cluster, we will have both Netweaver and Non-Netweaver DBs.

I do have grid installed on all nodes...

On the RAC servers we have grid installed

GRID:  Oracle_base = /oracle/BASE

GRID:  Oracle_home = /oracle/GRID/11204

My question is what do people typically name the ACFS Database home?  Is there a naming standard?  Is there any naming different for Netweaver vs non-netweaver homes?

For example: Do people just use ORAHOME or ORAHOME1

Also where do you have the mount points on the DB server? (Database Home Mountpoints)  How are they typically named?  I understand how to do it just not where to put them.

Where to you typically see the mount points at?  /oracle/orahome ?

Hopefully I am making sense.

Thank-you for your help in advance...

Mike

[fidel_vales]

Hi,

not sure what you mean so I start from the easy part.

in SAP the ORACLE_HOME "mount point" is easy as it is indicated on the documentation:

/oracle/<SID>/11204 (the last bit might change depending on your version) and a soft link called /oracle/<SID>/112 pointing to the previous directory.

You can find this on the ORACLE RAC for SAP installation guide that you can find in the oracle community (Configuration of SAP NetWeaver for Oracle Grid Infrastructure 11.2 with Oracle Real Application Clus...)

Regarding to your first question

My question is what do people typically name the ACFS Database home?  Is there a naming standard?  Is there any naming different for Netweaver vs non-netweaver homes?

I assume that you are asking about the disk group for the ACFS. If so then the following document:

Installation and Configuration Requirements for Oracle ASM with SAP

recommends to call it +ACFS

Regards

[Former Member]

Hi Fidel,

Thank-you for the reply and the guide links.  I have previously looked at both.

I didn't lay out my question very well. 

I have the disk group created +ACFS

I have created an ACFS volume on the +ACFS disk called ORAHOMENW (oracle home netweaver)

I then wanted to an ASM volume and then mount that volume to the DB server.

I was going to have the volume mount to OS at /oracle/acfsmounts/nw11204 is that what is typical?

So the netweaver homes would be something like /oracle/acfsmounts/nw11204/oracle/<SID>/11204

On our single installs I see that the homes the DBs are /oracle/<SID>/11204  but using RAC & ACFS what do people typically do for the OS mount point.

Thanks,

Mike

[fidel_vales]

Thank-you for the reply and the guide links.  I have previously looked at both.

I was going to have the volume mount to OS at /oracle/acfsmounts/nw11204 is that what is typical?

So the netweaver homes would be something like /oracle/acfsmounts/nw11204/oracle/<SID>/11204

On our single installs I see that the homes the DBs are /oracle/<SID>/11204  but using RAC & ACFS what do people typically do for the OS mount point.

no, you did not read the documents I mentioned as this is in those manuals.

The ORACLE_HOME in RAC/ASM still MUST follow the SAP indications and it is indicated in the manual and in my reply

/oracle/<SID>/11204 is the "physical" directory (IHRDBMS) where you install the oracle therefore, if you use ASM, that is the volumen form ASM that you have to provide.

/oracle/<SID>/112 is a softlink (OHRDBMS) to the previous directory that the user <sid>adm will have as ORACLE_HOME directory.

if you prefer something shorter, then look at the note 1554661  - Configuration of environment for 'oracle' user and note 1524205  - Oracle 11.2.0: Database Software Installation