初学者：TNS　错误

你把tns贴出来，大家一起看看
我用的也是oracle8i+windows2000，远程和本地的都可以跑

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

txfy

荣誉版主

论坛徽章:: 0

12楼 [报告]

发表于 2004-07-23 10:37 |只看该作者

初学者：TNS　错误

首先你要确认你改的tnsnames.ora是不是你用到的。其次把tnsnames.ora里关于orcl_192.168.0.74 这段拷贝过来看看！

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

cwmould

丰衣足食

论坛徽章:: 0

13楼 [报告]

发表于 2004-07-26 13:49 |只看该作者

初学者：TNS　错误

tnsnames.ora的路径是没问题的，lsnrctl start 里面的与我实际修改的致，下面是我的tnsnames.ora的俱体内容及lsnrctl start的，请大家帮助分析一下

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
   )
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = solaris)(PORT = 1521))
   )
)
(DESCRIPTION =
   (PROTOCOL_STACK =
      (PRESENTATION = GIOP)
      (SESSION = RAW)
   )
   (ADDRESS = (PROTOCOL = TCP)(HOST = solaris)(PORT = 2481))
)
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /var/data/oracle/product/8.1.7)
   (PROGRAM = extproc)
)
(SID_DESC =
   (GLOBAL_DBNAME = xxxx.com)
   (ORACLE_HOME = /var/data/oracle/product/8.1.7)
   (SID_NAME = orcl)
)
  )

以下为lsnrctl start 的内容　

Starting /var/data/oracle/product/8.1.7/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.1.7.0.0 - Production
System parameter file is /var/data/oracle/product/8.1.7/network/admin/listener.o
ra
Log messages written to /var/data/oracle/product/8.1.7/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=solaris)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=solaris)(PORT=2481))(PRO
TOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Solaris: Version 8.1.7.0.0 - Production
Start Date             26-JUL-2004 09:37:04
Uptime                   0 days 0 hr. 0 min. 0 sec
Trace Level             off
Security                OFF
SNMP                   OFF
Listener Parameter File /var/data/oracle/product/8.1.7/network/admin/listener.
ora
Listener Log File       /var/data/oracle/product/8.1.7/network/log/listener.lo
g
Services Summary...
  PLSExtProc          has 1 service handler(s)
  orcl       has 1 service handler(s)
The command completed successfully