If issuing “crsctl status
resource” command show the status of listener as “Not All Endpoints Registered”,
it is usually because of contradictions in the Listener settings. It means that
probably you have a manually setup listener (by editing listener.ora file) with
different settings than registered with the CRS/HAS. Or, there could be
multiple listeners configured from multiple oracle homes – one from Grid
Infrastructure home, and other listener with same configuration running from
other home and started manually (using lsnrctl command).
Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.
Monday, May 18, 2020
Tuesday, May 5, 2020
DBMS_AW_EXP: BIN$ZRGxDTT9TumIWFOmM0qIHQ==$0 not AW$
If you see any similar messages during
expdp, you may ignore these messages. Alternatively, you may purge the
recyclebin and initiate the expdp again. Issue “purge dba_recyclebin” from
SQLPUS. The messages displayed in expdp log are as follows.
Saturday, May 2, 2020
Initialization parameter setting back to original value
I faced a very strange
situation whereby I was setting my log_archive_dest_1 parameter using ALTER
SYSTEM command with SCOPE=BOTH, which meant that this parameter value change
should have been consistent across the instances reboot as this change was also
being made in the spfile (SPFILE was in use for that database/instance) as well
as in memory. However, it was not happening actually. After every instance
restart, the value of this parameter would again set to the old value and this
was causing problems for us.