Home » SQL & PL/SQL » Client Tools » TNS-03505: Failed to resolve name tips - tnsping orcl (Oracle 10g )
TNS-03505: Failed to resolve name tips - tnsping orcl [message #587758] Tue, 18 June 2013 07:37 Go to next message
Devo
Messages: 23
Registered: November 2012
Location: France
Junior Member
Hi everybody,
I'm trying to connect my oracle 10g database to SSIS, and before establishing the connection i tried :
tnsping orcl but i got this error

TNS-03505: Failed to resolve name tips

tnsnames.ora
ORCLE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myname.lok.DOMAIN)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcle)
    )
  )



listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = myname.lok.DOMAIN)(PORT = 1521))
    )
  )


sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


Can anyone help me to resolve this problem ?
thanks

[Updated on: Tue, 18 June 2013 07:37]

Report message to a moderator

Re: TNS-03505: Failed to resolve name tips - tnsping orcl [message #587759 is a reply to message #587758] Tue, 18 June 2013 07:39 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
Try:

tnsping ORCLE


Re: TNS-03505: Failed to resolve name tips - tnsping orcl [message #587760 is a reply to message #587758] Tue, 18 June 2013 07:39 Go to previous messageGo to next message
Littlefoot
Messages: 19526
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
tnsping orcl
vs.(tnsnames.ora)
ORCLE =
Re: TNS-03505: Failed to resolve name tips - tnsping orcl [message #587761 is a reply to message #587760] Tue, 18 June 2013 07:40 Go to previous message
Devo
Messages: 23
Registered: November 2012
Location: France
Junior Member
OMG thanks @Littlefoot
it was my error, i should rite
tnsping orcle


thanks a lot.
Previous Topic: PL/SQL Developer Debug Date/Time Variable
Next Topic: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g
Goto Forum:
  


Current Time: Sat Aug 30 21:20:00 CDT 2014

Total time taken to generate the page: 0.14092 seconds