external procedure 를 사용해야 되는데요 ;;
ORA-28575: unable to open RPC connection to external procedure agent 라는 에러가 발생하네요 .
google 검색을 해보니.
$ORACLE_HOME/hs/admin 디렉토리에 extproc.ora 파일 SET EXTPROC_DLLS=ANY 로 수정을 하고. GRID리스너 사용시에는 $GRID_HOME/hs/admin extproc.ora 파일 SET EXTPROC_DLLS=ANY 로 수정을 하면 된다고 하던데요 ;;
왜 수정을 해줘도 사용을 못할까요 ;;
[$> cd $ORACLE_HOME/hs/admin
[$] /ssw/oracle/product/11.2.0/hs/admin > cat extproc.ora
SET EXTPROC_DLLS=ANY
SET LD_LIBRARY_PATH=/ade/aime_rdbms_795450/timesten/TTBuild/aix64_dbg/install/lib:/ade/aime_rdbms_795450/odbc/public/osds/unixODBC/lib:/usr/dt/lib:/ade/aime_rdbms_795450/rdbms/lib:/ade/b/3076717525/oracle/lib:/ade/aime_rdbms_795450/ctx/lib:/ade/aime_rdbms_795450/javavm/utl/ejb/unix/lib:/ade/aime_rdbms_795450/dbjava/lib:/usr/ucblib::/usr/lib
[$] /ssw/oracle/product/11.2.0/hs/admin > cd /ssw/crs/hs/admin
[$] /ssw/crs/hs/admin > cat extproc.ora
SET EXTPROC_DLLS=ANY
SET LD_LIBRARY_PATH=/ade/aime_rdbms_795450/timesten/TTBuild/aix64_dbg/install/lib:/ade/aime_rdbms_795450/odbc/public/osds/unixODBC/lib:/usr/dt/lib:/ade/aime_rdbms_795450/rdbms/lib:/ade/b/3076717525/oracle/lib:/ade/aime_rdbms_795450/ctx/lib:/ade/aime_rdbms_795450/javavm/utl/ejb/unix/lib:/ade/aime_rdbms_795450/dbjava/lib:/usr/ucblib::/usr/lib
[$] /ssw/crs/hs/admin >
[$] /usr/ssw/crs/hs/admin > sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Sep 19 10:56:13 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
10:56:13 sys@SQL> select TEST.ok from dual;
select dbgeneral.ok from dual
*
ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
어느 부분을 더 확인을 해야되는지 혹시 아시는분 있으신가요 ?