15.12.10

SAP Note 13538 - ORA955 dur. 6 -> 7 migration: SYSTEM_PRIVILEGE_MAP

Symptom:

ORAINST terminates with ORA-00955 during ORACLE migration
after restarting step 2 at CREATE TABLE SYSTEM_PRIVILEGE_MAP.

Cause and prerequisites

Due to the restart, the system to create a table that has already
been created. The script $ORACLE_HOME/dbs/migrate.bsq is missing
the semicolons after the statements
DROP TABLE SYSTEM_PRIVILEGE_MAP
DROP TABLE TABLE_PRIVILEGE_MAP
DROP TABLE STMT_AUDIT_OPTION_MAP

Solution
Add the 3 missing ";" characters.

Key word: ORA955

2 comments:

  1. Your Blog was Excellent. Information about SAP OS DB MIGRATION ONLINE TRAINING is really worth for the readers. Please feel free to redistribute in aid of providing useful information to a wider
    audience. As a migration always means a planned downtime and is a very special phase in the life of an SAP system, ease of use and a save process are more important than reducing the downtime to the absolute minimum. The most important recommendation we would like to provide is to use only the optimizations

    SAP OS DBMIGRATION ONLINE TRAINING

    ReplyDelete
  2. SAP OS DB Migration Check minimizes technical risk involved in an operating system and/or database migration and avoids unforeseen costs that can occur during the SAP OS DB MIGRATION ONLINE TRAINING.
    SAP OS DB MIGRATION ONLINE TRAINING

    ReplyDelete