来看看数据库链接的问题

rollingpig

A机，port前少了括号

B机
先贴出tnsnames.ora
再运行
tnsping 192.168.1.44

stone10

你把A机和B机的子网掩码设置成一样!再试一下!

anchen211

最初由 rollingpig 发布
[B]A机，port前少了括号

B机
先贴出tnsnames.ora
再运行
tnsping 192.168.1.44 [/B]

SQL> select * from dual@tjbill
  2  /
select * from dual@tjbill
                   *
ERROR 位于第 1 行:
ORA-12560: TNS: 协议适配器错误


SQL>

SQL> select * from dual@bjbill;
select * from dual@bjbill
                   *
ERROR 位于第 1 行:
ORA-12560: TNS: 协议适配器错误


SQL>

anchen211

最初由 rollingpig 发布
[B]A机，port前少了括号

B机
先贴出tnsnames.ora
再运行
tnsping 192.168.1.44 [/B]

B 机
[oracle@localhost admin]$ more tnsnames.ora

BILL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.137(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bill)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.137)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = bill)
      (PRESENTATION = http://admin)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
[oracle@localhost admin]$

[oracle@localhost admin]$ tnsping 192.168.1.44

TNS Ping Utility for Linux: Version 8.1.7.0.0 - Production on 04-2月 -2005 17:40:29

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.44)(PORT=1521))
TNS-12560: TNS：协议适配器出现错误
[oracle@localhost admin]$

anchen211

最初由 anchen211 发布
[B]

B 机
[oracle@localhost admin]$ more tnsnames.ora

BILL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.137(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bill)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.137)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = bill)
      (PRESENTATION = http://admin)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
[oracle@localhost admin]$

[oracle@localhost admin]$ tnsping 192.168.1.44

TNS Ping Utility for Linux: Version 8.1.7.0.0 - Production on 04-2月 -2005 17:40:29

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.44)(PORT=1521))
TNS-12560: TNS：协议适配器出现错误
[oracle@localhost admin]$ [/B]

使用TNSPING连不通,想到可能是网络问题,将内网IP改为外网IP后,就可以了.
谢谢各位了.