ORA-12541: TNS:no listener

Hi,

I am puzzled by this error.

I have installed oracle 816 (EE Edition) on a Sun box and created an instance called "NS1". And I started the listener. BTW, ORACLE_SID etc env are all set in .profile.

I have no problem using svrmgrl connecting to NS1 I have no problem using sqlplus from my dell desk top PC connecting to NS1. I tried $ORACLE_HOME/bin/netasst and test the connection to NS1, no problem.

But when I use sqlplus on the Sun box.

If I do

sqlplus ns1_user/passw

It connects to NS1 fine (ORACLE_SID etc env are all set in .profile)

But if I try

sqlplus ns1_user/passw_at_NS1

then I got :

SQL*Plus: Release 8.1.6.0.0 - Production on Fri Sep 21 17:14:57 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

ERROR:
ORA-12541: TNS:no listener

---

So I thought the problem is tnsname.ora file.

here is the entry in that file:
----
NS1=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host=10.203.10.27)(Port= 1521))
    (CONNECT_DATA = (SID = NS1))
  )

----------
Looking at sqlnet.log file gave me some clue, but not enough for me to know
where to change:

Fatal NI connect error 12541, connecting to:



(DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=ns1.proteome)(CID=(PROGRAM=)

(HO

ST=rockport)(USER=oracle)))(ADDRESS=(PROTOCOL=TCP)(HOST=ns1)(PORT=1521)))

  VERSION INFORMATION:
        TNS for Solaris: Version 8.1.6.0.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 8.1.6.0.0 -
Production
  Time: 21-SEP-2001 17:39:13
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12541
    TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
    TNS-00511: No listener
    nt secondary err code: 146
    nt OS err code: 0

----------
Any suggestions?

TIA.

Guang