oracle 10g 连接 Sql 2005 错误提示NCR-000002 官方解释 调用函数错误

[billclinton8]

1。透明网关配置

HS_FDS_CONNECT_INFO="Server=127.0.0.1;Database=PT"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

2监听配置
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\tg_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = PT)
(ORACLE_HOME = D:\oracle\product\10.2.0\tg_1)
(PROGRAM = tg4msql)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
3。TNS配置

PT=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =127.0.0.1)(PORT =1522))
)
(CONNECT_DATA =
(SID =PT)
)
(HS = OK)
)

4。 TNS 测试
初始化首次测试请使用用户名: scott, 口令: tiger
正在尝试使用以下用户 ID 连接:scott
测试没有成功。
ORA-03135: 连接失去联系

在输入的字段中可能有错误,
或者服务器连接未就绪。

5。在透明网关 安装目录的tg4msql/trace的PT_agt_3668.trc内容如下：



Oracle Corporation --- 星期四 8月 09 2012 15:42:39.421


Heterogeneous Agent Release
10.2.0.1.0


HS Agent diagnosed error on initial communication,
probable cause is an error in network administration
Network error 2: NCR-00002: NCR: 无效的使用

6。 在系统盘 WINDOWS\system32下生成了HS_CORE_03668/HS_CORE_03668.LOG 其内容在1楼贴出来：


求高手帮忙看看 分不够 可以加

[billclinton8]

Process Id: 0x00000e54 Thread Id : 0x00001078 Time : Thu Aug 09 15:42:39
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000

------------------- Instruction Disassembly --------------
------------------- End of Disassembly -------------------

------------------- Call Stack Trace ---------------------
Frameptr RetAddr Param#1 Param#2 Param#3 Param#4 Function Name
0x0012f4d8 00403b55 00000000 00000001 00f01e30 0012f4f8 0x12112a31
0x0012f510 00429cb9 00f01e30 00f06640 c0020002 00f03e88 0x00403b55
0x0012f530 0040fb35 00f06840 00000001 00000001 00f06840 0x00429cb9
0x0012f55c 00401116 00f03e88 00401690 004016f0 00401780 0x0040fb35
0x0012ff0c 0041bf2b 00000002 00392a10 c0000005 c0000005 0x00401116
0x0012ff4c 00401188 00000002 00392a10 0012ff94 0012ffc0 0x0041bf2b
0x0012ff60 0046c3c1 00000002 00392a10 00392ca0 00481000 0x00401188
0x0012ffc0 7c82f23b 00000000 00000000 7ffd9000 00000000 0x0046c3c1
0x0012fff0 00000000 0046c27e 00000000 78746341 00000020 0x7c82f23b
------------------- End of Stack Trace -------------------
------------------- Raw Stack Dump -----------------------
Address Dump of bytes
0x0012f4d4 30 1e f0 00 10 f5 12 00 - 55 3b 40 00 00 00 00 00 0.......U;@.....
0x0012f4e4 01 00 00 00 30 1e f0 00 - f8 f4 12 00 30 1e f0 00 ....0.......0...
0x0012f4f4 03 19 40 00 00 00 00 00 - 30 1e f0 00 19 f7 42 00 ..@.....0.....B.
0x0012f504 30 1e f0 00 30 1e f0 00 - 40 66 f0 00 30 f5 12 00 0...0...@f..0...
0x0012f514 b9 9c 42 00 30 1e f0 00 - 40 66 f0 00 02 00 02 c0 ..B.0...@f......
0x0012f524 88 3e f0 00 01 00 00 00 - 01 00 00 00 5c f5 12 00 .>..........\...
0x0012f534 35 fb 40 00 40 68 f0 00 - 01 00 00 00 01 00 00 00 5.@.@h..........
0x0012f544 40 68 f0 00 30 1e f0 00 - 00 00 00 00 ec e5 46 00 @h..0.........F.
0x0012f554 dc e5 46 00 00 00 00 00 - 0c ff 12 00 16 11 40 00 ..F...........@.
0x0012f564 88 3e f0 00 90 16 40 00 - f0 16 40 00 80 17 40 00 .>....@...@...@.
0x0012f574 20 18 40 00 c0 18 40 00 - 10 19 40 00 20 1a 40 00 .@...@...@. .@.
0x0012f584 b0 1a 40 00 00 1c 40 00 - a0 1c 40 00 50 1d 40 00 ..@...@...@.P.@.
0x0012f594 e0 1d 40 00 70 1e 40 00 - b0 1f 40 00 00 00 00 00 ..@.p.@...@.....
0x0012f5a4 60 20 40 00 c0 22 40 00 - 30 22 40 00 50 24 40 00 ` @.."@.0"@.P$@.
0x0012f5b4 f0 20 40 00 90 21 40 00 - b0 23 40 00 f0 24 40 00 . @..!@..#@..$@.
0x0012f5c4 a0 25 40 00 30 26 40 00 - c0 26 40 00 f0 27 40 00 .%@.0&@..&@..'@.
0x0012f5d4 90 28 40 00 00 00 00 00 - 00 00 00 00 00 00 00 00 .(@.............
0x0012f5e4 05 00 00 00 48 53 4e 41 - 56 00 00 00 00 00 00 00 ....HSNAV.......
0x0012f5f4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f604 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f614 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f624 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f634 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f644 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f654 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f664 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f674 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f684 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f694 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f6a4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f6b4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f6c4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f6d4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f6e4 00 00 00 00 25 6f 2f 74 - 67 34 6d 73 71 6c 2f 61 ....%o/tg4msql/a
0x0012f6f4 64 6d 69 6e 00 00 00 00 - 00 00 00 00 00 00 00 00 dmin............
0x0012f704 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f714 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f724 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f734 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f744 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f754 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f764 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f774 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f784 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f794 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f7a4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f7b4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f7c4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f7d4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f7e4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f7f4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f804 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f814 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f824 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f834 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f844 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f854 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f864 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f874 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f884 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f894 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f8a4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f8b4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f8c4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f8d4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f8e4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f8f4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f904 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f914 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f924 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f934 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f944 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f954 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f964 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f974 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f984 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f994 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f9a4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f9b4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x0012f9c4 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
------------------- End of Raw Stack Dump ----------------

[billclinton8]

------------------- HS Context Dump -----------------------
MACHINE WORKGROUP\ZHANGYI
PROCESS 3668:4216
PROGRAM tg4msql.exe
OS USER SYSTEM
AGENT_TYPE 7
PROCESS CONTEXT :
Number of dispatchers using tcp 0
Current number of dispatchers 0
Max number of dispatchers 0
Addr of Arr of ptrs to dispatcher ctxs 00000000
Current number of user-sessions 1
Max number of user-sessions 1
Addr of array of ptrs to session ctx 00F067FC
Current number of task threads 1
Max number of task threads 1
Addr of array of ptrs to task ctx 00F0680C
Addr of external Procedure process conconst char 00F027C4
Pointer of environment handle 00ED08E8
Pointer of error handle 00F02880
Is agent multi-threaded 0
Pointer to HOLT conconst char 0
ARGC of main() call 2
ARGV of main() call (LOCAL=NO)
Should we retry registration 0
Address of listener
Program manager conconst char 003980F0
File I/O ctx for LFI module 00398190
Ptrs to HOA routines 0012F568
Ptrs to module entry points 00F027F4
Opaque ptr to NPD global 627796E0
Ptr to NCR Global 00F02644
Ptr to NLS global area 00ED0978
Ptr to exception list 00000000
Connect address of monitor
Shutdown thread conconst char 00000000
Buffer with init file data 00000000
Length of init file data buffer 0
LFI path object for Init file 00000000
LFI name object for init file 00000000
LFI handle for init file 00000000
Mode in which file is open 0
Parse info for init file 00000000
Init file related flag 0
Common task virtual circuit queue 0
Timezone information 00E72050
Pointer to driver system conconst char 00000000
Pointer to the agent PGA 00ED0E50
Pointer to main agent heap 00ED46B0
Agent version in const char format 10.2.0.1.0
USER SESSION CONTEXT :
Current number of user-sessions 1
User Session [0]
Pointer to process ctx 00F03E88
Pointer to virtual handling 00000000
Pointer to ctx of task thread 00F01E30
Ptr to user session extproc ctx 00F098E8
Index of session [0] 15767784
Flags indicating session[0] state: 2
Pointer to OCI Session handle : 00F062C8
Pointer to session conconst char error handle: 00F05D20
Pointer to OCI Service handle 00000000
Pointer to OCI OCI Server handle 00000000
Pointer to Remote Operations conconst char 00F06640
Negotiated semantics version 0
Remote user name of session [0]
Pointer to the queue of init parameters 00000000
Pointer to hash table for hoadas used in datatype conversions 00000000
Pointer to table of dty conversion funcs 00000000
Pointer to table of array of datatype capabilities 00000000
Max HO datatype ID for session [0] 0
Default FDS numeric datatyp for session [0] 0
Max FDS rowid length for session [0] 0
Opaque ptr to exception list for session [0] 00000000
Have driver defaults been set for session [0] 0
Char set of Oracle database for session [0] 0
National char set of Oracle database for session [0] 0
Char set the agent is running in for session [0] 0
Char set of FDS driver for session [0] 852
National char set on driver side for session [0] 852
Driver compiler char set for session [0] 0
Currently enabled trace level for session [0] 0
Error message text from driver for session[0] 0110DB08
Length of error message from driver for session [0] 26
Session key 1 for session [0] 0
Session key 2 for session [0] 0
Pointer to trasaction ID for session [0] 00000000
Buffer for XA open info string for session [0] 00F07EF4
Buffer for XA close info string for session [0] 00F07FF4
First character set ID for conversion 0
Second character set ID for conversion 0
Conversion ratio for character set 1 to 2 0
Conversion ratio for character set 2 to 1 0
Ptr to user area for session [0] 00000000
Ptr to second user area for session [0] 00000000
Piece data buffer for session [0] 00000000
Piece data buffer length for session [0] 0
Piece data number bytes for session [0] 0
Piece data offset in buffer for session [0] 0
Piece column's knl csid for session [0] 0
Piece column's drv csid for session [0] 0
Ptr to NLS global area for session [0] 00ED0978
Ptr to mta transaction id for session [0] 00000000
TASK TREAD CONTEXT :
Current number of task threads 1
------------------- End of HS Context Dump ----------------

[Kobayashi]

友情帮顶。。
你的题目太长。。看得头晕。。

[睿智天成]

没遇到过这种情况，待高手前来解答，帮顶!

[mjpok]

碰到跟你一样的情况 期待高手解决！

[ahalf]

PORT =1522