Question & Answer
Question
Does the ORA-00955 message during a migration to 7.2.1 mean possible database corrupting?
Answer
In the DbMessages.log, there are a lot of messages like: ORA-00955: name is already used by an existing object
example:
2011-05-06 14:32:57,379 operation.SqlExecutor - Action [id=17832, orderNumber=15] executed on 2011-5-6.13.51. 43. 0 on object DP_SC in execution phase number 4
migration.execute_sql: Error during executing dynamic SQL - ORA-00955: name is already used by an existing object
This is not necessarily an error, but is a informative message to what the code is doing.
Here is a bit more information to what the installer is doing when it throws those errors.
There were some tables that were added in one of the 7.2.0 fixpack's that were not present in the TADDM 7.2 GA code.
7.2.1 base code now tries to create them during the migration, but since they already exist it just shows the above message and renamed those tables as in the example below. New tables are then created and taddm copies the data into those.
2011-05-06 14:32:57,379 operation.SqlExecutor - Action [id=17832, orderNumber=15] executed on 2011-5-6.13.51. 43. 0 on object DP_SC in execution phase number 4
migration.execute_sql: Error during executing dynamic SQL - ORA-00955: name is already used by an existing object
Additional details
CREATE TABLE DP_SC( PK__JDOIDX VARCHAR2(192) NOT NULL, PK__SENSORCONFIGURATIONS_X VARCHAR2(192) NOT NULL, JDOORDERX NUMBER NOT NULL)
Operation SQL
CREATE TABLE DP_SC( PK__JDOIDX VARCHAR2(192) NOT NULL, PK__SENSORCONFIGURATIONS_X VARCHAR2(192) NOT NULL, JDOORDERX NUMBER NOT NULL)
Product Synonym
taddm ;5724n5500
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21499487