Hi All,
I have built a Logical standby database and it is in sync with Primary. While configuring DGMGRL, I'm receiving the Error:Error: ORA-16664: unable to receive the result from a database.
I tried so many options for 3-4 days, but there is no positive step.
please help me to resolve this issue.
Please find the details below and let me help me to resolve this issue ASAP. Thanks in advance.
Primary SERVER:
================
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@new-libra-test /u03]$ sqlplus sys/clears_nov15@CLEARS_STANDBY as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 10 14:07:01 2015
SQL> select name ,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
CLEARS READ WRITE LOGICAL STANDBY
[oracle@new-libra-test /u03]$ sqlplus sys/clears_nov15@CLEARS as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 10 14:07:01 2015
SQL> select name ,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
CLEARS READ WRITE PRIMARY
STANDBY SERVER:
================
[oracle@usa0300lv6194 trace]$ sqlplus sys/clears_nov15@CLEARS as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 10 14:11:08 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SQL> select name ,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
CLEARS READ WRITE PRIMARY
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@usa0300lv6194 trace]$ sqlplus sys/clears_nov15@CLEARS_STANDBY as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 10 14:11:41 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name ,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
CLEARS READ WRITE LOGICAL STANDBY
Primary Listener and its status:
========================
[oracle@new-libra-test admin]$ cat listener.ora
LSNR1120 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = new-libra-test.sdsp.mc.xerox.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
SID_LIST_LSNR1120 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = CLEARS)
(ORACLE_HOME = /u03/apps/oracle/product/11.2.0)
(SID_NAME = CLEARS)
)
#DG#
(SID_DESC =
(SID_NAME = CLEARS)
(GLOBAL_DBNAME = CLEARS_DGMGRL)
(ORACLE_HOME = /u03/apps/oracle/product/11.2.0)
)
(SID_DESC =
(SID_NAME = CLEARS)
(ORACLE_HOME = /u03/apps/oracle/product/11.2.0)
(GLOBAL_DBNAME = CLEARS_DGB)
)
(SID_DESC =
(SID_NAME = CLEARS_STANDBY)
(GLOBAL_DBNAME = CLEARS_STANDBY_DGMGRL)
(ORACLE_HOME = /u03/apps/oracle/product/11.2.0)
)
)
[oracle@new-libra-test admin]$ lsnrctl status LSNR1120
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 10-DEC-2015 14:24:33
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=new-libra-test.sdsp.mc.xerox.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LSNR1120
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 10-DEC-2015 13:12:46
Uptime 0 days 1 hr. 11 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u03/apps/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File /u03/apps/oracle/product/diag/tnslsnr/new-libra-test/lsnr1120/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=new-libra-test.sdsp.mc.xerox.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "CLEARQ" has 1 instance(s).
Instance "CLEARQ", status READY, has 1 handler(s) for this service...
Service "CLEARQXDB" has 1 instance(s).
Instance "CLEARQ", status READY, has 1 handler(s) for this service...
Service "CLEARQ_srvs" has 1 instance(s).
Instance "CLEARQ", status READY, has 1 handler(s) for this service...
Service "CLEARS" has 2 instance(s).
Instance "CLEARS", status UNKNOWN, has 1 handler(s) for this service...
Instance "CLEARS", status READY, has 1 handler(s) for this service...
Service "CLEARS_DGB" has 2 instance(s).
Instance "CLEARS", status UNKNOWN, has 1 handler(s) for this service...
Instance "CLEARS", status READY, has 1 handler(s) for this service...
Service "CLEARS_DGMGRL" has 1 instance(s).
Instance "CLEARS", status UNKNOWN, has 1 handler(s) for this service...
Service "CLEARS_STANDBY_DGMGRL" has 1 instance(s).
Instance "CLEARS_STANDBY", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Standby listener and its status:
======================
[oracle@usa0300lv6194 admin]$ cat listener.ora
LSNR1120 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = usa0300lv6194.sdsp.mc.xerox.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_LSNR1120 =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLEARS_STANDBY)
(ORACLE_HOME = /u03/apps/oracle/product/11.2.0)
(GLOBAL_DBNAME = CLEARS_STANDBY)
)
#DG#
(SID_DESC =
(SID_NAME = CLEARS_STANDBY)
(ORACLE_HOME = /u03/apps/oracle/product/11.2.0)
(GLOBAL_DBNAME = CLEARS_STANDBY_DGMGRL)
)
(SID_DESC =
(SID_NAME = CLEARS_STANDBY)
(GLOBAL_DBNAME = CLEARS_STANDBY_DGB)
(ORACLE_HOME = /u03/apps/oracle/product/11.2.0)
)
(SID_DESC =
(SID_NAME = CLEARS)
(GLOBAL_DBNAME = CLEARS_DGMGRL)
(ORACLE_HOME = /u03/apps/oracle/product/11.2.0)
)
)
[oracle@usa0300lv6194 admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 10-DEC-2015 14:25:37
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LSNR1120
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 10-DEC-2015 13:12:11
Uptime 0 days 1 hr. 13 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u03/apps/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File /u03/apps/oracle/product/diag/tnslsnr/usa0300lv6194/lsnr1120/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=usa0300lv6194.sdsp.mc.xerox.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "CLEARS_DGMGRL" has 1 instance(s).
Instance "CLEARS", status UNKNOWN, has 1 handler(s) for this service...
Service "CLEARS_STANDBY" has 2 instance(s).
Instance "CLEARS_STANDBY", status UNKNOWN, has 1 handler(s) for this service...
Instance "CLEARS_STANDBY", status READY, has 1 handler(s) for this service...
Service "CLEARS_STANDBY_DGB" has 2 instance(s).
Instance "CLEARS_STANDBY", status UNKNOWN, has 1 handler(s) for this service...
Instance "CLEARS_STANDBY", status READY, has 1 handler(s) for this service...
Service "CLEARS_STANDBY_DGMGRL" has 1 instance(s).
Instance "CLEARS_STANDBY", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Primary TNSNAMES.ora:
=====================
# tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA.SDSP.MC.XEROX.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.xerox.com)(PROTOCOL = TCP)(Host = new-libra-test.sdsp.mc.xerox.com)(Port = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
)
)
CLEARS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = new-libra-test.sdsp.mc.xerox.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CLEARS_DGMGRL)
(SID = CLEARS)
)
)
CLEARS.SDSP.MC.XEROX.COM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = new-libra-test.sdsp.mc.xerox.com)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = CLEARS)
(SID = CLEARS)
(DB_NAME = CLEARS)
(GLOBAL_NAME = CLEARS.sdsp.mc.xerox.com)
)
)
CLEARS.SDSP.MC.XEROX.COM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = new-libra-test.sdsp.mc.xerox.com)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = CLEARS.sdsp.mc.xerox.com)
(SID = CLEARS)
(GLOBAL_NAME = CLEARS.sdsp.mc.xerox.com)
)
)
LSNR1120_CLEARS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =new-libra-test.sdsp.mc.xerox.com )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LSNR1120_CLEARS)
)
)
CLEARS_STANDBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = usa0300lv6194.sdsp.mc.xerox.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CLEARS_STANDBY_DGMGRL)
(SID = CLEARQ)
(GLOBAL_NAME = CLEARS_STANDBY.sdsp.mc.xerox.com)
)
)
CLEARS_STANDBY.SDSP.MC.XEROX.COM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = usa0300lv6194.sdsp.mc.xerox.com)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = CLEARS_STANDBY.sdsp.mc.xerox.com)
(SID = CLEARS_STANDBY)
(GLOBAL_NAME = CLEARS_STANDBY.sdsp.mc.xerox.com)
)
)
LSNR1120_CLEARS_STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usa0300lv6194.sdsp.mc.xerox.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LSNR1120_CLEARS_STANDBY)
)
)
TNSNAMES.ora of STANDBY:
# tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA.SDSP.MC.XEROX.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.xerox.com)(PROTOCOL = TCP)(Host = usa0300lv6194.sdsp.mc.xerox.com)(Port = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
)
)
CLEARS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = new-libra-test.sdsp.mc.xerox.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = CLEARS)
(SERVICE_NAME = CLEARS_DGMGRL)
)
)
CLEARS.SDSP.MC.XEROX.COM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = new-libra-test.sdsp.mc.xerox.com)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = CLEARS.sdsp.mc.xerox.com)
(SID = CLEARS)
(GLOBAL_NAME = CLEARS.sdsp.mc.xerox.com)
)
)
LSNR1120_CLEARS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = new-libra-test.sdsp.mc.xerox.com )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LSNR1120_CLEARS)
)
)
CLEARS_STANDBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = usa0300lv6194.sdsp.mc.xerox.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CLEARS_STANDBY_DGMGRL)
(SID = CLEARS_STANDBY)
)
)
CLEARS_STANDBY.SDSP.MC.XEROX.COM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = usa0300lv6194.sdsp.mc.xerox.com)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = CLEARS_STANDBY.sdsp.mc.xerox.com)
(SID = CLEARS_STANDBY)
(GLOBAL_NAME = CLEARS_STANDBY.sdsp.mc.xerox.com)
)
)
LSNR1120_CLEARS_STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usa0300lv6194.sdsp.mc.xerox.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LSNR1120_CLEARS_STANDBY)
)
)
DGMGRL log:
============
EDIT DATABASE clears_standby SET PROPERTY DGConnectIdentifier = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usa0300lv6194.sdsp.mc.xerox.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CLEARS_STANDBY_DGMGRL)(INSTANCE_NAME=CLEARS_STANDBY)(SERVER=DEDICATED)))
12/10/2015 14:23:23
Site clears_standby returned ORA-16664.
Command EDIT DATABASE clears_standby SET PROPERTY DGConnectIdentifier = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usa0300lv6194.sdsp.mc.xerox.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CLEARS_STANDBY_DGMGRL)(INSTANCE_NAME=CLEARS_STANDBY)(SERVER=DEDICATED))) completed with error ORA-16664
12/10/2015 14:23:53
Site clears_standby returned ORA-16665.
12/10/2015 14:24:08
Site clears_standby returned ORA-16665.
12/10/2015 14:24:23
Site clears_standby returned ORA-16664.
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration CLEARS Warning ORA-16607
Primary Database CLEARS Success ORA-00000
Logical Standby Database clears_standby Error ORA-16664
12/10/2015 14:25:41
Site clears_standby returned ORA-16665.
12/10/2015 14:25:56
Site clears_standby returned ORA-16664.
Kindly help me to resolve the issue.