oracle lsnrctl TNS-12545: Falha na conexão porque o host ou objeto de destino não existe

4

Estou tentando conectar-me ao meu banco de dados oracle. Não consigo iniciar o ouvinte. Aqui está o que eu tentei.

$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 08:19:58

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(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

$ cat ./admin/tnsnames.ora

 
# TNSNAMES.ORA Network Configuration File: 
# /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora 
# 

EXTPROC_CONNECTION_DATA.test = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) 
    ) 
    (CONNECT_DATA = 
      (SID = DEVDB) 
        (PRESENTATION = RO) 
      ) 
    ) 

DEVDB = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = DEVDB.test)
    ) 
  ) 

DEBDB.test = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = DEVDB.test)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = DEVDB.test)
    ) 
  )

$ hostname
test

Aqui está um exemplo de um início bem-sucedido em uma outra máquina com configuração semelhante. Nenhum arquivo listner.ora apenas tnsnames.ora.

$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 11:38:51

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracletest)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                20-JAN-2012 11:38:51
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracletest)(PORT=1521)))
The listener supports no services
The command completed successfully
    
por nelaaro 20.01.2012 / 09:30

2 respostas

2

Você tem HOST= vazio em seu listener.ora. Gostaria de editá-lo como HOST=my.ip.address . Mesmo HOST=127.0.0.1 será feito se o aplicativo estiver no mesmo host. Você executou netca corretamente antes (o que é recomendado para iniciantes)?

    
por 20.01.2012 / 10:08
0

$ vim /etc/hosts

Alterar linha de

127.0.0.1 localhost.localdomain localhost

para

127.0.0.1 test localhost.localdomain localhost

cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=test

$ hostname
test

$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 10:08:54

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                20-JAN-2012 10:08:55
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))
The listener supports no services
The command completed successfully
    
por 20.01.2012 / 11:09