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:
- Remove any
*.dmp
files from the directory referenced by theDATA_PUMP_DIR
alias. - Verify the
backup.properties
file and correct any errors. - Re-run
applySnapshot.sh
.<path>/backup.properties
Failures running applySnapshot.sh
If the OAM domain only restore fails when using OPERATION=RESTORE
then:
- Delete the directory
$ORACLE_HOME/user_projects
. - Verify the
restore.properties
file and correct any errors. - Re-run
applySnapshot.sh
.<path>/restore.properties
OPERATION=MIGRATE
then:
- 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;
- Delete the directory
$ORACLE_HOME/user_projects
. - Verify the
restore.properties
file and correct any errors. - 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:
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:
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;