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: 8.0.1.0.0
This problem can occur on any platform.
Connections to database using Net80 code.

Symptoms

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 :

TAF.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST = 
      (LOAD_BALANCE = ON) 
      (FAILOVER = ON) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.sample.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.sample.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES=20) 
        (DELAY=5) 
      )
    )
  )

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 


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms