TNS-03505 Failing to resolve TNS names could involve any one of the network configuration files, such as tnsnames.ora or sqlnet.ora. There’re several 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.ora. Only local naming can be […]
ORA-28040: No matching authentication protocol 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, Oracle 9i client connect to 12c database. But I […]
ORA-12537 Overview There’re several possible causes to raise ORA-12537: Incorrect File Permission White or Black List ORA-12537 Caused by Incorrect File Permission Incorrect file permission will prevent connections from being established. That is to say, potentially successful connections will be interrupted by ORA-12537 due to wrong file permissions, specifically, the execution permission. As a result, […]
ORA-3136 At times, some users complained about connection timeout, and you saw error messages ORA-3136 in sqlnet.log as such: Fatal NI connect error 12170. ns main err code: 12535 ns secondary err code: 12606 nt OS err code: 0 VERSION INFORMATION: … TNS-12535 TNS:operation timed out Client address: […]
