iSelfSchooling.com - Community of Sharing

Click here for Online Oracle 8i, 9i, 10g, 11g and 12c Training

from www.iSelfSchooling.com

November 18, 2017, 12:24:44 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   Help Search Login Register  
Pages: [1] |   Go Down
  Send this topic  |  Print  
Author Topic: If you get the "Error: ORA-16843" error message, you may have a corrupted ADR.  (Read 37833 times)
AllanDBA
AllanDBA
Newbie
Newbie
*
Posts: 0


« on: August 13, 2015, 08:30:10 AM »

If you get the "Error: ORA-16843" error message, you may have a corrupted ADR.

DGMGRL> show configuration;
Configuration - cmst_dr
  Protection Mode: MaxAvailability
  Members:
  cmst_prim - Primary database
    Error: ORA-16843: errors discovered in diagnostic repository
    cmst_stby - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR   (status updated 28 seconds ago)

Resolution:
Check where the error is. Primary or Standby
# dgmgrl
DGMGRL> show configuration;

Shutdown the database shows the error
# sqlplus /nolog
SQL> shutdown immediate;

Remove the ADR
# cd /app/oracle/diag
# rm -r cmst_prim

Startup the database
# sqlplus /nolog
SQL> startup;

Check the dgmgrl configuration for "SUCCESS."
# dgmgrl
DGMGRL> show configuration;

Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS   (status updated 19 seconds ago)


--admin
Good Luck.
Logged
Pages: [1] |   Go Up
  Send this topic  |  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!