how to tnsping

[djam]

i'm tryint to tnsping a oracle DB but I get the following error

Used parameter files:
C:\oracle\ora92\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

I'm not sure what I should put in the sqlnet.ora file

Can someone give me a simple example? Am I forgeting anything else?

This is what I have in my tnsnames.ora file if it matters...

DJAM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DJAM.com)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ABCD)
)
)

" ahhh computers, how they made our lives much simpler "

 

[SantaMufasa]

DJam,

For my Windows machines, my sqlnet.ora file contains the following:

TRACE_LEVEL_CLIENT = OFF
sqlnet.authentication_services = (NTS)
names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world
name.default_zone = world
automatic_ipc = off

A corresponding reference in my tnsnames.ora file looks like this:

ALPH.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(Host = alpha)(Port = 1521))
    (CONNECT_DATA = (SERVICE_NAME = ALPH))
  )

A sample sqlplus invocation looks like this:

sqlplus <username>/<password>@alph

Unless I'm mistaken, your "HOST=..." value should probably not be "DJAM.com", but more likely just "DJAM" or its IP address.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 20:50 (27Jan05) UTC (aka "GMT" and "Zulu"),
@ 13:50 (27Jan05) Mountain Time

Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.