Friday, December 14, 2018

ORA-16664 error when using ASM filesystem

We have received ORA-16664: unable to receive the result from a database error when enabling the DataGuard broker config

DGMGRL> show configuration verbose;

Configuration - ORCL_DG

Protection Mode: MaxAvailability
Databases:
orcl - Primary database
orlc_stdby - Physical standby database
Error: ORA-16664: unable to receive the result from a database

1. In one of the senario the problem was in the Primary's REDO_TRANSPORT_USER init parameter
The value for this parameter had weird characters and removing helped.

SQL> show parameter redo_transport

NAME TYPE                               VALUE
------------------------------------ --------------------------------
redo_transport_user string          ???DG_USER???


2. The database is running on ASM and running on ASM and Data Guard Broker configuration files were created locally on filesystem.

In this case drop the existing broker configuration from primary and standby local filesystem and creating on broker configuration on ASM helped.

Regards
Satishbabu Gunukula
http://www.oracleracexpert.com



8 comments:

  1. nice post thanks for sharing amazing post with us.
    easywebplans

    ReplyDelete
  2. Students will get the links to Download All Chapter of CBSE 1st Exemplar 2023, Get here CBSE Class 1 Books 2023 in PDF form. Students can Download the PDF at free of cost and take Advantage of it while Preparing for CBSE Board Exam. India Wide Many State Education Boards and the CBSE Recommend and follow these Textbook 2023’s Syllabus 2023. The Content that CBSE books Provide is what most of the Exam Paper 2023s in the CBSE Curriculum are Based on. CBSE 1st Class Textbook 2023 Students our Website lot of options available for lot of Books and we here are Trying to Provide you with one page that Serves CBSE Class 1 students with free downloadable. All the chapters of CBSE Class 1 Textbook 2023s 2023 are Available for Download. With this Article, Students can Download the Complete Pdf of all Subject English, Environmental Studies, Hindi, Mathematics Chapters Wise. CBSE Exemplar Class 1 Book 2023 are very important for CBSE class 1st Examination 2023.

    ReplyDelete