Listener

carlos_henrique · Fri, 11 Jan 2008 10:16 am

I use a web application that uses BD Oracle, but the following error appears:

When I try to enter SQLPLUS also I can not, it presents unknown Listener error .

follow my listener files, tnsnames and sqlnet:

Select all

# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_3\network\admin\listener.ora 
# Generated by Oracle configuration tools. 
 
SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_3) 
      (PROGRAM = extproc) 
    ) 
  ) 
 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.125.50)(PORT = 1521)) 
    ) 
  ) 
 
# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_3\network\admin\tnsnames.ora 
# Generated by Oracle configuration tools. 
 
ORCL = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.125.50)(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = orcl) 
    ) 
  ) 
 
EXTPROC_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
    ) 
    (CONNECT_DATA = 
      (SID = PLSExtProc) 
      (PRESENTATION = RO) 
    ) 
  ) 
 
# sqlnet.ora Network Configuration File: E:\oracle\product\10.2.0\db_3\network\admin\sqlnet.ora 
# Generated by Oracle configuration tools. 
 
# This file is actually generated by netca. But if customers choose to  
# install "Software Only", this file wont exist and without the native  
# authentication, they will not be able to connect to the database on NT. 
 
SQLNET.AUTHENTICATION_SERVICES= (NTS) 
 
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

** When I installed Oracle yesterday, I performed tests and it was working. But when I went running the application this morning, the error was presented again.

Att,
Carlos Henrique

gilbertoca · Fri, 11 Jan 2008 2:17 pm

Is the application on the same machine as the Oracle server?
The name of the created bank is Orcl, did you confirm this through Listener? (LSRNCTL status)

If the application is on another server, did you install the client? If yes, test the connection to the tnsping utility.

Gilberto

carlos_henrique · Fri, 11 Jan 2008 2:30 pm

Follows tnsping command:

Select all

tnsping orcl 
E:\>tnsping orcl 
 
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-JAN-2 
008 14:28:24 
 
Copyright (c) 1997, 2005, Oracle.  All rights reserved. 
 
Arquivos de parÔmetros usados: 
E:\oracle\product\10.2.0\db_3\network\admin\sqlnet.ora 
 
 
Usado o adaptador TNSNAMES para resolver o apelido 
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.1 
25.50)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)) 
) 
OK (110 ms)

The application is running on the same server. How do I perform the LSRNCTL status command?

Att,
Carlos Henrique

gilbertoca · Fri, 11 Jan 2008 2:41 pm

carlos_henrique wrote: # sqlnet.ora Network Configuration File: E: \ Oracle \ Product \ 10.2.0 \ db_3 \ Network \ admin \ sqlnet.ora
# Generated by Oracle Configuration Tools.

# This file is actually generated by Netca. But IF Customers Choose to
# Install "Software Only", This File Wont Exists and Without The Native
# Authentication, They Will Not Be Able to Connect to the Database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

names.directory_path = (TNSNames, ezconnect)

Remove the line that adjusts the authentication_services parameter.
and test your application again.

Carlos_henrique wrote: The application is running on the same server. How do I perform the LSRNCTL status command?

http://download.oracle.com/docs/cd/B193 ... sthref1450

Gilberto

carlos_henrique · Fri, 11 Jan 2008 2:51 pm

Follows LSNRCTL command> Status:

Select all

LSNRCTL> STATUS LISTENER 
Estabelecendo conexÒo com (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) 
STATUS do LISTENER 
------------------------ 
Apelido                   LISTENER 
VersÒo                    TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ 
ction 
Data Inicial              11-JAN-2008 14:26:44 
Funcionamento         0 dias 0 hr. 24 min. 10 seg 
NÝvel de Anßlise     off 
Seguranþa              ON: Local OS Authentication 
SNMP                      OFF 
Arq. ParÔm. Listn.    E:\oracle\product\10.2.0\db_3\network\admin\listener.ora 
Arq. Log Listener    E:\oracle\product\10.2.0\db_3\network\log\listener.log 
Resumo de Atendimento... 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc))) 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.26.125.50)(PORT=1521))) 
Resumo de Serviþos... 
O serviþo "PLSExtProc" tem 1 instÔncia(s). 
  InstÔncia "PLSExtProc", status UNKNOWN, tem 1 handler(s) para este serviþo... 
O comando foi executado com Ûxito

Att,

carlos_henrique · Fri, 11 Jan 2008 3:15 pm

I removed the line as requested, but I have not obtained success.

Select all

# sqlnet.ora Network Configuration File: E:\oracle\product\10.2.0\db_3\network\admin\sqlnet.ora  
# Generated by Oracle configuration tools.  
 
# This file is actually generated by netca. But if customers choose to  
# install "Software Only", this file wont exist and without the native  
# authentication, they will not be able to connect to the database on NT.  
 
#SQLNET.AUTHENTICATION_SERVICES= (NTS)  
 
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

gilbertoca · Fri, 11 Jan 2008 3:25 pm

Has your bank started? It seems that there is no instance of any turning, because if there was, the listener automatically records it.

Gilberto

carlos_henrique · Fri, 11 Jan 2008 3:38 pm

How can I check if the bank was started?

Att,

gilbertoca · Fri, 11 Jan 2008 3:56 pm

carlos_henrique wrote: How can I check if the bank has started ??

Att,

Here: http://download.oracle.com/docs/cd/B193 ... m#CHDGGDAB

Carlos, I do not want to be rude, but you need to read the Oracle Bank Documentation. Start with the installation guide for your platform and then the Administrator's Guide.
If you are starting or is developer, install the Express Edition version that is simpler to install and use.

Gilberto

carlos_henrique · Fri, 11 Jan 2008 4:00 pm

Thank you very much for your attention.

diegoleite · Mon, 14 Jan 2008 9:35 pm

Have you tried to stop and re-create Listener?

diegoleite · Mon, 14 Jan 2008 9:46 pm

See what are the Oracle services are Startados !! ??

OracleService ..
DBConsole ..
Listener ...

Listener

Who is online