oracle 10g在redhat linux ADS 3 上的问题！

kinnix

oracle 10g在redhat linux ADS 3 上装完后，创建数据库后，启动listener出问题，提示如下：

[oracle@oracle10g oracle]$ lsnrctl start LISTENER

LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 03-MAR-2004 17:04:53

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

Starting /u01/app/oracle/product/10.1.0/db_10/bin/tnslsnr: please wait...

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
   Linux Error: 2: No such file or directory
[oracle@oracle10g oracle]$

那位老大来帮忙分析一下原因 ，谢谢 ！

jianan

监听你培植吗？

hxigue

监听你培植吗？

kinnix

我用 net config assistant 重新配置了的，还是出那个问题

kinnix

listener.ora文件内容如下：
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_10)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

kinnix

tnsnames.ora文件内容如下：

ORA10G_ORACLE10G =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = ora10g)
      (SERVER = DEDICATED)
    )
  )

geniiking

删掉监听器重新建，另外在
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g)(PORT = 1521))
处改为
(ADDRESS = (PROTOCOL = TCP)(HOST = ip地址)(PORT = 1521))

kinnix

还是不行啊，同志们，大家再继续来研究研究啊！

hmkart

1. 
   
2. LISTENER =
   
3. (DESCRIPTION_LIST =
   
4. (DESCRIPTION =
   
5. (ADDRESS_LIST =
   
6. (ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g)(PORT = 1521))
   
7. )
   
8. (ADDRESS_LIST =
   
9. (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
   
10. )
    
11. )
    
12. )
    

复制代码

在你的listener.ora文件只留这些,then 看看
ping oracle10g时候有回应,
OK,那再起listen吧.
lsnrctl start
就可以了,反正你就1个listen,没必要指定后面的.

text2002

netca connect test 成功没有？