48 Troubleshooting

Troubleshoot failures running the createSnapshot.sh and applySnapshot.sh scripts.

Failures running createSnapshot.sh

If the OAM domain and database schemas backup fails when using OPERATION=MIGRATE then:

1. Remove any *.dmp files from the directory referenced by the DATA_PUMP_DIR alias.
2. Verify the backup.properties file and correct any errors.
3. Re-run applySnapshot.sh <path>/backup.properties.

Failures running applySnapshot.sh

If the OAM domain only restore fails when using OPERATION=RESTORE then:

1. Delete the directory $ORACLE_HOME/user_projects.
2. Verify the restore.properties file and correct any errors.
3. Re-run applySnapshot.sh <path>/restore.properties.

If the OAM domain and database schemas restore fails when using OPERATION=MIGRATE then:

1. In SQLPlus connect to the target database as the SYS user and run:

   drop user <SCHEMA_PREFIX>_STB cascade ;
   drop user <SCHEMA_PREFIX>_IAU_APPEND cascade ;
   drop user <SCHEMA_PREFIX>_IAU_VIEWER cascade ;
   drop user <SCHEMA_PREFIX>_MDS cascade ;
   drop user <SCHEMA_PREFIX>_WLS cascade ;
   drop user <SCHEMA_PREFIX>_WLS_RUNTIME cascade ;
   drop user <SCHEMA_PREFIX>_IAU cascade ;
   drop user <SCHEMA_PREFIX>_OPSS cascade ;
   drop user <SCHEMA_PREFIX>_OAM cascade ;
   drop tablespace <SCHEMA_PREFIX>_OAM INCLUDING CONTENTS AND DATAFILES;
   drop tablespace <SCHEMA_PREFIX>_IAU INCLUDING CONTENTS AND DATAFILES;
   drop tablespace <SCHEMA_PREFIX>_IAU_APPEND INCLUDING CONTENTS AND DATAFILES;
   drop tablespace <SCHEMA_PREFIX>_MDS INCLUDING CONTENTS AND DATAFILES;
   drop tablespace <SCHEMA_PREFIX>_OPSS INCLUDING CONTENTS AND DATAFILES;
   drop tablespace <SCHEMA_PREFIX>_IAS_OPSS INCLUDING CONTENTS AND DATAFILES;
   drop tablespace <SCHEMA_PREFIX>_WLS INCLUDING CONTENTS AND DATAFILES;
   drop tablespace <SCHEMA_PREFIX>_WLS_RUNTIME INCLUDING CONTENTS AND DATAFILES;
   drop tablespace <SCHEMA_PREFIX>_IAU_VIEWER INCLUDING CONTENTS AND DATAFILES;
   drop tablespace <SCHEMA_PREFIX>_STB INCLUDING CONTENTS AND DATAFILES;
   

2. Delete the directory $ORACLE_HOME/user_projects.
3. Verify the restore.properties file and correct any errors.
4. Re-run createSnapshot.sh <path>/restore.properties.

The createSnapshot.sh and applySnapshot.sh Scripts Hang

During the export or import of the database schemas while using Operation=Migrate, the scripts createSnapshot.sh and applySnapshot.sh appear to hang.

The export and import of database schemas take time to complete based on the amount of data. The hardcoded two minute delay specified in the scripts is to avoid overloading the database. It does not affect the time to export or import database schemas.

Database Migrate Using the Snapshot Tools Fails to Create schema_version_registry Table/Entries in Target Environment

Before running the createSnapshot.sh script, perform the following:

Connect to the source database as sys or system user and run the following SQL command:

create table <SCHEMA_PREFIX>_OAM.SCHEMA_VERSION_REGISTRY as select * from SYSTEM.SCHEMA_VERSION_REGISTRY$ where MRC_NAME = '<SCHEMA_PREFIX>'

where <SCHEMA_PREFIX> is the SCHEMA_PREFIX used for creating the RCU.

After running the applySnaphost.sh script, perform the following:

Connect to the target database as sys or system user and run the following SQL commands:

insert into SYSTEM.SCHEMA_VERSION_REGISTRY$ select * from REL2_OAM.SCHEMA_VERSION_REGISTRY;
drop table REL1_OAM.SCHEMA_VERSION_REGISTRY;