ora-16664,ora-16625 and TNS-12537 Analysis

1.1. ora-16664,ora-16625,tns-12537

Main Library:

16664, 0000, "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 the

Members of the configuration. Fix any possible network problems

and reissue the command.

Prepare library:

16625, 0000, "Cannot reach Database\"%s\ ""

*cause:the command could not is executed Becausethe database noted

In the error text is 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 to

A different database in the Data Guard broker configuration and

Retry the command.

Primary/Standby Library:

12537, 00000, "tns:connectionclosed."

*cause: "End of file" condition has been reached; Partner has disconnected.

*action:none needed; This is aninformation message.

"Error Message"

DGMGRL View DG Information on Main Library:

Dgmgrl> show configuration;

Databases:

........

Sorcldb-physical Standby Database

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

......

Configuration Status:

ERROR

DGMGRL View the repository information on the main library:

Database Status:

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

dgm-17016:failed to retrieve status Fordatabase "Sorcldb"

Ora-16664:unable to receive the Resultfrom a database

Drcorcldb.log Log for Main library:

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

DGMGRL View DG Information on the standby library:

Dgmgrl> show configuration;

Configuration Status:

Ora-12537:tns:connection closed

Ora-16625:cannot reach Database "Orcldb"

Dgm-17017:unable to Determineconfiguration status

DGMGRL View Master Library information on the standby library:

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"

Drcorcldb.log log of the standby library:

03/30/2014 17:21:07

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

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

"Workaround"

Modify the permissions for the $oracle_home/bin/oracle file.

Before you modify the permissions:

[oracle@orclbin]$ ls-l Oracle

-rwxr-x--x1 Oracle Oinstall 232399083 May 2013oracle

Permissions after modification:

[oracle@orclbin]$ chmod 6751 Oracle

[oracle@orclbin]$ ls-l Oracle

-rwsr-s--x1 Oracle Oinstall 232399083 May 2013oracle

"Cause of the problem"

Unknown. The server has experienced an external power outage, but after modifying the bin/oracle file permissions, the reboot server was attempted and no exception occurred.

"Reference Information"

1. Check and correct the permission On/var/tmp/.oracle directory. Permissions on this directory should is 777 Withsticky bit set.

# chmod 01777/var/tmp/.oracle

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

$ chmod 6751 $ORACLE _home/bin/oracle