Wednesday, December 12, 2018

ORA-16664: unable to receive the result from a database with ORA-12514

We have received below error when trying to enabling Data guard Broker configuration

Error: ORA-16664: unable to receive the result from a database
Dataguard broker log has below errors

Failed to connect to remote database sat. Error is ORA-12514
Failed to send message to member sat. Error code is ORA-12514.


To identify the issue review the confirmation

DGMGRL> SHOW CONFIGURATION;
Configuration - orcl_dgbroker_fsfconf
Protection Mode: MaxAvailability
Members:
orcl - Primary database
orcl_stdby - Physical standby database
Error: ORA-16664: unable to receive the result from a member

Fast-Start Failover: DISABLED

DGMGRL> show database verbose 'ORCL';
Database - ORCL
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
ORCL
Properties:
DGConnectIdentifier = 'ORCL'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
RedoRoutes = ''
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DataGuardSyncLatency = '0'
DbFileNameConvert = ''
LogFileNameConvert = 'dummy, dummy'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
PreferredObserverHosts = ''
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1.oracleracexpert.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL_DGMGRL)(INSTANCE_NAME=ORCL)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/oraarch/ORCL'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'arch_ORCL_%r_%s_%t.arc'
TopWaitEvents = '(monitor)'

Log file locations:
Alert log : /oracle/diag/rdbms/ORCL/ORCL/trace/alert_ORCL.log
Data Guard Broker log : /oracle/diag/rdbms/ORCL/ORCL/trace/drcORCL.log

Database Status:
SUCCESS

DGMGRL> show database verbose 'ORCL_stdby';
Database - ORCL_stdby
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Active Apply Rate: (unknown)
Maximum Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
ORCL
Properties:
DGConnectIdentifier = 'ORCL_stdby'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
RedoRoutes = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DataGuardSyncLatency = '0'
DbFileNameConvert = ''
LogFileNameConvert = 'dummy, dummy'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
PreferredObserverHosts = ''
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)HOST=node2.oracleracexpert.com)(PORT=1521))(CONNECT_DATA=SERVICE_NAME=ORCL_STDBY_DGMGRL)(INSTANCE_NAME=ORCL)SERVER=DEDICATED)))'
StandbyArchiveLocation = '/oraarch/ORCL'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'arch_ORCL_%r_%s_%t.arc'
TopWaitEvents = '(monitor)'

Log file locations:
(Failed to retrieve log file locations.)
Database Status:
DGM-17016: failed to retrieve status for database "ORCL_stdby"
ORA-16664: unable to receive the result from a member


Solution:

1. Makes sure you have Static listener entry has SID_DGMGRL

cat $ORACLE_HOME/network/admin/listener.ora

(SID_DESC =
(GLOBAL_DBNAME = ORCL_DGMGRL) <----------------add _DGMGRL
(ORACLE_HOME = /<oracle_home>)
(SID_NAME = ORCL)
)

2. Same way change the static entry of current primary also for feature role transition. For non-default port set the local listener on the respective database where ORA-12514 was thrown.

SQL>alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostIP>)(PORT=port)))';

Refer Below oracle notes for more scenarios
1. Causes and Solutions for DGMGRL ORA-16664 (Data Guard Broker) (Doc ID 2494260.1) 

Regards
Satishbabu Gunukula

8 comments:

  1. من اجود وارخص الشركات التي توجد في منطقة مكة المكرمة والتي تعمل في مجال نقل العفش مع الفك والتركيب تلك الشركة الجيدة التي تقدم خدمات جيدة وتسمى افضل شركة نقل عفش بجدة ايضا وهي التي تختص بنقل العفش من بيت الى بيت آخر في مدينة جدة وما جاورها من مناطق تابعة لها
    وايضا من افضل شركات نقل العفش مع الفك والتركيب تلك التي توجد في العاصمة المقدسة مكة المكرمة وقد نالت شركة نقل اثاث بمكة شهرة واسعة لأنها تعتمد على اساليب حديثة في اعمال نقل العفش مع الفك والتركيب
    وفي مدينة الطائف تطورت خدماتنا واصبحنا نقدم خدمات جيدة في اعمال نقل العفش مع الفك والتركيب ولهذا السبب اصبحت شركتنا
    شركه نقل عفش بالطائف من افضل واحسن واقوى شركات النقل في مدينة الطائف فلو تريد نقل عفش بيتك وانت في الطائف تواصل معنا

    ReplyDelete
  2. Excellent post! I must thank you for this informative read. I really enjoyed reading it,c you’re a great author.Please visit here @ Local Packers And Movers Bangalore

    ReplyDelete
  3. عزل الحمامات بالقار خطوات التنفيذ
    يقوم المهندسين بتسييح مادة البيتومين أو ما يعرف بمادة القار في براميل كبيرة الحجم وهذه المادة هي البلاك الأسود ويتم تسييح هذه المادة من أجل استخدامها في عزل الحمامات، ويتم اضافتها بعد ذلك الي أرضية الحمام وعمل طبقه سميكة لمنع تسرب المياه وحدوث التشققات بالحمام أو بالمنزل ككل.

    ويعتبر طريقة عزل الحمامات بالقار من أسهل طرق العزل وأشهرها، حيث يتم تغطية أرضية الحمامات بالخيش المقطرن عن طريق اذابة براميل البلاك الأسود وتغطي به الارضيات ثم يتم وضع طبقة من الخيش ثم وضع عدة طبقات اخري.

    لمنع التسربات التي تحدث داخل الحمام والمطبخ وعزل الحمامات بالقار الجانب السلبي لطريقة العزل بالقار حيث أن مادة البيتومين تسبب تلوث للبيئة نتيجة حرقها في براميل.

    أتمنى ان ينال مقال طرق عزل المسابح الاعجاب ومتابعة طرق عزل فوم للاسطح المنازل وخزانات مياه الشرب ضد تسرب المياه ومياه الامطار والسيول.
    شركة إنشاء مسابح بالدمام
    شركة تنظيف مسابح بالدمام
    عزل مسابح

    ReplyDelete
  4. thanks for this article, i lost 1 day for to find a solution

    ReplyDelete
  5. KVS Board 8th Model Paper 2023 Available Students you can Download in Pdf format form this web page below given links. Kendriya Vidyalaya Sangathan Regular Students Prepare their Exams from these Sample Papers 2023, Students have to Register for Appearing in Annual Exam 2023. So if you are also among those students who have Registered them self as a Regular Student are Suggested to Download these Model Papers 2023 of KVS Board High School must Prepare all Subjects. Model Paper 2023 is very helped full Material that is Provided by the official education Board. KVS 8th Class Question Paper 2023 Kendriya Vidyalaya (KVS) High School Previous Paper 2023 are very important for the Preparation of annual Exams of Primary School for the Students. 8th Students of Kendriya Vidyalaya can easily get their Latest and most valuable Model Papers 2023 from this website. Students only have to Download the KVS High School Model Paper 2023 for all the important subjects are available Including the English, Hindi, Sanskrit, Maths, Science, Social Studies.

    ReplyDelete