Re: tns service error

Try to add this entry to DESCRIPTION_LIST in your listener configuration file:
 

(ADDRESS = (PROTOCOL = IPC)(KEY = PLNT))
So:
 
LISTENER =  (DESCRIPTION_LIST
=    (DESCRIPTION =     
(ADDRESS = (PROTOCOL = TCP)(HOST = bunyamin)(PORT = 1521))   
)    (DESCRIPTION =     
(ADDRESS = (PROTOCOL = TCP)(HOST = bunyamin)(PORT = 2481))   
)    (DESCRIPTION =     
(ADDRESS = (PROTOCOL = IPC)(KEY=UYAPBUN))    )  )
 
SID_LIST_LISTENER =  (SID_LIST
=    (SID_DESC =     
(GLOBAL_DBNAME = UYAPBUN.havelsan.com.tr)     
(ORACLE_HOME = D:\ORACLE\ORA817)      (SID_NAME =
UYAPBUN)    )  ) 
 
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627<A href="mailto:ineyman_at_perceptron.com">ineyman_at_perceptron.com 

<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A title=bunyamink_at_havelsan.com.tr href="mailto:bunyamink_at_havelsan.com.tr">Bunyamin K. Karadeniz To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Wednesday, August 22, 2001 10:11   AM
  Subject: tns service error   

   I am getting the below error where I run   STAT or STOP command of LSNRCTL on 8.1.7 on NT. Content of listener.ora is   also below.
  Why is that ?
  Note : I can remotely connect to this database   from client.
   
   
  Connecting to
  (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))TNS-12541: TNS:no   listener TNS-12560: TNS:protocol adapter error  TNS-00511:   No listener   32-bit Windows Error: 2: No such file or   directoryConnecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))TNS-12545:   Connect failed because target host or object does not   exist TNS-12560: TNS:protocol adapter error  TNS-00515:   Connect failed because target host or object does not exist     32-bit Windows Error: 49: Unknown error    
  In My listener file  below are
  written.
  LISTENER =  (DESCRIPTION_LIST
  =    (DESCRIPTION =     
  (ADDRESS = (PROTOCOL = TCP)(HOST = bunyamin)(PORT =   1521))    )    (DESCRIPTION
  =      (ADDRESS = (PROTOCOL = TCP)(HOST =   bunyamin)(PORT = 2481))    )  )
   
  SID_LIST_LISTENER =  (SID_LIST
  =    (SID_DESC =     
  (GLOBAL_DBNAME = UYAPBUN.havelsan.com.tr)        (ORACLE_HOME = D:\ORACLE\ORA817)      (SID_NAME =   UYAPBUN)    ) 
)  Received on Wed Aug 22 2001 - 09:49:53 CDT