Thursday, November 10, 2011

Oracle SOA Suite – Enabling the JDBC logging through EM Console.

Oracle SOA Suite – Enabling the JDBC logging through EM Console:

Some scenarios we may required to monitor the JDBC logs generated by server for debugging the issues. The JDBC logging for the weblogic server in SOA Suite 11g  or Oracle SOA 12c can be enabled or disabled through EM console by changing the attribute value of the corresponding MBean.

Oracle SOA 11g:


Steps to Enable the JDBC Logging:


Login to EM Console.
From the navigation pane, expand the farm and SOA folders then right click on soa-infra and then select Administration and System MBean browser.



 Expand the folder Application Defined MBeans then com.oracle.jdbc then expand the Server folder for that the JDBC logging should be changed. Expand diagnosablity folder and click on the MBean available. Change the property value of LoggingEnabled to “true” and click on Apply.




Oracle SOA 12c:


Login to em console and click on Target Navigation.
Click on the server

em_console_target_navigation

Click on Weblogic Server and System MBean Server

weblogic_system_mbean_browser

 Expand the folder Application Defined MBeans then com.oracle.jdbc then expand the Server folder for that the JDBC logging should be changed. Expand diagnosablity folder and click on the MBean available. Change the property value of LoggingEnabled to “true” and click on Apply.

weblogic_enable_JDBC_logging



No comments:

Post a Comment