Re: tns service error

Wed, 22 Aug 2001 07:49:53 -0700

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 DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
 
----- Original Message -----
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 directory
Connecting 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)
    )
  ) 

Reply via email to