Updating ATGLite Failed — Oracle Analytics

Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Updating ATGLite Failed

Received Response
62
Views
6
Comments
RakeshBI
RakeshBI Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Hello,

Installing OBIA 11.1.1.10.1 on Linux 64 machine.

successfully Completed Below Steps:

  1. Run OBIEE RCU
  2. Execute OBIEE Installation
  3. Execute ODI Installation, Separate download and install as per certification.
  4. Execute BIApps RCU
  5. Execute BIApps Software
  6. Apply Patches (Bundle Patches): Applied manually each one of them (Total 4, bishiphome/generic, bishiphome/linux64, oracle_common/generic, ODI/generic)
  7. Apply Weblogic Patch: BUNQ

  

Failed while "Updating ATGLite"

[2016-02-21T22:38:26.546-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Log level is: NOTIFICATION:16

[2016-02-21T22:38:26.619-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Oracle Fusion Middleware Patch Set Assistant 11.1.1.9.0

[2016-02-21T22:38:26.620-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Label name: J2EEDEVPROD_11.1.1.9.0_GENERIC_141204.1254

[2016-02-21T22:38:26.620-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Host name: orabi.machine1.com

[2016-02-21T22:38:26.621-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Middleware home: /home/apps3/fmw3

[2016-02-21T22:38:26.621-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Oracle home: /home/apps3/fmw3/oracle_common

[2016-02-21T22:38:26.621-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  WebLogic home: /home/apps3/fmw3/wlserver_10.3

[2016-02-21T22:38:26.621-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  os.name: Linux

[2016-02-21T22:38:26.621-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  os.version: 2.6.39-400.109.6.el6uek.x86_64

[2016-02-21T22:38:26.621-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  os.arch: amd64

[2016-02-21T22:38:26.621-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  user.name: oracle

[2016-02-21T22:38:26.621-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  user.home: /home/oracle

[2016-02-21T22:38:26.621-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  user.dir: /home/apps3/fmw3/Oracle_BI1/bin

[2016-02-21T22:38:26.622-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  user.country: US

[2016-02-21T22:38:26.622-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  user.language: en

[2016-02-21T22:38:26.622-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  file.encoding: UTF-8

[2016-02-21T22:38:26.622-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  java.vendor: Oracle Corporation

[2016-02-21T22:38:26.622-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  java.version: 1.7.0_80

[2016-02-21T22:38:26.622-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  java.home: /home/apps3/fmw3/Oracle_BI1/jdk/jre

[2016-02-21T22:38:26.622-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Java.class.path: /home/apps3/fmw3/oracle_common/jlib/ua.jar:/home/apps3/fmw3/oracle_common/jlib/mrua.jar:/home/apps3/fmw3/oracle_common/modules/oracle.jdbc_11.1.1/ojdbc6dms.jar:/home/apps3/fmw3/oracle_common/modules/oracle.jrf_11.1.1/fmwgenerictoken.jar:/home/apps3/fmw3/oracle_common/modules/datadirect_4.1/wlsqlserver.jar:/home/apps3/fmw3/oracle_common/modules/datadirect_4.1/wldb2.jar:/home/apps3/fmw3/oracle_common/modules/datadirect_4.1/wlsybase.jar:/home/apps3/fmw3/oracle_common/modules/mysql-connector-java-commercial-5.1.17/mysql-connector-java-commercial-5.1.17-bin.jar:/home/apps3/fmw3/oracle_common/jlib/postgresql-8.4-701.jdbc4.jar:/home/apps3/fmw3/oracle_common/jlib/jewt4.jar:/home/apps3/fmw3/oracle_common/jlib/rcucommon.jar:/home/apps3/fmw3/oracle_common/jlib/SchemaVersion.jar:/home/apps3/fmw3/oracle_common/modules/oracle.odl_11.1.1/ojdl.jar:/home/apps3/fmw3/oracle_common/modules/oracle.dms_11.1.1/dms.jar:/home/apps3/fmw3/oracle_common/modules/oracle.bali.share_11.1.1/share.jar:/home/apps3/fmw3/oracle_common/modules/oracle.xdk_11.1.0/xmlparserv2.jar:/home/apps3/fmw3/oracle_common/modules/oracle.ldap_11.1.1/ojmisc.jar:/home/apps3/fmw3/oracle_common/modules/oracle.help_5.0/help-share.jar:/home/apps3/fmw3/oracle_common/modules/oracle.help_5.0/ohj.jar:/home/apps3/fmw3/oracle_common/modules/oracle.help_5.0/oracle_ice.jar:/home/apps3/fmw3/oracle_common/odi_misc/ojmisc.jar:/home/apps3/fmw3/oracle_common/odi_misc/help-share.jar:/home/apps3/fmw3/oracle_common/odi_misc/ohj.jar:/home/apps3/fmw3/oracle_common/odi_misc/oracle_ice.jar:/home/apps3/fmw3/oracle_common/odi_misc/share.jar:/home/apps3/fmw3/oracle_common/odi_misc/fmwgenerictoken.jar:/home/apps3/fmw3/oracle_common/odi_misc/wlsybase.jar:/home/apps3/fmw3/oracle_common/odi_misc/wldb2.jar:/home/apps3/fmw3/oracle_common/odi_misc/wlsqlserver.jar:/home/apps3/fmw3/oracle_common/oracledi.sdk/lib/hsqldb.jar

[2016-02-21T22:38:26.622-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Java.library.path: /home/apps3/fmw3/oracle_common/lib:/home/apps3/fmw3/patch_wls1036/profiles/default/native:/home/apps/oracle/product/11.2.0/dbhome_1/lib:lib:/usr/lib:/home/apps3/fmw3/wlserver_10.3/server/native/linux/x86_64:/home/apps3/fmw3/wlserver_10.3/server/native/linux/x86_64/oci920_8:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib

[2016-02-21T22:38:26.623-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Log file is located at: /home/apps3/fmw3/oracle_common/upgrade/logs/psa2016-02-21-22-38-26PM.log

[2016-02-21T22:38:26.739-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/oracle_common/upgrade/components/audit.xml

[2016-02-21T22:38:26.758-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component AUDIT in /home/apps3/fmw3/oracle_common

[2016-02-21T22:38:26.759-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/oracle_common/upgrade/components/mds.xml

[2016-02-21T22:38:26.764-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component MDS in /home/apps3/fmw3/oracle_common

[2016-02-21T22:38:26.764-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/oracle_common/upgrade/components/opss.xml

[2016-02-21T22:38:26.771-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component OPSS in /home/apps3/fmw3/oracle_common

[2016-02-21T22:38:26.771-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/Oracle_BI1/upgrade/components/fsm.xml

[2016-02-21T22:38:26.776-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component FSM in /home/apps3/fmw3/Oracle_BI1

[2016-02-21T22:38:26.776-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/Oracle_BI1/upgrade/components/atg.xml

[2016-02-21T22:38:26.781-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component ATGLITE in /home/apps3/fmw3/Oracle_BI1

[2016-02-21T22:38:26.781-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/Oracle_BI1/upgrade/components/biacm.xml

[2016-02-21T22:38:26.787-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component BIACM in /home/apps3/fmw3/Oracle_BI1

[2016-02-21T22:38:26.787-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/Oracle_BI1/upgrade/components/atglite_otbi.xml

[2016-02-21T22:38:26.793-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component ATGLITE_OTBI in /home/apps3/fmw3/Oracle_BI1

[2016-02-21T22:38:26.793-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/Oracle_BI1/upgrade/components/biplatform.xml

[2016-02-21T22:38:26.798-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component BI in /home/apps3/fmw3/Oracle_BI1

[2016-02-21T22:38:26.798-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/Oracle_BI1/upgrade/components/otbi.xml

[2016-02-21T22:38:26.803-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component OTBI in /home/apps3/fmw3/Oracle_BI1

[2016-02-21T22:38:26.803-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/Oracle_BI1/upgrade/components/biacm_io.xml

[2016-02-21T22:38:26.807-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component BIACM_IO in /home/apps3/fmw3/Oracle_BI1

[2016-02-21T22:38:26.808-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Reading upgrade descriptor /home/apps3/fmw3/Oracle_ODI1/upgrade/components/odi.xml

[2016-02-21T22:38:26.814-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Component ODI in /home/apps3/fmw3/Oracle_ODI1

[2016-02-21T22:38:26.815-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Sorting components according to dependencies

[2016-02-21T22:38:32.107-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Adding dependency on component ATGLITE for plugin invocation BIACM

[2016-02-21T22:38:32.108-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Adding dependency on component FSM for plugin invocation BIACM

[2016-02-21T22:38:32.110-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Adding dependency on component MDS for plugin invocation BI1

[2016-02-21T22:38:40.121-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  User confirms prerequisite has been met: Database backup completed

[2016-02-21T22:38:40.121-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  User confirms prerequisite has been met: Database version is certified by Oracle for Fusion Middleware upgrade

[2016-02-21T22:39:05.652-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Db connect string for ATGLITE jdbc:oracle:thin:oracle_dba/******@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:17.291-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Db connect string for ATGLITE jdbc:oracle:thin:BIA_BIACOMP/******@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:17.384-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Starting to examine components.

[2016-02-21T22:39:17.387-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Libraries for ATGLITE.ATGLITE

[2016-02-21T22:39:17.387-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    /home/apps3/fmw3/Oracle_BI1/jlib/ATGLitePlugin.jar

[2016-02-21T22:39:17.394-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Starting to examine ATGLITE.ATGLITE.

[2016-02-21T22:39:17.395-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Inputs to plugin for ATGLITE.ATGLITE

[2016-02-21T22:39:17.395-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Oracle Home /home/apps3/fmw3/Oracle_BI1

[2016-02-21T22:39:17.395-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Input ATGLITE.ATGLITE.SCHEMA.ATGLITE

[2016-02-21T22:39:17.395-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]      Database type: Oracle Database

[2016-02-21T22:39:17.395-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]      Connection string: orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:17.395-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]      DBA name: oracle_dba

[2016-02-21T22:39:17.395-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]      Schema name: BIA_BIACOMP

[2016-02-21T22:39:17.395-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Database product version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

]]

[2016-02-21T22:39:17.395-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Database driver name: Oracle JDBC driver

[2016-02-21T22:39:17.395-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    Database driver version: 11.2.0.3.0

[2016-02-21T22:39:17.398-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  #########  Source Release: 0

[2016-02-21T22:39:17.398-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  #########  Target Release: 11.1.1.9.0

[2016-02-21T22:39:17.398-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  #########  statusstring: UPGRADING

[2016-02-21T22:39:17.399-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  #########  connectString: orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:17.399-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  #########  sysusername: oracle_dba

[2016-02-21T22:39:17.399-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  #########  Schemaname : BIA_BIACOMP

[2016-02-21T22:39:17.419-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Component ID=ATGLITE, Schema=BIA_BIACOMP, Schema version=0, Status=UPGRADING, Upgraded=false

[2016-02-21T22:39:17.419-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Finished examining ATGLITE.ATGLITE with status: SUCCESS.

[2016-02-21T22:39:17.419-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Finished examining components.

[2016-02-21T22:39:21.709-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Starting to upgrade components.

[2016-02-21T22:39:21.710-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Starting to upgrade ATGLITE.ATGLITE.

[2016-02-21T22:39:24.783-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  #########  Upgrade Path: 0 --> 11.1.1.9.0

[2016-02-21T22:39:24.787-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Database connect string: jdbc:oracle:thin:oracle_dba/******@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:24.791-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  Connecting to database: user:oracle_dba, connectString:jdbc:oracle:thin:oracle_dba/*****@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:24.820-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  upgradeScript=/home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/fnd_atglite_sysgrants.sql BIA_BIACOMP

[2016-02-21T22:39:24.823-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  ParseNexecute Script: /home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/fnd_atglite_sysgrants.sql

[2016-02-21T22:39:26.882-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Database connect string: jdbc:oracle:thin:BIA_BIACOMP/******@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:26.882-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  Connecting to database: user:BIA_BIACOMP, connectString:jdbc:oracle:thin:BIA_BIACOMP/*****@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:26.908-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  upgradeScript=/home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/upgrade.sql

[2016-02-21T22:39:26.909-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  ParseNexecute Script: /home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/upgrade.sql

[2016-02-21T22:39:30.448-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Database connect string: jdbc:oracle:thin:BIA_BIACOMP/******@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:30.449-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  Connecting to database: user:BIA_BIACOMP, connectString:jdbc:oracle:thin:BIA_BIACOMP/*****@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:30.474-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  upgradeScript=/home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/fnd_log.pkh

[2016-02-21T22:39:30.475-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  ParseNexecute Script: /home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/fnd_log.pkh

[2016-02-21T22:39:32.503-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Database connect string: jdbc:oracle:thin:BIA_BIACOMP/******@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:32.504-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  Connecting to database: user:BIA_BIACOMP, connectString:jdbc:oracle:thin:BIA_BIACOMP/*****@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:32.532-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  upgradeScript=/home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/fnd_log.pkb

[2016-02-21T22:39:32.532-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  ParseNexecute Script: /home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/fnd_log.pkb

[2016-02-21T22:39:34.562-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Database connect string: jdbc:oracle:thin:BIA_BIACOMP/******@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:34.562-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  Connecting to database: user:BIA_BIACOMP, connectString:jdbc:oracle:thin:BIA_BIACOMP/*****@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:34.590-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  upgradeScript=/home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/fnd_csm_backup.pkh

[2016-02-21T22:39:34.590-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  ParseNexecute Script: /home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/fnd_csm_backup.pkh

[2016-02-21T22:39:36.623-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Database connect string: jdbc:oracle:thin:BIA_BIACOMP/******@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:36.624-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  Connecting to database: user:BIA_BIACOMP, connectString:jdbc:oracle:thin:BIA_BIACOMP/*****@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:36.652-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  upgradeScript=/home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/fnd_csm_backup.pkb

[2016-02-21T22:39:36.652-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  ParseNexecute Script: /home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/schema/oracle/atg/fnd_csm_backup.pkb

[2016-02-21T22:39:38.716-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Database connect string: jdbc:oracle:thin:BIA_BIACOMP/******@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:38.716-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  Connecting to database: user:BIA_BIACOMP, connectString:jdbc:oracle:thin:BIA_BIACOMP/*****@orabi.machine1.com:1521/biapps.machine1.com

[2016-02-21T22:39:38.740-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  upgradeScript=/home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/sdf/atg/atg-pre-seeddata-load.sql

[2016-02-21T22:39:38.741-08:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine]  ParseNexecute Script: /home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/sdf/atg/atg-pre-seeddata-load.sql

[2016-02-21T22:39:40.916-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]   APPLSEED_TS_CLASSPATH:/home/apps3/fmw3/Oracle_BI1/atgpf:/home/apps3/fmw3/Oracle_BI1/../oracle_common/modules:/home/apps3/fmw3/Oracle_BI1/fsext/modules/oracle.fs.fsext:/home/apps3/fmw3/Oracle_BI1/sdf

[2016-02-21T22:39:40.917-08:00] [ATGLITE] [NOTIFICATION] [upgrade.ATGLITE.ATGLITE]  ######## sdf command: java -DORACLE_HOME=/home/apps3/fmw3/Oracle_BI1 -DATGLITE=Y -cp /home/apps3/fmw3/Oracle_BI1/atgpf/lib/oracle.apps.fnd.applseed-orch.jar oracle.apps.fnd.applseed.orch.SDFOrchestrator -dburl orabi.machine1.com:1521/biapps.machine1.com -dbuser BIA_BIACOMP -log /home/apps3/fmw3/oracle_common/upgrade/logs/psa2016-02-21-22-38-26PM.log_sdftask_1.log -tasks /home/apps3/fmw3/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/sdf/atg/atg-tasks.xml -config /home/apps3/fmw3/Oracle_BI1/sdf/orchestrator.properties -homedir /home/apps3/fmw3/Oracle_BI1/sdf/

[2016-02-21T22:40:20.535-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Finished upgrading ATGLITE.ATGLITE with status: FAILURE.

[2016-02-21T22:40:20.536-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Finished upgrading components.

[2016-02-21T22:40:20.536-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    0 components upgraded with success.

[2016-02-21T22:40:20.537-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    1 components upgraded with failure.

[2016-02-21T22:40:20.537-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    0 components already upgraded.

[2016-02-21T22:40:20.537-08:00] [Framework] [NOTIFICATION] [upgrade.Framework]    0 components skipped.

Answers

  • RakeshBI
    RakeshBI Rank 1 - Community Starter

    Additionally in the logs:

    psa2016-02-21-22-38-26PM.log_sdftask_1.logsdf_worker11_2016-02-21_103946793_PM.log

    [INFO] 22:39:47 : Loader called from SDF Orchestrator

    [INFO] 22:39:47 : Parameters: -am oracle.apps.fnd.applcore.taxonomy.taxonomyService.applicationModule.ApplTaxonomyAM -file /home/apps3/fmw3/Oracle_BI1/sdf/../biapps/admin/provisioning/update/11.1.1.9.0/from0/sdf/atg/AR/ApplTaxonomySD.xlf -nls -dbuser BIA_BIACOMP -dburl jdbc:oracle:thin:@orabi.rakesh.com:1521/biapps.rakesh.com -log /home/apps3/fmw3/oracle_common/upgrade/logs/psa2016-02-21-22-38-26PM.log_sdftask_1.logsdf_worker11_2016-02-21_103946793_PM.log -loglevel INFO

    [INFO] 22:39:47 : Java Home: /home/apps3/fmw3/Oracle_BI1/jdk/jre

    [INFO] 22:39:47 : Java Version: Java HotSpot(TM) 64-Bit Server VM 24.80-b11

    [INFO] 22:39:47 : Using SYSTEM class loader (No J2EE archives, No Force)

    [INFO] 22:39:47 : Looking for JARs in /home/apps3/fmw3/Oracle_BI1/atgpf

    [INFO] 22:39:47 : Looking for JARs in /home/apps3/fmw3/Oracle_BI1/../oracle_common/modules

    [INFO] 22:39:47 : Excluding builtin /home/apps3/fmw3/Oracle_BI1/../oracle_common/modules/groovy-all-1.6.0.jar

    [INFO] 22:39:47 : Excluding builtin /home/apps3/fmw3/Oracle_BI1/../oracle_common/modules/groovy-all-1.6.3.jar

    [INFO] 22:39:47 : Excluding builtin /home/apps3/fmw3/Oracle_BI1/../oracle_common/modules/groovy-all-2.0.5.jar

    [INFO] 22:39:47 : Excluding builtin /home/apps3/fmw3/Oracle_BI1/../oracle_common/modules/groovy-all-2.1.6.jar

    [INFO] 22:39:47 : Excluding builtin /home/apps3/fmw3/Oracle_BI1/../oracle_common/modules/oracle.adf.model.generic_11.1.1/bc4jdomgnrc.jar

    [INFO] 22:39:48 : Looking for JARs in /home/apps3/fmw3/Oracle_BI1/fsext/modules/oracle.fs.fsext

    [INFO] 22:39:48 : Looking for JARs in /home/apps3/fmw3/Oracle_BI1/sdf

    [INFO] 22:39:48 : Added 29 techstack classpath entries from /home/apps3/fmw3/Oracle_BI1/atgpf

    [INFO] 22:39:48 : Added 527 techstack classpath entries from /home/apps3/fmw3/Oracle_BI1/../oracle_common/modules

    [INFO] 22:39:48 : Added 7 techstack classpath entries from /home/apps3/fmw3/Oracle_BI1/fsext/modules/oracle.fs.fsext

    [INFO] 22:39:48 : Added 6 techstack classpath entries from /home/apps3/fmw3/Oracle_BI1/sdf

    [INFO] 22:39:48 : Optimized classpath file path is null or not set, defaulting to complete classpath

    [INFO] 22:39:48 : SDF Version: ATGPF_PT.REL12_GENERIC_150811.0530

    [INFO] 22:39:48 : JBO Version: 11.1.1.66.73

    [INFO] 22:39:48 : ADFbc load.

    [INFO] 22:39:48 : Using connection proxies (primary app module)

    [INFO] 22:39:48 : Using connection proxies (rowid app module)

    [SEVERE] 22:39:53 : An unexpected error has occured {0}

    oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NoClassDefFoundError, msg=oracle/adf/share/config/ADFAuthoringSettings

      at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9553)

      at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4529)

      at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2459)

      at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2269)

      at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3168)

      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:592)

      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:525)

      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:520)

      at oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1609)

      at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1514)

      at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1485)

      at oracle.apps.fnd.applseed.rt.common.util.SDAppModuleUtil.getAppModuleByConfigName(SDAppModuleUtil.java:122)

      at oracle.apps.fnd.applseed.rt.common.util.SDAppModuleUtil.getAppModuleByConnection(SDAppModuleUtil.java:211)

      at oracle.apps.fnd.applseed.rt.loader.Loader2.loadFromWorker(Loader2.java:208)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:606)

      at oracle.apps.fnd.applseed.rt.common.util.SDCommonUtil.invokeMethod(SDCommonUtil.java:125)

      at oracle.apps.fnd.applseed.rt.loader.Loader.loadFromWorker(Loader.java:201)

      at oracle.apps.fnd.applseed.rt.loader.Loader.loadSeedDataOrch(Loader.java:167)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:606)

      at oracle.apps.fnd.applseed.orch.SDFOrchestratorWorker.loadSeedData(SDFOrchestratorWorker.java:378)

      at oracle.apps.fnd.applseed.orch.SDFOrchestratorWorker.executeSDFCommand(SDFOrchestratorWorker.java:281)

      at oracle.apps.fnd.applseed.orch.SDFOrchestratorWorker.processCommands(SDFOrchestratorWorker.java:417)

      at oracle.apps.fnd.applseed.orch.SDFOrchestratorWorker.doWork(SDFOrchestratorWorker.java:437)

      at oracle.apps.fnd.applseed.orch.SDFOrchestratorWorker.main(SDFOrchestratorWorker.java:99)

    Caused by: java.lang.NoClassDefFoundError: oracle/adf/share/config/ADFAuthoringSettings

      at oracle.apps.fnd.applcore.oaext.model.OAApplicationModuleImpl.prepareSession(OAApplicationModuleImpl.java:1104)

      at oracle.jbo.server.ApplicationModuleImpl.prepareSession(ApplicationModuleImpl.java:7037)

      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:182)

      at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9518)

      at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4529)

    ... 28 more

    Caused by: java.lang.ClassNotFoundException: oracle.adf.share.config.ADFAuthoringSettings

      at java.net.URLClassLoader$1.run(URLClassLoader.java:366)

      at java.net.URLClassLoader$1.run(URLClassLoader.java:355)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.net.URLClassLoader.findClass(URLClassLoader.java:354)

      at java.lang.ClassLoader.loadClass(ClassLoader.java:425)

    ... 35 more

    [INFO] 22:39:53 : Loader called from SDF Orchestrator

    [INFO] 22:39:53 : Parameters: -am oracle.apps.fnd.applcore.profiles.profileService.applicationModule.ProfileServiceAM -file /home/apps3/fmw3/Oracle_BI1/sdf/../biapps/admin/provisioning/update/11.1.1.9.0/from0/sdf/atg/ProfileLevelSD.xml -dbuser BIA_BIACOMP -dburl jdbc:oracle:thin:@orabi.rakesh.com:1521/biapps.rakesh.com -log /home/apps3/fmw3/oracle_common/upgrade/logs/psa2016-02-21-22-38-26PM.log_sdftask_1.logsdf_worker11_2016-02-21_103946793_PM.log -loglevel INFO

    [INFO] 22:39:53 : Java Home: /home/apps3/fmw3/Oracle_BI1/jdk/jre

    [INFO] 22:39:53 : Java Version: Java HotSpot(TM) 64-Bit Server VM 24.80-b11

    [INFO] 22:39:53 : Using SYSTEM class loader (No J2EE archives, No Force)

    [INFO] 22:39:53 : Reusing existing classpath.

    [INFO] 22:39:53 : SDF Version: ATGPF_PT.REL12_GENERIC_150811.0530

    [INFO] 22:39:53 : JBO Version: 11.1.1.66.73

    [INFO] 22:39:53 : ADFbc load.

    [INFO] 22:39:53 : Using connection proxies (primary app module)

    [INFO] 22:39:53 : Using connection proxies (rowid app module)

    [SEVERE] 22:39:53 : java.lang.NoClassDefFoundError: oracle/adf/share/config/ADFAuthoringSettings

    [INFO] 22:39:53 : java.lang.NoClassDefFoundError: oracle/adf/share/config/ADFAuthoringSettings

    [INFO] 22:39:53 : Loader called from SDF Orchestrator

    [INFO] 22:39:53 : Parameters: -am oracle.apps.fnd.applcore.profiles.profileService.applicationModule.ProfileServiceAM -file /home/apps3/fmw3/Oracle_BI1/sdf/../biapps/admin/provisioning/update/11.1.1.9.0/from0/sdf/atg/ProfileHierarchySD.xml -dbuser BIA_BIACOMP -dburl jdbc:oracle:thin:@orabi.rakesh.com:1521/biapps.rakesh.com -log /home/apps3/fmw3/oracle_common/upgrade/logs/psa2016-02-21-22-38-26PM.log_sdftask_1.logsdf_worker11_2016-02-21_103946793_PM.log -loglevel INFO

    [INFO] 22:39:53 : Java Home: /home/apps3/fmw3/Oracle_BI1/jdk/jre

    [INFO] 22:39:53 : Java Version: Java HotSpot(TM) 64-Bit Server VM 24.80-b11

    [INFO] 22:39:53 : Using SYSTEM class loader (No J2EE archives, No Force)

    [INFO] 22:39:53 : Reusing existing classpath.

    [INFO] 22:39:53 : SDF Version: ATGPF_PT.REL12_GENERIC_150811.0530

    [INFO] 22:39:53 : JBO Version: 11.1.1.66.73

    [INFO] 22:39:53 : ADFbc load.

    [INFO] 22:39:53 : Using connection proxies (primary app module)

    [INFO] 22:39:53 : Using connection proxies (rowid app module)

    [SEVERE] 22:39:53 : java.lang.NoClassDefFoundError: oracle/adf/share/config/ADFAuthoringSettings

    [INFO] 22:39:53 : java.lang.NoClassDefFoundError: oracle/adf/share/config/ADFAuthoringSettings

    [INFO] 22:39:53 : Loader called from SDF Orchestrator

    [INFO] 22:39:53 : Parameters: -am oracle.apps.fnd.applcore.nls.isoLanguageService.applicationModule.IsoLanguageServiceAM -file /home/apps3/fmw3/Oracle_BI1/sdf/../biapps/admin/provisioning/update/11.1.1.9.0/from0/sdf/atg/AR/IsoLanguageSD.xlf -nls -dbuser BIA_BIACOMP -dburl jdbc:oracle:thin:@orabi.rakesh.com:1521/biapps.rakesh.com -log /home/apps3/fmw3/oracle_common/upgrade/logs/psa2016-02-21-22-38-26PM.log_sdftask_1.logsdf_worker11_2016-02-21_103946793_PM.log -loglevel INFO

    [INFO] 22:39:53 : Java Home: /home/apps3/fmw3/Oracle_BI1/jdk/jre

    [INFO] 22:39:53 : Java Version: Java HotSpot(TM) 64-Bit Server VM 24.80-b11

    [INFO] 22:39:53 : Using SYSTEM class loader (No J2EE archives, No Force)

    [INFO] 22:39:53 : Reusing existing classpath.

    [INFO] 22:39:53 : SDF Version: ATGPF_PT.REL12_GENERIC_150811.0530

    [INFO] 22:39:53 : JBO Version: 11.1.1.66.73

    [INFO] 22:39:53 : ADFbc load.

    [INFO] 22:39:53 : Using connection proxies (primary app module)

    [INFO] 22:39:53 : Using connection proxies (rowid app module)

  • Anjum Ara
    Anjum Ara Rank 4 - Community Specialist

    Ensure the FMW pre-requisite patches are applied successfully and exist in the inventory.

    Secondly, there are a lot of thread which discuss this issue.

    Check this one - Updating FSM Fails while installing OBIA 11.1.1.9.2 on windows

    General Issues

    Thanks

    Anjum

  • RakeshBI
    RakeshBI Rank 1 - Community Starter

    when you say, FMW Pre-requisite....can you please be specific because I applied all patches that were part of the download files from edelivery.oracle.com

    I also did some research if there were any additional patches on support.oracle.com...but couldn't find anything specific.

    the only reason I could think of is Java version (my version is 1.7) causing the issue as pointed out by someone on the community threads.....

    also, your link is about FSM update whereas I faced issue while doing ATGLite using PSA

  • azakem
    azakem Rank 1 - Community Starter

    I appear to be having same issue/

    Complete recap of problem.

    Trying to install Oracle Business Intelligence Applications 11G (Release 1 (11.1.1.10) on Window 2008 R2

    Following Doc E64354-02

    I have done the following steps
    Install 12c (12.1.0.2)

    Install OBIEE RCU
    V75908-01.zip

    Install OBIEE
    V76016-01_1of5.zip
    V76016-01_2of5.zip
    V76016-01_3of5.zip
    V76016-01_4of5.zip
    V76016-01_5of5.zip

    Upgrade Web Logic
    V29856-01.zip

    Install ODI 11.1.1.9.0
    V75874-01_1of2.zip
    V75874-01_2of2.zip

    Install OBIA RCU
    V78030-01.zip

    Install OBIA
    V78028-01.zip


    Technology Patches
    Oracle Business Intelligence Applications 11.1.1.10.1 (V78030-01.zip)
    Oracle Business Intelligence Applications for Microsoft Windows X64 11.1.1.10.1 (V78034-01.zip) s

    Running into issue upgrade ATGLite.

    INFO: Mar 10, 2016 10:14:22 PM oracle.jbo.server.ApplicationModuleImpl doPoolMessage
    WARNING:
    java.lang.NoClassDefFoundError: oracle/adf/share/config/ADFAuthoringSettings

    I have installed Java 1.6.0.35.

    I have set the JAVA_HOME

    I also tried setting the JAVA_HOME to C:\app\middleware\oracle_common\jdk which as part ofOBIEE/ OBIA. Did not make a difference.

    The file ADFAuthoringSettings.class should be part of adf-share-support.jar .

    When I extracted the adf-share-support.jar file there is no sign of the ADFAuthoringSettings.class file.

    Anyone have any ideas or suggestions.

  • Pham Viet Hung
    Pham Viet Hung Rank 1 - Community Starter

    Hi all, especially RakeshBI. I aslo got that problem when config BIApps too but I've solved it like that. Some ways to cheat but this way i cheat is like a magic.
    I found that you need to upgrade ATG first. I use script to upgrade ATG manually:

    bash-4.3$ $ORACLE_HOME/jdk/bin/java -jar biappsrepositoryutil.jar upgradeATG bi.oracle.home=/u01/.../Oracle_BI1 work.dir=/u01/.../Oracle_BI1/tmp biacomp.user=DEV_BIACOMP biacomp.password=abc12345 db.conn.sid.url=hostname:1521:sid atg.db.seed.url=hostname:1521/servicename db.sys.user=sys db.sys.password=abc12345 target.upgrade.version=11.1.1.9.0

    The cheat here is very important: target.upgrade.version=11.1.1.9.0

    It show the target version we want to upgrade it but it depends on the patch folder of upgrade atg like/ biapps/admin/provisioning/
    So about patches for OBIA 11.1.1.10.1, there is a folder to upgrade version 0 to 11.1.1.9.0 of ATG, so let use target.upgrade.version=11.1.1.9.0 and dont care about other folder version upgrade in biapps/admin/provisioning/

    When we run that script, they give me an error that: Schema version registry is not set or missing components id of ATG
    The problem here is schema ATG, because when we use RCU OBIA to create schema, the COMP_ID here is ATGLITE, so that I change name of COMP_ID

    update system.SCHEMA_VERSION_REGISTRY

    set COMP_ID='ATG' where COMP_ID='ATGLITE'

    commit;

    Then we had component id ATG now, then we can use the script above, it surely works for upgrade from 0 to 11.1.1.9.0 for ATG, you can check version again in SCHEMA_VERSION_REGISTRY for ATG, it changes from 0 to 11.1.1.9.0 so you are succesfully in upgrade ATG

    The problem here is comp_id of rcu created is ATGLITE so we must change comp_id again

    update system.SCHEMA_VERSION_REGISTRY

    set COMP_ID='ATGLITE' where COMP_ID='ATG'

    commit;

    Then now we have schema ATGLITE ower BIACOMP with version 11.1.1.9.0

    Continuously, you must upgrade FSM. Cause I saw that in patches OBIA the provisioning of FSM is max 11.1.1.7.2 upgraded so that i cannot know exactly what its version it can be upgraded.
    So I try to use .psa in $ORACLE_HOME/bin to upgrade it

    Choose Components Fusion Function Setup Management Lite only, you can do this from order. It can know ATGLITE schema already upgraded. And somehow, FSM can pass through with 1 fsm_lite_delta_upgrade.sql, it doesnt have error of execute 2 sql: fsm_lite_prepare_upgrade.sql or fsm_lite_upgrade.sql
    It can run smoothly upgrade FSM. When it finished, run .psa again to upgrade schema BIACM for sure.

    And when we passed this, clearly it very easy to control configApps.sh

    And that my way, thanks for reading a long this !

    pvhung@gimasys.com

  • user8286873
    user8286873 Rank 3 - Community Apprentice

    Hi Rakesh,

    Please refer to the post below ... I was able to resolve the issue by applying the patches mentioned.

    Hope it helps you as well !

    Thanks