000013724 - AM 7.1.X - unable to import database  ORA-39097: Data Pump job encountered unexpected error -1089

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000013724
Applies ToAuthentication Manager 7.1 (all revisions)
All OS
rsautil manage-database -a import -r -D -f <File location/File Name> -V -q
-System altered.
-
-Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 6 4bit Production
-With the Partitioning, Data Mining and Real Application Testing options
Flashback is completed
Operation failed : com.rsa.common.UnexpectedDataStoreException: com.rsa.ims.comm on.oracle.OracleException:
Please see log file at /tmp/IMS_DB_IMPORT_<step>_<time_stamp>.log for more detai ls.
com.rsa.common.SystemException: com.rsa.common.UnexpectedDataStoreException: com .rsa.ims.common.oracle.OracleException: ORA-39083: Object type OBJECT_GRANT fail ed to create with error:
at com.rsa.admin.tools.impl.OracleDatabaseBackupManager.restoreDatabase( OracleDatabaseBackupManager.java:273)
at com.rsa.admin.tools.ManageBackupCLU.performExecute(ManageBackupCLU.ja va:567)
at com.rsa.admin.tools.ManageBackupCLU.main(ManageBackupCLU.java:233)
Caused by: com.rsa.common.UnexpectedDataStoreException: com.rsa.ims.common.oracl e.OracleException: ORA-39083: Object type OBJECT_GRANT failed to create with err or:
at com.rsa.admin.tools.impl.OracleDatabaseBackupManager.importDatabase(O racleDatabaseBackupManager.java:559)
at com.rsa.admin.tools.impl.OracleDatabaseBackupManager.restoreDatabase( OracleDatabaseBackupManager.java:263)
IssueAM 7.1.X - unable to import database, ORA-39097: Data Pump job encountered unexpected error -1089

When trying to restore from either the command line or from the operations console, the following error appears in the IMS restore log

ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."IMS_ADMIN_ROLE" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."IMS_GROUP" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."IMS_GROUP_DATA" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."IMS_SECURITY_DOMAIN" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."IMS_PRINCIPAL_DATA" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."IMS_PRINCIPAL_ADMIN_ROLE" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."IMS_IDENTITY_SOURCE" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."IMS_PRINCIPAL_GROUP" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."IMS_PRINCIPAL" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_LOGREP"."IMS_LOG_AUDIT_ADM" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_LOGREP"."IMS_LOG_AUDIT_RT" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_LOGREP"."IMS_LOG_SYSTEM" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_BATCHREP"."IMS_PRINCIPAL_LOGIN_DATE" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."AM_TOKEN" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."AM_AGENT" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."AM_AGENT_GROUP" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."AM_HOST" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."AM_PRINCIPAL" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."AM_TOKEN_REPLACEMENT" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_BATCHREP"."AM_TOKEN_OOB" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."AM_SW_TOKEN_DEVICE_TYPES" TO "REPUSER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REPUSER' does not exist
Failing sql is:
GRANT SELECT ON "RSA_REP"."AM_TOKEN_TYPES" TO "REPUSER"
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
ORA-39097: Data Pump job encountered unexpected error -1089
ORA-39065: unexpected master process exception in MAIN
ORA-01089: immediate shutdown in progress - no operations are permitted
Job "SYS"."IMS_DB_IMPORT_STEP1_2011120517" stopped due to fatal error at 18:01:10

CauseA read only account for sql database access was added to the instance that the backup was taken from
Resolution

You must recreate the read only account indicated in this as "REPUSER" before you can restore

rsautil manage-database -a create-readonly-user -r [username] -p [password]

for this example

rsautil manage-database -a create-readonly-user -r repuser -p repuser#

Legacy Article IDa56736

Attachments

    Outcomes