Listener

How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Posted on
ORA-12514 Let’s see how we reproduce TNS-12514. First of all, we have to make sure the listener is running well. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 22-JUL-2014 19:24:04 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting […]
SQLNET

How to Resolve TNS-12545: Connect failed because target host or object does not exist

Posted on
TNS-12545 Let’s see how we reproduce TNS-12545. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 21-JUL-2014 19:10:59 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01)(PORT = 1521)) […]
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

TNSPING – 8 Aspects You Should Know

Posted on
tnsping tnsping is a utility provided by Oracle to test the listener is available or not from clients. If there’s any problem in the path to the destination, it will fail with different aspects. Here I list several possible error types below for your reference. “tnsping is not recognized as an internal or external command” […]
TNS Name

How to Implement Transparent Application Failover (TAF) by Local Naming

Posted on
General backgroundBesides Connect-Time Failover by local naming, there is a function Transparent Application Failover (TAF) can do Run-Time Failover to enable user to continue his work transparently when connection failed over to other database (listener).There are two types of Run-Time Failover method, both methods are suitable for RAC architecture, but not for Data Guard, because […]