Hi,
The import job has stopped after the below error. Could you please share your thoughts on this?
my findings
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
Failing sql is:
GRANT UPDATE ON "DRDL"."PLAN_ACCT_FORECAST_REP" TO "DRDL"
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "SYS"."SYS_IMPORT_SCHEMA_03" stopped due to fatal error at 16:29:40
ORA-39014: One or more workers have prematurely exited.
I found following errors in the alert log file.
Wed Dec 30 16:22:07 2015
Errors in file /oradata01/cnq/admin/bdump/cnq_dw01_36260630.trc:
ORA-01114: IO error writing block to file 201 (block # 275778)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 253952
ORA-01114: IO error writing block to file 201 (block # 275778)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 253952
ORA-01114: IO error writing block to file 201 (block # 275778)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 253952
ORA-01114: IO error writing block to file 201 (block # 275778)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 253952
ORA-01114: IO error writing block to file 201 (block # 275716)
ORA-27063: number of by
Wed Dec 30 16:27:09 2015
Thread 1 cannot allocate new log, sequence 72195
Private strand flush not complete
Current log# 1 seq# 72194 mem# 0: /oradata01/cnq/ampsprd_redo_01a.rdo
Current log# 1 seq# 72194 mem# 1: /oradata01/cnq/ampsprd_redo_01b.rdo
Thread 1 advanced to log sequence 72195
Current log# 3 seq# 72195 mem# 0: /oradata01/cnq/ampsprd_redo_03a.rdo
Current log# 3 seq# 72195 mem# 1: /oradata01/cnq/ampsprd_redo_03b.rdo
I found following errors in the trace file /oradata01/cnq/admin/bdump/cnq_dw01_36260630.trc
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
Failing sql is:
GRANT ALTER ON "sadm"."PLAN_ACCT_FORECAST_REP" TO "sadm"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
Failing sql is:
GRANT DELETE ON "sadm"."PLAN_ACCT_FORECAST_REP" TO "sadm"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
Failing sql is:
GRANT INSERT ON "sadm"."PLAN_ACCT_FORECAST_REP" TO "sadm"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
Failing sql is:
GRANT SELECT ON "sadm"."PLAN_ACCT_FORECAST_REP" TO "sadm"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
Failing sql is:
GRANT UPDATE ON "sadm"."PLAN_ACCT_FORECAST_REP" TO "sadm"
ksedmp: internal or fatal error
ORA-01114: IO error writing block to file 201 (block # 275778)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 253952
ORA-01114: IO error writing block to file 201 (block # 275778)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 253952
ORA-01114: IO error writing block to file 201 (block # 275778)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 253952
ORA-01114: IO error writing block to file 201 (block # 275778)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 253952
ORA-01114: IO error writing block to file 201 (block # 275716)
ORA-27063: number of by
No current SQL statement being executed.
import command used
nohup impdp \'/ as sysdba \' directory=DATAPUMP_DIR dumpfile=exp_SADM_ampsprd.dmp logfile=impdp_SADM_prd_dmp_30122015.log schemas=SADM &
dump file size -- 68 GB
import type -- schema import
file system details
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/orabkup01-ampsc 24.00 23.94 1% 53 1% /orabkup01/cnq
/dev/cnq 544.50 92.61 83% 24301 1% /cnq
/dev/oraarch01-ampsc 82.00 31.27 62% 162 1% /oraarch01/cnq
Oracle -- 10.2.0.1.0
OS -- AIX
This is standalone DB
This is Dev DB
Regards,
Bala