8.1.1.11 IRM : Error executing statement () in file (rename_existing_repositories.sql) (Doc ID 1600245.1)

Last updated on DECEMBER 01, 2016

Applies to:

Siebel Communications Call Center - Version 8.1.1.11 [23030] and later
Siebel CRM - Version 8.1.1.11 [23030] and later
Information in this document applies to any platform.

Symptoms

Upgrade from 8.1.1.7 SIA to 8.1.1.11 SIA.

When trying to run DB Config Wizard in Windows, for IRM upgrep - dev mode, the following error is seen in upgwiz.log files,

UpgradeLog UpgradeInfo 3 00000002528106c8:0 2013-11-12 05:57:08 Successfully connected to database.
UpgradeLog UpgradeInfo 3 00000002528106c8:0 2013-11-12 05:57:08 Status Message (SIEBEL)
UpgradeLog UpgradeInfo 3 00000002528106c8:0 2013-11-12 05:57:08 Database Information:
UpgradeLog UpgradeInfo 3 00000002528106c8:0 2013-11-12 05:57:08 DBMS Name:(Oracle)
UpgradeLog UpgradeInfo 3 00000002528106c8:0 2013-11-12 05:57:08 DBMS Version:(11.02.0000 Oracle 11.2.0.2.0)
UpgradeLog UpgradeInfo 3 00000002528106c8:0 2013-11-12 05:57:08 Server Name:(SCRMDEV2)
UpgradeLog UpgradeInfo 3 00000002528106c8:0 2013-11-12 05:57:08 Data source Name:(SCRMDEV2)
UpgradeLog UpgradeInfo 3 00000002528106c8:0 2013-11-12 05:57:08 Status Message (Executing SQL statements in file F:\sblmoc\dbsrvr\oracle\upgrade\v8_1_1sia\rename_existing_repositories.sql ...)
Trace Trace 3 00000002528106c8:0 2013-11-12 05:57:08 Unable to open file 'rename_existing_repositories.sql'.
UpgradeLog UpgradeError 1 00000002528106c8:0 2013-11-12 05:57:08 Error in function UTLStartSqlStmtAPI
UpgradeLog UpgradeError 1 00000002528106c8:0 2013-11-12 05:57:08 Error executing statement () in file (rename_existing_repositories.sql).
UpgradeLog UpgradeInfo 3 00000002528106c8:0 2013-11-12 05:57:08 Close database connection.
UpgradeLog UpgradeError 1 00000002528106c8:0 2013-11-12 05:57:08 Execute SQL file action failed.

STEPS:
----------

1) installed 8.1.1.11 , follow all steps from Upgrade guide and run upgrep, dev mode
2) it fails with the error mentioned

Other symptom is that you also notice following in master_upgrep_dev_<version>.ucf on Unix platform as below:

Repeat For Language = ld.so.1: sqlgenval: fatal: libmfc400su.so: open failed: No such file or directory

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms