请高手指教----急

gqzhang · 发表于 2003-8-2 05:19

可是我把route的DMZ设为安装oracle的PC，这样是不是就把所有的端口都打开了，可是结果还是一样的错误

aaahhh · 发表于 2003-8-2 05:22

奇怪，如果你在本机上联呢

gqzhang · 发表于 2003-8-2 05:48

我刚才试过了，在外网还是连不上，情况和以前一样

在本机内网连一点问题都没有

还请您多帮忙

aaahhh · 发表于 2003-8-2 05:59

listener.log 贴来看看

gqzhang · 发表于 2003-8-2 06:06

02-8月 -2003 05:36:35 * service_update * PDMBF * 0
02-8月 -2003 05:37:08 * service_update * PDMBF * 0
02-8月 -2003 05:38:57 * (CONNECT_DATA=(SERVICE_NAME=PDMBF)(CID=(PROGRAM=C:\EDMS\ora805\bin\sqlplus.exe)(HOST=LIUFENG)(USER=polysoft))) * (ADDRESS=(PROTOCOL=tcp)(HOST=61.181.115.1)(PORT=1770)) * establish * PDMBF * 0
02-8月 -2003 05:40:26 * service_update * PDMBF * 0
02-8月 -2003 05:40:59 * service_update * PDMBF * 0

gqzhang · 发表于 2003-8-2 06:07

/////////    listener.ora

# LISTENER.ORA Network Configuration File: C:\oracle\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

STARTUP_WAIT_TIME_LISTENER = 10

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = tj03)(PORT = 1521))
)
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = C:\oracle)
   (PROGRAM = extproc)
)
(SID_DESC =
   (GLOBAL_DBNAME = felix01)
   (ORACLE_HOME = C:\oracle)
   (SID_NAME = felix01)
)
(SID_DESC =
   (GLOBAL_DBNAME = OEMREP)
   (ORACLE_HOME = C:\oracle)
   (SID_NAME = OEMREP)
)
(SID_DESC =
   (GLOBAL_DBNAME = demo01)
   (ORACLE_HOME = C:\oracle)
   (SID_NAME = demo01)
)
(SID_DESC =
   (GLOBAL_DBNAME = nima)
   (ORACLE_HOME = C:\oracle)
   (SID_NAME = nima)
)
(SID_DESC =
   (GLOBAL_DBNAME = PDMBF)
   (ORACLE_HOME = C:\oracle)
   (SID_NAME = PDMBF)
)
  )

gqzhang · 发表于 2003-8-2 06:10

/////// tnsnames.ora
PDMBF =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 218.104.*.*)(PORT = 1521))
)
(CONNECT_DATA =
   (SERVICE_NAME = PDMBF)
)
  )

aaahhh · 发表于 2003-8-2 06:12

现在外网pc上把sqlnet.ora 里设trace

aaahhh · 发表于 2003-8-2 06:13

trace_level_client=16 然后把结果贴出来看看

aaahhh · 发表于 2003-8-2 06:19

我有点糊涂了，你现在Oracle server 是在一个pc上，这个pc叫tj03，
listener port 1521 是不是? 现在这个pc是不是在DMZ上?

[精华] 请高手指教----急

浏览过的版块