My Oracle Support Banner

Oracle Net80 TAF Enabled Alias Fails With ORA-12197 (Doc ID 284273.1)

Last updated on DECEMBER 17, 2008

Applies to:

Oracle Net Services - Version:
This problem can occur on any platform.
Connections to database using Net80 code.


Transparent Application Failover (TAF) enabled Oracle Net 80 connections fail with error ORA -12197 TNS:keyword-value resolution error.Example of TAF service name entry :

      (LOAD_BALANCE = ON) 
      (FAILOVER = ON) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))
        (TYPE = SELECT)
        (METHOD = BASIC)

Oracle Net trace shows :
nioqper: error from nricall
nioqper: nr err code: 12197
nioqper: ns main err code: 12560
nioqper: ns (2) err code: 0
nioqper: nt main err code: 0
nioqper: nt (2) err code: 0
nioqper: nt OS err code: 0 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.