SQLNET

How to Resolve TNS-03505: Failed to resolve name

Posted on
TNS-03505: Failed to resolve name This type of error could involve any one of the network configuration files, such as tnsnames.ora or sqlnet.ora. Two possible causes may throw TNS-03505: Absent Local Naming Connect Identifier Mismatch Search for Wrong Domain 1. Absent Local Naming There’re several naming methods supported by Oracle in SQLNET. Only local naming, […]
Listener

How to Resolve ORA-12537:TNS:connection closed

Posted on
ORA-12537 Error Pattern 1: File Permission After installing 11g RAC, we can test the database access, it would be successful via SCAN. But when we directly access on specific node, we found the connection failed on the second node with an error: ORA-12537:TNS:connection closed Generally speaking, the listener belongs to user grid, and the database […]