Open it with notepad. Scroll down to the DbProviderFactories, which should look similar to the following. Copy the entry for Oracle Data Provider for .NET (which targets .NET 2.0 x64), which currently has this value: <add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" /> Open machine.config for .NET 4 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config (if using Notepad, be sure to run Notepad as Administrator). Scroll down to the DbProviderFactories element and paste the copied value. Save the changes. Create the Monitoring Connection String You can use Oracle's EZ CONNECT syntax for adding a connection string to the Oracle database. Run notepad as an Administrator and open the root web.config available at C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config Scroll down to the bottom to view the connectionStrings section. It may contain SQL connection string created by AppFabric. You will need to add a connection string (using EZ CONNECT syntax) to your Oracle install that uses the invariant name of the DbProviderFactory you added to machine.config for the value of the providerName (it should be Oracle.DataAccess.Client): <add connectionString="Data Source=conviction/xe; User Id=SYSTEM; Password=*********" providerName="Oracle.DataAccess.Client" name="AF_Monitoring_Oracle" /> Create the Monitoring Schema Objects Log in to Oracle. Click SQL Scripts. Click Upload.
Open it with notepad. Scroll down to the DbProviderFactories, which should look similar to the following. Copy the entry for Oracle Data Provider for .NET (which targets .NET 2.0 x64), which currently has this value: <add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" /> Open machine.config for .NET 4 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config (if using Notepad, be sure to run Notepad as Administrator). Scroll down to the DbProviderFactories element and paste the copied value. Save the changes. Create the Monitoring Connection String You can use Oracle's EZ CONNECT syntax for adding a connection string to the Oracle database. Run notepad as an Administrator and open the root web.config available at C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config Scroll down to the bottom to view the connectionStrings section. It may contain SQL connection string created by AppFabric. You will need to add a connection string (using EZ CONNECT syntax) to your Oracle install that uses the invariant name of the DbProviderFactory you added to machine.config for the value of the providerName (it should be Oracle.DataAccess.Client): <add connectionString="Data Source=conviction/xe; User Id=SYSTEM; Password=*********" providerName="Oracle.DataAccess.Client" name="AF_Monitoring_Oracle" /> Create the Monitoring Schema Objects Log in to Oracle. Click SQL Scripts. Click Upload.
AppFabric%20Monitoring%20on%20Oracle%2010g%20XE.docx