Thursday, February 7, 2013

Configuration Controls Governor - CCG Installation


  1. Install Oracle database or use an existing one.
  2. Install Weblogic Server or you may create a new domain.
  3. export ORACLE_HOME=/u01/product/11.2.0.3/dbhome_1
    export WEBAPPS_HOME=/u01/Middleware/wlserver_10.3
    export PATH=$JAVA_HOME/bin:$ORACLE_HOME/bin:$PATH
    export CLASSPATH=$JAVA_HOME/lib:$CLASSPATH
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib
    export ORACLE_SID=GRC
    extract the ccg_551.zip file in the staging area (ccg_551 is a file in V18542-01.zip)
  4. create table spaces AM_DATA, AM_INDEX, AM_STAGE, APS_DATA, APS_INDEX.
  5. copy the classes12.jar file from /u01/product/11.2.0.3/dbhome_1/oui/jlib/classes12.jar to /u01/Middleware/wlserver_10.3/common/lib/
  6. copy the classes12.jar file from /u01/product/11.2.0.3/dbhome_1/oui/jlib/classes12.jar to /u01/product/11.2.0.3/dbhome_1/jdbc/lib/
  7. run ./install.sh -f ccg-551-install.apf
  8. Fill in the details as per your environment.
  9. after a successful installation there should be a ccg.war file is created. In case the file is not created you may unzip the ccg-551-install.apf and copy the ccg.war file to the Install directory (In my case /u01/Middleware/wlserver_10.3/ccg
  10. create a jdbc datasouce from the weblogic console.
  11. Deploy the ccg.war file.
  12. Edit the /opt/oracle/GRC/Middleware/wlserver_10.3/ccg/config/amhome.conf with the following values.
    webcontainer = Weblogic
    amhomeDatasourceName = jndi/amhome
  13. Edit the file /u01/Middleware/wlserver_10.3/ccg/config/quartz.properties with the follwing values org.quartz.dataSource.myDS.URL = jdbc:oracle:thin:@xxxxx.xxx:1521:GRC
    org.quartz.dataSource.myDS.user = AMHOME
    org.quartz.dataSource.myDS.password = xxxxxx
    org.quartz.dataSource.myDS.maxConnections = 20
  14. edit /u01/Middleware/wlserver_10.3/ccg/WEB-INF/classes/resources/ AMResources.properties with the follwing values
    applimation.banner0 = http://hostname:port/ccg/jst/amblank.jsp
    applimation.banner1 = http://hostname:port/ccg/jst/amblank.jsp
    applimation.banner2 = http://hostname:port/ccg/jst/amblank.jsp

  15. edit startWeblogic.sh file and copy the following under the ${JAVA_HOME}/bin/java section
    -Djava.awt.headless=true -Djava.security.auth.login.config=/u01/Middleware/wlserver_10.3/ccg/WEB-INF/jaas.config -Xms256M -Xmx768.
    e.g.  ${JAVA_HOME}/bin/java ${JAVA_VM} ${MEM_ARGS} -Dweblogic.Name=${SERVER_NAME} -Djava.security.policy=${WL_HOME}/server/lib/weblogic.policy -Djava.awt.headless=true -Djava.security.auth.login.config=/u01/Middleware/wlserver_10.3/ccg/WEB-INF/jaas.config -Xms256M -Xmx768M ${JAVA_OPTIONS} ${PROXY_SETTINGS} ${SERVER_CLASS}"
  16. Restart the server and access http://hostname:port/ccg


Issue & Fixes:
In case there is an issue while deploying the ccg.war file follow the metalink:
weblogic.application.ModuleException: [HTTP:101216]Servlet: "action" failed to preload on startup in Web application: "ccg".java.lang.NullPointerException.at org.apache.commons.digester.Digester.getXMLReader(Digester.java:899)
CCG 5.5.1 Deployment With Weblogic 10.3.0.1/11g Fails [ID 1265899.1]

1 comment:

Nikhil.T said...

I recently encountered an error after clicking on Administrator -- > User.
#17:10:51 - java.text.ParseException: Unparseable date: "2013-02-08 17:10:46"
#17:10:51 - java.text.ParseException: Unparseable date: "2013-02-08 17:10:46"
at java.text.DateFormat.parse(DateFormat.java:337).

The solution from oracle was to run CCG on 10.3.1 or 10.3.2.