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, […]
ORA-28040 When I tried to connect a 12.1 database from an Oracle client 9.2, it failed with ORA-28040: No matching authentication protocol. I knew there could be some interoperability problems between versions, especially when the version gap is big like this case, 9i to 12c. But I didn’t expect ORA-28040 to show up. Same error […]
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 […]