OMS Configfuration failed with missing cremds-rcu.sql file
sunOct 20 2010 — edited Oct 22 2010Hello,
I'm performing a new install of 11g grid control, but observed the OMS failed. After a deeper dive, I noticed the output below which suggests that the cremds-rcu.sql file is missing from the install package. The error is below:
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.io.FileNotFoundException: /oem/Middleware/oms11g/rcu/integration/mds/sql/cremds-rcu.s
ql (No such file or directory)
---------------------------------------------------------------------------
Environment Information:
uname -a:
Linux oramgr 2.6.16.60-0.27-bigsmp #1 SMP Mon Jul 28 13:06:32 UTC 2008 i686 i686 i386 GNU/Linux
SLES10 32bit
---------------------------------------------------------------------------
2010-10-20 15:44:24.732 TRACE rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: Sql command to run: /oem/Middleware/oms11g/rcu/integr
ation/mds/sql/cremds-rcu.sql
2010-10-20 15:44:24.732 TRACE rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: m_bean.getCommandType() = SCRIPT
2010-10-20 15:44:24.733 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: current user=SYS
2010-10-20 15:44:24.733 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: Performing JDBCScript Action Command: /oem/Mid
dleware/oms11g/rcu/integration/mds/sql/cremds-rcu.sql CMDLINE Parameters Length: 1
2010-10-20 15:44:24.733 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::parseNexecuteScript: ParseNexecute Script: /oem/Middlew
are/oms11g/rcu/integration/mds/sql/cremds-rcu.sql
2010-10-20 15:44:24.734 TRACE rcu: oracle.sysman.assistants.rcu.backend.action.AbstractSQLAction::removeLocalErrors: Removing Local Fatal and Ignorable E
rrors
2010-10-20 15:44:24.734 TRACE rcu: oracle.sysman.assistants.rcu.backend.action.AbstractSQLAction::removeLocalErrors: Removing LocalFatal Errors
2010-10-20 15:44:24.734 TRACE rcu: oracle.sysman.assistants.rcu.backend.action.AbstractSQLAction::removeLocalErrors: Removing LocalIgnorable Errors
2010-10-20 15:44:24.734 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::cleanAndLog: RCU-6134:Error while trying to execute J
DBC action. - MDS
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.io.FileNotFoundException: /oem/Middleware/oms11g/rcu/integration/mds/sql/cremds-rcu.s
ql (No such file or directory)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1121)
at oracle.sysman.assistants.rcu.backend.action.JDBCAction.perform(JDBCAction.java:348)
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:243)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:303)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.FileNotFoundException: /oem/Middleware/oms11g/rcu/integration/mds/sql/cremds-rcu.sql (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at java.io.FileInputStream.<init>(FileInputStream.java:66)
at oracle.sysman.assistants.common.dbutil.jdbc.NestedInputReader.<init>(NestedInputReader.java:69)
at oracle.sysman.assistants.common.dbutil.jdbc.SQLScriptReader.<init>(SQLScriptReader.java:66)
at oracle.sysman.assistants.common.dbutil.jdbc.ANSISQLScriptReader.<init>(ANSISQLScriptReader.java:55)
at oracle.sysman.assistants.common.dbutil.jdbc.OracleSQLScriptReader.<init>(OracleSQLScriptReader.java:63)
at oracle.sysman.assistants.common.dbutil.jdbc.SQLScriptReader.getSQLScriptReader(SQLScriptReader.java:356)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1075)
... 4 more
2010-10-20 15:44:24.737 TRACE rcu: oracle.sysman.assistants.rcu.util.RCUCheckpoint::moveComponentToPending: Entering
2010-10-20 15:44:24.737 TRACE rcu: oracle.sysman.assistants.rcu.util.RCUCheckpoint::moveComponentToPending: Moving component to pending list: MDS
2010-10-20 15:44:24.737 TRACE rcu: oracle.sysman.assistants.rcu.util.RCUCheckpoint::moveComponentToPending: Completed action: 1
2010-10-20 15:44:24.737 TRACE rcu: oracle.sysman.assistants.rcu.util.RCUCheckpoint::moveComponentToPending: Statements list size : 0
2010-10-20 15:44:24.738 TRACE rcu: oracle.sysman.assistants.rcu.util.RCUCheckpoint::resetActionAndStatements: Entering.
2010-10-20 15:44:24.738 TRACE rcu: oracle.sysman.assistants.rcu.backend.task.TaskContext::clearSQLEngines: Calling SQLEngine.done()
2010-10-20 15:44:24.739 TRACE rcu: oracle.sysman.assistants.rcu.backend.task.TaskContext::clearSQLEngines: Calling SQLEngine.done()
2010-10-20 15:44:24.742 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6134:Error while trying to execute JDBC action.
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:300)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:303)
at java.lang.Thread.run(Thread.java:619)
Caused by: oracle.sysman.assistants.common.task.ActionFailedException: RCU-6134:Error while trying to execute JDBC action.
at oracle.sysman.assistants.rcu.backend.action.JDBCAction.perform(JDBCAction.java:368)
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:243)
... 2 more
Caused by: oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.io.FileNotFoundException: /oem/Middleware/oms11g/rcu/integration/mds/sql/c
remds-rcu.sql (No such file or directory)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1121)
at oracle.sysman.assistants.rcu.backend.action.JDBCAction.perform(JDBCAction.java:348)
... 3 more
Caused by: java.io.FileNotFoundException: /oem/Middleware/oms11g/rcu/integration/mds/sql/cremds-rcu.sql (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at java.io.FileInputStream.<init>(FileInputStream.java:66)
at oracle.sysman.assistants.common.dbutil.jdbc.NestedInputReader.<init>(NestedInputReader.java:69)
at oracle.sysman.assistants.common.dbutil.jdbc.SQLScriptReader.<init>(SQLScriptReader.java:66)
at oracle.sysman.assistants.common.dbutil.jdbc.ANSISQLScriptReader.<init>(ANSISQLScriptReader.java:55)
at oracle.sysman.assistants.common.dbutil.jdbc.OracleSQLScriptReader.<init>(OracleSQLScriptReader.java:63)
at oracle.sysman.assistants.common.dbutil.jdbc.SQLScriptReader.getSQLScriptReader(SQLScriptReader.java:356)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1075)
... 4 more
Any help would be greatly appreciated.
Thanks in advance,