请教一个oracle用PL/SQL调用程序的问题 怎么没有人回答这个问题的?难道真的那么难吗?高手都到哪里去了啊????为什么会出现这样的错误:unable to open RPC connection to external procedure agent有没有哪位仁兄有成功的例子的??急 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 还是没有回复………………csdn实在是让我太失望了!!! 我的问题解决了:经过本人两个礼拜的实践,发现以上例子中一个错误:Tnsnames.ora文件和Listener.ora文件应该如下设置:Tnsnames.ora:192.168.0.1=(DESCIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=1521)))(CONNECT_DATA=(SID=orcl)))EXTPROC_CONNECTION_DATA=(DESCRIPTION =(ADDRESS =(PROTOCOL=ipc)(KEY=orcl))(CONNECT_DATA = (SID=orcl)))Listener.oraLISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.1 )(PORT = 1521))) ))EXTERNAL_PROCEDURE_LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = orcl)))))SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = orcl)(ORACLE_HOME = /usr/local/ora8i)))SID_LIST_EXTERNAL_PROCEDURE_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = orcl)(ORACLE_HOME = /usr/local/ora8i)(PROGRAM = extproc)))启动监听程序时,先进入/usr/loacle/ora8i/bin 下,运行lsnrctl (监听控制文件),在LSNRCTL> 提示符下输入 start EXTERNAL_PROCEDURE_LISTENER 回车确保看到一下提示信息:Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(key=orcl)))STATUS of the LISTENERAlias EXTERNAL_PROCEDURE_LISTENER Version TNSLSNR for Linux: Version 8.1.7.0.0 - ProductionStart Date 14-APR-2005 15:04:30Uptime 3 days 19 hr. 12 min. 53 secTrace Level offSecurity OFFSNMP OFFListener Parameter File /usr/local/ora8i/network/admin/listener.oraListener Log File /usr/local/ora8i/network/log/listener.logServices Summary...orcl has 1 service handler(s)The command completed successfully说明监听启动成功,(一定要看到orcl has 1 service handler(s))如果监听启动不成功,建议重起oracle数据库,然后启动监听,如果还不行,我就没办法了(本人就是无意中重起oracle数据库才成功的,呵呵)顺便说一下,我遇到的出错信息是:ERROR 位于第 1 行:ORA-28575: unable to open RPC connection to external procedure agentORA-06512: at "SYSTEM.SQUAREFUNC", line 0ORA-06512: at line 2如果有遇到同样麻烦的人,希望这个帖子能给你一些帮助。 你的这个用法,说实话,很少有人用的。而且也没有必要。可以参考Oracle专家编程里的一些说法。要取一些最佳方案。 请大家帮忙分析一个函数 删除重复记录 游标的声明和定义能够分开吗?新鸟求教 如何用9i客户端导出10g的数据 请教一个增长率的SQL,谢谢 连接多会有性能问题么? 查询重复记录问题 关于存储过程的参数问题?急!急!急! 咨询:关于Oracle9i的问题! 一个访问多个数据库的问题 数据库varchar2字段写入问题,数组老被截断,请大家帮忙啊,很急的!!!!! pro*c数据类型问题
经过本人两个礼拜的实践,发现以上例子中一个错误:Tnsnames.ora文件和Listener.ora文件应该如下设置:Tnsnames.ora:192.168.0.1=
(DESCIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=1521))
)
(CONNECT_DATA=(SID=orcl)
)
)EXTPROC_CONNECTION_DATA=
(DESCRIPTION =
(ADDRESS =(PROTOCOL=ipc)(KEY=orcl))
(CONNECT_DATA = (SID=orcl))
)Listener.oraLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.1 )(PORT = 1521))
) )
)EXTERNAL_PROCEDURE_LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = orcl))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /usr/local/ora8i)
)
)SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /usr/local/ora8i)
(PROGRAM = extproc)
)
)
启动监听程序时,先进入/usr/loacle/ora8i/bin 下,运行lsnrctl (监听控制文件),在
LSNRCTL> 提示符下输入 start EXTERNAL_PROCEDURE_LISTENER 回车确保看到一下提示信息:Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(key=orcl)))
STATUS of the LISTENERAlias EXTERNAL_PROCEDURE_LISTENER
Version TNSLSNR for Linux: Version 8.1.7.0.0 - Production
Start Date 14-APR-2005 15:04:30
Uptime 3 days 19 hr. 12 min. 53 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /usr/local/ora8i/network/admin/listener.ora
Listener Log File /usr/local/ora8i/network/log/listener.log
Services Summary...
orcl has 1 service handler(s)
The command completed successfully说明监听启动成功,(一定要看到orcl has 1 service handler(s))如果监听启动不成功,建议重起oracle数据库,然后启动监听,如果还不行,我就没办法了(本人就是无意中重起oracle数据库才成功的,呵呵)顺便说一下,我遇到的出错信息是:ERROR 位于第 1 行:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "SYSTEM.SQUAREFUNC", line 0
ORA-06512: at line 2如果有遇到同样麻烦的人,希望这个帖子能给你一些帮助。
而且也没有必要。可以参考Oracle专家编程里的一些说法。
要取一些最佳方案。