NetCA fail to create TNSNAME file
931045Apr 16 2012 — edited Apr 17 2012I installed Oracle11gR2 GRID and RAC on two nodes(windows2008R2): I did some modification for supporting TAF failover.
when I do "tnsping" I got an error like:
C:\Users\administrator.QAPF2>tnsping NLQA
TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 16-APR-2
012 17:04:37
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
C:\app\11.2.0\grid\NETWORK\ADMIN\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION =
TNS-12533: TNS:illegal ADDRESS parameters
From oracle forum, there were many discussions on this error: due to some bad characters in tnsnames.ora file.
They suggest to use NetCA to create it, I tried as follow but I got another(maybe same) error:
Connecting...ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
The test did not succeed.
Current node1 status:
C:\Users\administrator.QAPF2>srvctl config service -d ORCL -s NLQA
Service name: NLQA
Service is enabled
Server pool: ORCL_NLQA
Cardinality: 2
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: true
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 180
TAF failover delay: 5
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: orcl2,orcl1
Available instances:
C:\Users\administrator.QAPF2>srvctl status service -d ORCL -s NLQA
Service NLQA is running on instance(s) orcl1
My TNSNAME.ora file:
NLQA =
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = ORARAC1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ORARAC2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = NLQA)
(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))
)
)
listener.ora file:
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
I can not connect to the OracleRAC server from client. Please help me.
Thanks