is my tnsnames.ora ok?

[chrislee8]

I had problem using sqlplus with tns service not resolve problem.

I did a search, only 1 tnsnames.ora file in oracle installation directory:
c:\oracle\ora90\network\admin

here is that file:

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

When I installed the oracle 9i DB, it asked for a oracle's global database name which I typed in oscar.chrislee8

the SID is oscar, I left all the password as default.

I try to do it:

sql> connect scott/tiger@oscar , tns: service name not resolve.

what is wrong with my oracle installation?

should I manually put in the entry into tnsnames.ora file? if yes, please anyone show me an example, i know oracle provide syntax sample, but i really like to have a real example to follow.

Thanks

[ocpwannabe]

doesn't look like your tnsnames.ora entry is setup. should look something like:
XXX_TCP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = III)
(PORT = 1521)
)
)
(CONNECT_DATA = (SID = XXX) )
)

[julian]

(CONNECT_DATA = (SID = XXX) ) )

I would suggest the newer way:

(CONNECT_DATA = (SERVICE_NAME = XXX.WORLD)(INSTANCE_NAME=XXX)