DGMGRL error caused by ORA-16664, ORA-16625, TNS-12537-bin/oracle command permission issues

1.1. ORA-16664, ORA-16625, TNS-12537

Master database:

16664,000 0, "unable to receive theresult from a database"

// * Cause: During execution of a command, a databasein the Data Guard

// Broker configuration failed to return a result.

// * Action: Check Data Guard broker logsfor the details of the failure.

// Ensure network communication is working properly amongst

// Members of the configuration. Fix any possible network problems

// And reissue the command.

Slave database:

16625,000 0, "cannot reach database \" % s \""

// * Cause: The command cocould not be executed becausethe database noted

// In the error text was not reachable from the database where

// The command was issued.

// * Action: See accompanying messages formore information. Check the network

// Connections to the specified database. Alternatively, connect

// A different database in the Data Guard broker configuration and

// Retry the command.

Master/Slave databases:

12537,000 00, "TNS: connectionclosed"

// * Cause: "End of file" condition has been reached; partner has disconnected.

// * Action: None needed; this is aninformation message.

[Error message]

Check the DG Information on the master database DGMGRL:

DGMGRL> show configuration;

Databases:

........

Sorcldb-Physical standby database

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

......

Configuration Status:

ERROR

On the master database, DGMGRL displays the slave database information:

Database Status:

DGM-17016: failed to retrieve status fordatabase "sorcldb"

ORA-16664: unable to receive the resultfrom a database

Drcorcldb. log of the master database:

03/30/2014 17:23:03

Site sorcldb returned ORA-16664.

Data Guard Broker Status Summary:

Type Name Severity Status

Configuration orcl_dg Warning ORA-16607

Primary Database orcldb Success ORA-00000

Physical Standby Database sorcldb Error ORA-16664

Check the DG Information on the standby database DGMGRL:

DGMGRL> show configuration;

Configuration Status:

ORA-12537: TNS: connection closed

ORA-16625: cannot reach database "orcldb"

DGM-17017: unable to determineconfiguration status

Check the master database information on the standby database DGMGRL:

DGMGRL> show database verbose orcldb;

Database Status:

DGM-17016: failed to retrieve status fordatabase "orcldb"

ORA-12537: TNS: connection closed

ORA-16625: cannot reach database "orcldb"

The drcorcldb. log of the slave database:

03/30/2014 17:21:07

Failed to connect to remote database orcldb. Error is ORA-12537

Failed to send message to site orcldb. Error code is ORA-12537.

[Solution]

Modify the permissions of the $ ORACLE_HOME/bin/oracle file.

Previous permissions:

[Oracle @ orclbin] $ ls-l oracle

-Rwxr-x -- x1 oracle oinstall 232399083 May 12 2013 oracle

Modified permissions:

[Oracle @ orclbin] $Chmod 6751 oracle

[Oracle @ orclbin] $ ls-l oracle

-Rwsr-s -- x1 oracle oinstall 232399083 May 12 2013 oracle

[Cause]

Unknown. An external power failure occurred on the server, but after modifying the bin/oracle file permissions, the reboot server was tried. No exception occurred.

[Reference Information]

1. Check and correct the permission on/var/tmp/. oracle directory. Permissions on this directory shocould be 777 withsticky bit set.

# Chmod 01777/var/tmp/. oracle

2. Check and correct permissions on $ ORACLE_HOME/bin/oracle binary and make sure that it is set to 6751.

$ Chmod 6751 $ ORACLE_HOME/bin/oracle