Home » RDBMS Server » Enterprise Manager » Installation of Application Management Pack 3 Failed (Application Management Pack 3, Oracle Linux Ent. 5.3)
Installation of Application Management Pack 3 Failed [message #464107] Tue, 06 July 2010 05:19 Go to next message
xhyrruz
Messages: 14
Registered: June 2010
Location: Philippines
Junior Member

Hi All,

Please help me.

I've experienced an error while installing the Application Management Pack 3 on Linux Machine (OS: Oracle Enterprise Linux 5.3 32-bit) with EM Grid Control 10g Release 5. I want to install the Grid Control Plug-in Oracle E-Business Suite Management Pack 3 to manage our EBS Oracle Apps R12, but it was failed due to error. Below was the logs for error:

Log: /u01/app/oraInventory/logs/installActions2010-07-06_03-00-11PM.log
RepManager was not able to run successfully.

/applications/em/em/WEB-INF/lib/myjar.jar:/u01/app/oracle/OracleHomes/oms10g/sysman/jlib/emCfg.jar:/u01/a
pp/oracle/OracleHomes/oms10g/jlib/ojmisc.jar:/u01/app/oracle/OracleHomes/oms10g/sysman/jlib/emUpgrade.jar
:/u01/app/oracle/OracleHomes/oms10g/sysman/jlib/emagentSDK.jar oracle.apps.oms_extn.util.EBSOUIUtil RepMa
nager /u01/app/oracle/OracleHomes/oms10g ${s_encrreposDBAPwd} (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOC
OL=TCP)(HOST=oem.kccmalls.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=emrep.kccmalls.com)))

/u01/app/oracle/OracleHomes/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST
=(ADDRESS=(PROTOCOL=TCP)(HOST=oem.kccmalls.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=emrep.kccmalls.co
m))) -sys_password **** -repos_user sysman -repos_password ******** -action upgrade -verbose

RepManager was not able to run successfully.

Please see /u01/app/oracle/OracleHomes/oms10g/cfgtoollogs/appsemca-2010-7-6_15-558.out for more details.

Execution of the plugin was aborted
INFO: Configuration assistant "APPS plugin Repository Upgrade Assistant" was canceled.
INFO: The "/u01/app/oracle/OracleHomes/oms10g/cfgtoollogs/configToolFailedCommands" script contains all c
ommands that failed, were skipped or were cancelled. This file may be used to run these configuration ***
istants outside of OUI. Note that you may have to update this script with passwords (if any) before execu
ting the same.
INFO: Created a new file /u01/app/oracle/OracleHomes/oms10g/cfgtoollogs/configToolFailedCommands
INFO: Since the option is to overwrite the existing /u01/app/oracle/OracleHomes/oms10g/cfgtoollogs/config
ToolFailedCommands file, backing it up
INFO: The backed up file name is /u01/app/oracle/OracleHomes/oms10g/cfgtoollogs/configToolFailedCommands.
bak
SEVERE: OUI-25031:Some of the configuration assistants failed. It is strongly recommended that you retry
the configuration assistants at this time. Not successfully running any "Recommended" assistants means yo
your system will not be correctly configured.
1. Check the Details panel on the Configuration Assistant Screen to see the errors resulting in the failu
res.
2. Fix the errors causing these failures.
3. Select the failed assistants and click the 'Retry' button to retry them.
INFO: User Selected: Yes/OK


Log: /u01/app/oracle/OracleHomes/oms10g/cfgtoollogs/appsemca-2010-7-6_15-558.out

Getting temporary tablespace from database...
Found temporary tablespace: TEMP
Environment :
ORACLE HOME = /u01/app/oracle/OracleHomes/oms10g
REPOSITORY HOME = /u01/app/oracle/OracleHomes/oms10g
SQLPLUS = /u01/app/oracle/OracleHomes/oms10g/bin/sqlplus
SQL SCRIPT ROOT = /u01/app/oracle/OracleHomes/oms10g/sysman/admin/emdrep/sql
EXPORT = /u01/app/oracle/OracleHomes/oms10g/bin/exp
IMPORT = /u01/app/oracle/OracleHomes/oms10g/bin/imp
LOADJAVA = /u01/app/oracle/OracleHomes/oms10g/bin/loadjava
JAR FILE ROOT = /u01/app/oracle/OracleHomes/oms10g/sysman/admin/emdrep/lib
JOB TYPES ROOT = /u01/app/oracle/OracleHomes/oms10g/sysman/admin/emdrep/bin
Arguments :
Connect String = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oem.kccmalls.com)(PORT=152
1)))(CONNECT_DATA=(SERVICE_NAME=emrep.kccmalls.com)))
Action = upgrade
Repos User = SYSMAN
Default tablespace = MGMT_TABLESPACE
Default Data file = mgmt.dbf
Dflt Dfile Init size = 20m
Dflt Dfile Ext size = 20m
ECM tablespace = MGMT_ECM_DEPOT_TS
ECM Data file = mgmt_ecm_depot1.dbf
ECM Dfile Init size = 100m
ECM Dfile Ext size = 100m
ECM CSA tablespace = MGMT_TABLESPACE
ECM CSA Data file = mgmt_ecm_csa1.dbf
ECM CSA Dfile Init size = 100m
ECM CSA Dfile Ext size = 100m
TEMP tablespace = TEMP
Create options = 3
Verbose output = 1
Output File = /u01/app/oracle/OracleHomes/oms10g/sysman/log/emrepmgr.log.10108
Repos creation mode = CENTRAL
MyOracleSupport user name = _NOT_AVAILABLE_
MyOracleSupport URL = 
Export Directory = /u01/app/oracle/OracleHomes/oms10g/sysman/log
Import Directory = /u01/app/oracle/OracleHomes/oms10g/sysman/log
Path Separator = :
Checking SYS Credentials ... rem error switch
ECM CSA Dfile Init size = 100m
ECM CSA Dfile Ext size = 100m
TEMP tablespace = TEMP
Create options = 3
Verbose output = 1
Output File = /u01/app/oracle/OracleHomes/oms10g/sysman/log/emrepmgr.log.10108
Repos creation mode = CENTRAL
MyOracleSupport user name = _NOT_AVAILABLE_
MyOracleSupport URL = 
Export Directory = /u01/app/oracle/OracleHomes/oms10g/sysman/log
Import Directory = /u01/app/oracle/OracleHomes/oms10g/sysman/log
Path Separator = :
Checking SYS Credentials ... rem error switch
Return code = 0.OK.
rem error switch
Upgrading the repository..
Checking for Repos User ... Return code = 0.Exists.
Verifying Audit Master Table --> Passed
Verifying Time Coefficient Table --> Didn't Pass
Verifying SYSMAN Referential Integrity --> Passed
Verifying SYSMAN Trigger Check --> Passed
Verifying Max Enabled Roles --> Passed
Verifying Global User Context --> Passed
Verifying Exempt Access Policy --> Passed
Verifying SYSMAN Queue Tables Check --> Passed
Verifying VPD Basic Policy Function --> Passed
Verifying VPD Valid Policy Function --> Passed

SANITY VIOLATION Verification has not passed for schema upgrade
to ensure basic sanity conditions of the SYSMAN schema.
There are the following violations:
Schema Sanity Violation: Time Coefficient Table is expected 1 row but contains 0 row
Please contact Oracle Support for schema validations
before attempting to perform schema upgrade


Any help much appreciated.

Regards,

Cyrus
Re: Installation of Application Management Pack 3 Failed [message #465565 is a reply to message #464107] Wed, 14 July 2010 15:42 Go to previous message
LKBrwn_DBA
Messages: 436
Registered: July 2003
Location: WPB, FL
Senior Member
This is your answer:

xhyrruz wrote on Tue, 06 July 2010 06:19

SANITY VIOLATION Verification has not passed for schema upgrade
to ensure basic sanity conditions of the SYSMAN schema.
There are the following violations:
Schema Sanity Violation: Time Coefficient Table is expected 1 row but contains 0 row
Please contact Oracle Support for schema validations
before attempting to perform schema upgrade

[Updated on: Thu, 29 July 2010 11:58] by Moderator

Report message to a moderator

Previous Topic: EM NO STARTS
Next Topic: Multiple DBConsole service not up and running on server reboot....
Goto Forum:
  


Current Time: Wed Sep 17 18:47:25 CDT 2014

Total time taken to generate the page: 0.20714 seconds