Some times we see “Mismatched records” from AWS DMS validation.
To check what records are mismatching between Source and Target database.
Subscribe to get access
Read more of this content when you subscribe today.
Category: Premium Content
FAST_START_PARALLEL_ROLLBACK for SMON to Rollback Transactions Slowly
There are situations when parallel transaction recovery is not as fast as serial transaction recovery because the PQ slaves may interfere with each others by contending for the same resource.
SMON and parallel query slaves may be seen to take all the available CPUs.
Subscribe to get access
Read more of this content when you subscribe today.
DBCA: DISPLAY not set. Set DISPLAY environment variable, then re-run.
Logon as non-oracle user “scott”, then sudo to oracle database user “oracle”. Try to run “dbca” with below errors:
$ ./dbca DISPLAY not set. Set DISPLAY environment variable, then re-run. $ xclock Error: Can't open display:
Please subscribe to get access
Read more of this content when you subscribe today.
srvctl failed to start up local listener
SYMPTOMS
After server rebooted, all Oracle Grid Infrastructure ( GI ) resources are up running as expected except local listener. Try to manually start up local listener, then get the following error messages.
$ srvctl start listener -node racnode1 PRCR-1013 : Failed to start resource ora.LISTENER.lsnr PRCR-1064 : Failed to start resource ora.LISTENER.lsnr on node racnode1 ... .. . CRS-2674: Start of 'ora.LISTENER.lsnr' on 'racnode1' failed
Subscribe to get access
Read more of this content when you subscribe today.
ORA-01275: Operation DROP LOGFILE is not allowed
Try to drop standby redo groups and then recreate them, get below errors:
SQL> alter database drop logfile group 1;
alter database drop logfile group 1
*
ERROR at line 1:
ORA-01275: Operation DROP LOGFILE is not allowed
if standby file management is automatic.
Subscribe to get access
Read more of this content when you subscribe today.
Make DBA Life Easy 