这个问题怎样解决

haijiang

肯定是tnsname。ora的问题
能否把你的tnsname.ora提供出来

oracle-plus

你是用什麼連數據庫的，sqlplus?

newguest

我是用Net8 easy config配置连接的

newguest

tnsname.ora内容如下（wjyzx为我所用连接设置）：
# C:\ORAWIN95\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\orawin95\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

CMEXAMPLE.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = CM_SERVER)(PORT = 1610))
      (ADDRESS = (PROTOCOL = TCP)(HOST = LSNR_SERVER)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = ORCL))
    (SOURCE_ROUTE = YES)
  )

TCPEXAMPLE.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Production1)(PORT = 1521))
    (CONNECT_DATA = (SID = ORCL))
  )

NMPEXAMPLE.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe = ORAPIPE))
    (CONNECT_DATA = (SID = ORCL))
  )

WJYZX.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
    (CONNECT_DATA = (SID = ORCL))
  )

EXTPROC_CONNECTION_DATA.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
    (CONNECT_DATA = (SID = extproc))
  )

BEQ-LOCAL.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 = oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))
    (CONNECT_DATA = (SID = ORCL))
  )

SPXEXAMPLE.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
    (CONNECT_DATA = (SID = ORCL))
  )

TCP-LOOPBACK.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(Host = 192.168.1.1)(Port = 1521))
    (CONNECT_DATA = (SID = ORCL))
  )

warehouse

把sqlnet.ora里的内容都注释掉！