Monday, June 16, 2014

How to Create Database connection using Jdeveloper ?


This blog explains about how to configure Database connection using Jdeveloper, and test SQL script statements in Jdeveloper

- Launch Jdeveloper, Choose 'Database Navigator' as highlighted below
- Right click on 'IDE Connections' and choose 'New Connection'

- Enter the Database connection details - User Name, Password, Host Name, JDBC Port Name and SID/Service Name are required fields,
- If you know the JDBC URL, then select the ' Enter Custom JDBC URL' check box, paste the URL and click on 'Test' connection.
- After successful connection, You will see newly created connection in 'IDE Connections' , expand newly created connection, Right click on it, Choose 'Open SQL Worksheet' as shown below
- You can test all SQL statement sin SQL worksheet as per below screenshot.

Thursday, June 5, 2014

How to Search Images in UCM Server


This blog explains about how to perform a search in UCM for a specific image

- Login to UCM Server
- Choose Search -> Standard Search



How to Identify whether Oracle Coherence is correctly Configured in Webcenter Portal Application



This blog explains about various techniques to monitor whether Coherence is properly configured and actively being used for a Portal application or not.

Remember,  it's important to note that not all the content that you fetch from UCM will automatically gets cached. Only if you are using Content Presenter or other out of the box components then it gets cached. Any calls using RIDC and not using content presenter would not be cached. 

- If you notice below entry in your <Managed_Server>-diagnostic.log file, that means coherence is not properly configured, you need to correct.

[APP: AviTrustSamplePortal#V2.0] Unable to load Coherence configuration file content-coherence-cache-config.xml. Using in-memory (local) caches.

- Use Oracle EnterPrise MBean Browser as shown below
     - Login to Enterprise Manager
     - Select the application which you want to verify
     

- Select 'Application Deployment' drop down, Select 'System MBean Browser'
       - Ensure, You should see 'Managed Server Instances' in 'Application Defined MBeans -> Coherence' , If you don't see your managed server instances here, that means Coherence is not configured .
 - Another way of identifying is, Login to 'Webcenter Content Server'
 - Select 'Administration-> System Audit Information'
- Select 'system, requestaudit' and 'Full verbose Tracing' ash shown below, click on 'Update'
- Click on 'View Server Output' link
- Clear the content by 'Clear' link
- Open the page which has content presenter, Click on 'Refresh' button on UCM Server - View Server output window
- You should see a query and execution time in the UCM Log
- Now clear the log, and refresh the page again, You shouldn't see that query in UCM, It should have got the data from Oracle Coherence.

Trouble Shooting
- Ensure 'portal-coherence.jar' available in src->APP-INF->lib
- Ensure 'content-coherence-cache-config.xml' contains valid entries based on your requirements, focus on 'local-cache' or 'distributed-cache' based on your hardware infrastructure, concurrent user count, throughput
- Ensure 'portal-coherence.jar' deployed to '/tken4o/admin/wcp_domain/mserver/wcp_domain/lib' - This is example only, you need to find your {WL-HOME} path and identify as per this.

How to Start/Stop Application which is running in Clustered environment using Oracle EM Console

This blog explains about how to perform Stop/Start activities on a specific application which deployed to Weblogic server using Enterprise Manager

- Login to Enterprise Manager
- Expand 'Application Deployments' as shown below
- Select the application which you want to start/stop
-


- Select 'Application Deployment' drop down as shown below
- Select Start/Stop

How to enable Oracle Coherence cache with Webcenter Portal application


Just thought of sharing below article, which talks about enabling Oracle Coherence cache with Webcenter Portal applications.


http://www.ateam-oracle.com/configure-coherence-for-oracle-webcenter-portal-framework-content-presenter-task-flow/

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=482014776313176&id=1675494.1&_adf.ctrl-state=7u8olswzp_49



1. Pre health checks

2. Set Blackout

3. Login to box: vmohsxxx001.oracleoutsourcing.com

4. Navigate to  /dkendd/admin/user_projects/domains/wcp_domain/bin

cd  /dkendd/admin/user_projects/domains/wcp_domain/bin

5. Take backup of setDomainEnv.sh

cp setDomainEnv.sh setDomainEnv.sh_<DDMMYYYY>

6. Modify the setDomainEnv.sh as follows


From:
=====
if [ "${SERVER_NAME}" = "" ] ; then
   USER_MEM_ARGS=" -Xms1024m -Xmx1024m -XX:MaxPermSize=512m"
fi

if [ "${SERVER_NAME}" = "AdminServer" ] ; then
  USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
fi

if [ "${SERVER_NAME}" = "WC_Collaboration" ] ; then
   USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
fi

if [ "${SERVER_NAME}" = "WC_Portlet" ] ; then
   USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
fi

if [ "${SERVER_NAME}" = "WC_Spaces" ] ; then
   USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
fi

if [ "${SERVER_NAME}" = "WC_UCM" ] ; then
   USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
fi

if [ "${SERVER_NAME}" = "WC_Utilities" ] ; then
  USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
fi

To:
===
if [ "${SERVER_NAME}" = "" ] ; then
   USER_MEM_ARGS=" -Xms1024m -Xmx1024m -XX:MaxPermSize=512m"
   EXTRA_JAVA_PROPERTIES="${EXTRA_JAVA_PROPERTIES} -Dtangosol.coherence.management=all"
   export EXTRA_JAVA_PROPERTIES
fi

if [ "${SERVER_NAME}" = "AdminServer" ] ; then
  USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
fi

if [ "${SERVER_NAME}" = "WC_Collaboration" ] ; then
   USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
   EXTRA_JAVA_PROPERTIES="${EXTRA_JAVA_PROPERTIES} -Dtangosol.coherence.management=all"
   export EXTRA_JAVA_PROPERTIES
fi

if [ "${SERVER_NAME}" = "WC_Portlet" ] ; then
   USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
   EXTRA_JAVA_PROPERTIES="${EXTRA_JAVA_PROPERTIES} -Dtangosol.coherence.management=all"
   export EXTRA_JAVA_PROPERTIES
fi

if [ "${SERVER_NAME}" = "WC_Spaces" ] ; then
   USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
   EXTRA_JAVA_PROPERTIES="${EXTRA_JAVA_PROPERTIES} -Dtangosol.coherence.management=all"
   export EXTRA_JAVA_PROPERTIES
fi

if [ "${SERVER_NAME}" = "WC_UCM" ] ; then
   USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
   EXTRA_JAVA_PROPERTIES="${EXTRA_JAVA_PROPERTIES} -Dtangosol.coherence.management=all"
   export EXTRA_JAVA_PROPERTIES

fi

if [ "${SERVER_NAME}" = "WC_Utilities" ] ; then
  USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m"
  EXTRA_JAVA_PROPERTIES="${EXTRA_JAVA_PROPERTIES} -Dtangosol.coherence.management=all"
   export EXTRA_JAVA_PROPERTIES
fi


Save it

7. Restart the  managed servers as per OMP

8. verify the newly added parameter effected

9. Perform post health checks

How to set EAR Version for ADF application on Weblogic

Tuesday, June 3, 2014

How to resolve IllegalStateException in o.i.explorer.IconOverlayTracker$NodeWatcher Exception with JDeveloper


This blog explains about how to resolve below exception

IllegalStateException in o.i.explorer.IconOverlayTracker$NodeWatcher


- Un select below two highlighted check boxes, restart jdeveloper.