Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NetCA fail to create TNSNAME file

931045Apr 16 2012 — edited Apr 17 2012
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 15 2012
Added on Apr 16 2012
4 comments
1,116 views