This discussion is archived
4 Replies Latest reply: Jun 6, 2012 10:51 PM by MahirM.Quluzade RSS

dgmgrl Error: ORA-16664: unable to receive the result from a database

778791 Newbie
Currently Being Moderated
PRIMARY=QA112PRG
STANDBY=QA112STB
configuring databse with dgmgrl

DGMGRL> show configuration

Configuration - PRIMARY

Protection Mode: MaxPerformance
Databases:
QA112PRG - Primary database
QA112STB - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED

DGMGRL> enable configuration
Enabled.

DGMGRL> show configuration

Configuration - PRIMARY

Protection Mode: MaxPerformance
Databases:
QA112PRG - Primary database
QA112STB - Physical standby database
Error: ORA-16664: unable to receive the result from a database

Fast-Start Failover: DISABLED

Configuration Status:
ERROR
DGMGRL> show database verbose 'QA112PRG';

Database - QA112PRG

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
QA112PRG

Properties:
DGConnectIdentifier = 'QA112PRG'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'MANUAL'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'pun-lpar-btk01.bmc.com'
SidName = 'QA112PRG'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pun-lpar-btk01.bmc.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=QA112PRG_DGMGRL)(INSTANCE_NAME=QA112PRG)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/qa/data/obt/QA112PRG/admin/arch/'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.log'
TopWaitEvents = '(monitor)'

Database Status:
SUCCESS

DGMGRL> show database verbose 'QA112STB';

Database - QA112STB

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: (unknown)
Real Time Query: OFF
Instance(s):
QA112STB

Properties:
DGConnectIdentifier = 'QA112STB'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '/qa/data/obt/QA112PRG/data, /qa/data/obt/QA112PRG/data'
LogFileNameConvert = '/qa/data/obt/QA112PRG/data, /qa/data/obt/QA112PRG/data'
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'pun-btk-aix02.bmc.com'
SidName = 'QA112STB'
StaticConnectIdentifier = 'QA112STB'
StandbyArchiveLocation = '/qa/data/obt/QA112PRG/data/archive'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.log'
TopWaitEvents = '(monitor)'

Database Status:
DGM-17016: failed to retrieve status for database "QA112STB"
ORA-16664: unable to receive the result from a database

why these error commming that i dont get?
  • 1. Re: dgmgrl Error: ORA-16664: unable to receive the result from a database
    mseberg Guru
    Currently Being Moderated
    Is it possible your hostname is not set up? If its not on the hosts file is one cause of this error.

    Also check the listener and tnsnames files and ensure that there is no connection problem between the Primary and the Standby.

    Use tnsping and try to connect from SQL Plus on each server to the other database (The standby will bark).

    make sure you have _DGMGRL in your listener file

    Ex

    http://www.visi.com/~mseberg/Data_Guard_Listener_Example.html

    Best Regards

    mseberg

    I noticed later you have this set :
    StandbyFileManagement = 'MANUAL
    But its set to AUTO on the other, I would consider setting them both to AUTO.

    Also your DbFileNameConvert and LogFileNameConvert parameters are set on one but not set on the other, Based on this
    I would strongly consider comparing the INIT's.

    I have had great luck creating my standby from my primary INIT and only changing these parameters on the standby :


    FAL_SERVER

    FAL_CLIENT

    STANDBY_FILE_MANAGEMENT

    DB_UNIQUE_NAME

    DB_FILE_NAME_CONVERT

    LOG_FILE_NAME_CONVERT

    log_archive_dest_1'

    log_archive_dest_2

    LOG_ARCHIVE_DEST_STATE_1

    LOG_ARCHIVE_DEST_STATE_2

    LOG_ARCHIVE_MAX_PROCESSES



    Edited by: mseberg on Jun 16, 2011 5:34 AM
  • 2. Re: dgmgrl Error: ORA-16664: unable to receive the result from a database
    BPeasland Guru
    Currently Being Moderated
    Can you sign on to the Standby as SYS and issue queries against some V$ views? Do you get errors?

    Cheers,
    Brian
  • 3. Re: dgmgrl Error: ORA-16664: unable to receive the result from a database
    JohnM Newbie
    Currently Being Moderated
    I think the issue is that from the standby you cannot connect to the primary. Please logon to the standby server and try and connect to the primary via sql*net. Likely you will get an error, which is why you are seeing this in DG broker.
  • 4. Re: dgmgrl Error: ORA-16664: unable to receive the result from a database
    MahirM.Quluzade Guru
    Currently Being Moderated
    HI,

    Can you try following senario and pste here results:

    1. Add tnsnames.ora QA112PRG, QA112STB on both server (primary and standby).
    2. If you are writing QA112PRG, QA112STB desriptions with hostname you can add servernames and ips to */etc/hosts* file.
    3. Try on both server : tnsping QA112PRG; tnsping QA112STB
    4. Set StandbyFileManagement parameter set 'AUTO' , this help datafile management automatically .
    5. Watch my video : http://www.mahir-quluzade.com/2012/01/overview-data-guard-configuration.html
    (http://www.youtube.com/watch?feature=player_embedded&v=5keahpkzLtM)

    Regards
    Mahir M. Quluzade.
    www.mahir-quluzade.com

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points