Database Networking (MOSC)

MOSC Banner

tnsping fails with TNS-03505

edited Aug 22, 2013 11:31PM in Database Networking (MOSC) 8 commentsAnswered
C:\Users\dmohan>tnsping rmsuat
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 21-AUG-2
013 13:58:13

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
C:\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

contents of sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES = (NTS)

if I try to connect using sqlplus..

C:\Users\dmohan>sqlplus sys@rmsuat as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 21 14:01:17 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

DB version is 11.2.0.3

tns entry is already made in tnsnames.ora

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center