From ineyman@perceptron.com Wed, 22 Aug 2001 07:49:53 -0700
From: "Igor Neyman" <ineyman@perceptron.com>
Date: Wed, 22 Aug 2001 07:49:53 -0700
Subject: Re: tns service error
Message-ID: <F001.00373E95.20010822071557@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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@perceptron.com">ineyman@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@havelsan.com.tr 
  href="mailto:bunyamink@havelsan.com.tr">Bunyamin K. Karadeniz 
  To: <A title=ORACLE-L@fatcity.com 
  href="mailto:ORACLE-L@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)    )  
)