Database is not on NFS mounted storage. Hence, no views available.

[MARTIN_LAUSCH]

Hi,

yesterday I installed the NetApp Storage Plugin in our Test Cloud Control environment.

Everything works fine so far but under the (for us - the dba team) interesting link "Consolidated Database Storage Performance" we face the Info: "Database is not on NFS mounted storage. Hence, no views available."

All(most) of our databases run on NFS storage(more exact directNFS is enabled).

Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Database Server OS: Oracle Linux Server release 6.2

Clound Control Version: Oracle Enterprise Manager Cloud Control 12c Release 3 - 12.1.0.3.0 (db-plugin version 12.1.0.5.)

Cloud Control Server OS: Oracle Linux Server release 6.2

NetApp Plugin Version: NetApp Storage System Plug-in - netapp.storage.sys - 12.1.0.2.0

Any ideas how to get it work?

Thanks & regards,

Martin

[NAVEENGARG]

Are you open for a quick call ? I think it may be the quickest way to resolve this ?

Thanks

Naveen   

[nkarthik]

Sure. we can discuss in the call. I was a co-developer and tester for this tool.

can you call my cell: 919-xxx-xxxx after 1 hour?

regards,

Karthikeyan.N

edit: number removed

[NAVEENGARG]

Yes.

[sachin1]

Hi Naveen,

Thank you for sharing data. I request you to please validate the following steps:

1. Database discovery is done in EM12c .
2. Go to the database “HOST” target in EM 12c and click on the host target on which database resides. From host target drop down, click on “Host-> StorageDetails”. It will launch the “Storage Details” page. Please refer attached screenshot. There is a table displayed on bottom of screen and click on “File Systems”  tab and check that your discovered database storage mount point is shown there. (Please note that whenever you define new mount point on host, this  list should reflect the change.), otherwise, Database Performance views will not work. This mount point discovery is updated periodically. (It might be possible that DB views are not working because this discovery might not have finished)
3. Please click on NetApp Storage Target type and go to “Target HomePage drop down ->All Metrics”. Please click on “Volume List” metric and confirm if the volume is listed there on which database resides.
4. If all above steps holds good, please execute the below query on EM 12c repository and send the result:
   

SELECT V2.TARGET_NAME,  V1.FILESYSTEM, SUBSTR(V1.FILESYSTEM,INSTR(V1.FILESYSTEM,':')+6, (CASE WHEN (INSTR(V1.FILESYSTEM,'/',1,3) > 0)

THEN INSTR(V1.FILESYSTEM,'/',1,3) - INSTR(V1.FILESYSTEM,'/',1,2) - 1 ELSE 100 END)) "VOLUMENAME"

FROM MGMT$STORAGE_REPORT_NFS V1, MGMT$DB_DATAFILES V2

WHERE V1.MOUNTPOINT = V2.OS_STORAGE_ENTITY and V2.TARGET_NAME='<DATABASE_NAME>' -- Please specify database name here

If above SQL doesn’t show data, we will have call tonight to drill down this problem further.

Regards,

Sachin Maheshwari

[NAVEENGARG]

Hi Sachin,

1. Yes, the database is discovered in EM12c.
2. The discovered database storage mount point are shown in the host->storage details->filesystems page
3. Yes, the volume is listed on the NetApp -> Monitoring->All Metrics->Volume details page
4. Screen shot attached.

I can't find any link to attach a file. I will email you.

Thanks.

[NAVEENGARG]

The following steps worked for us.

1. In StorageIPAddressMapping.xml file, edit the entry for interface name: “nfsdata01a” and set the Interface short name to: “rdnetapp01adata”. Make the manual mapping flag to true.

2. Change the collection schedule from 4 hours to 5 minutes for Network interface metric. Once this schedule change is done, wait for 5 minutes to reflect the changes in same metric “Network interface List” . Please make sure that last upload time has changed (because when you click the metric, it fetches the real time data and we want here to store the data to be uploaded. We have to enhance the manual mapping flag in next release of plug-in to work at interface entry level in xml file because next time, it again refreshes the data and set the flag to false and you lose changes that you edit in xml file.

3. Once the metric is uploaded and last upload time is reflected, we will disable the loading of this metric. (“Network Interface list”) (from 5 minutes to disable).  This will not impact your storage monitoring.

4. After that you launch the performance views again and let us  know if it works.

Thanks to both Karthik and Sachin for their help.

Naveen Garg (CTDI)