novice Oracle 9i tnslsnr problem

From: Dieter A. <dieter_algemeinbung_at_excite.com>
Date: 15 Jan 2003 14:09:46 -0800
Message-ID: <b9c3bfad.0301151409.66647221@posting.google.com>

I'm an oracle novice and I've been trying to figure this tnslistener problem out for days with no luck.
I installed Oracle 9i on Suse 8 linux. It works correctly except for the tnslsnr. When I try to tnsping $ORACLE_SID it won't work claiming used parameter file .../sqlnet.ora
TNS-03505: Failed to resolve name

however, when I tnsping localhost ,it works stating used .../sqlnet.ora
used HOSTNAME adapter to resolve alias
OK( 10msec )

The files are below:

tnsnames.ora

---

MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = localhost)(PORT=1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME=mydb)

)
)

sqlnet.ora

---

# SQLNET.ORA Network Configuration File: .../sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = local

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) listener.ora

---

LISTENER = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)
(HOST=localhost)(PORT=1521)) (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
Received on Wed Jan 15 2003 - 16:09:46 CST