🚀 go-pugleaf

Hi there!
I faced some critical problem when I try to compile oracle pl/sql procedure.
In my program, I should use external c procedure in pl/sql.

I am currently using oracle 8.1.5(oracle 8i) and want to use external
procedure

As a first step, I configured listener.ora tnsnames.ora file as follows :

# LISTENER.ORA Configuration
File:/sktdata/oracle/app/oracle/product/8.1.5/netwo
rk/admin/listener.ora
# Generated by Oracle Net8 Assistant

SID_LIST_SKT2 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /sktdata/oracle/app/oracle/product/8.1.5)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = wig_test)
      (ORACLE_HOME = /sktdata/oracle/app/oracle/product/8.1.5)
      (SID_NAME = SKT2)
    )
  )

SKT2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 211.39.x.xxx )(PORT = 1521))
      )
    )
    (DESCRIPTION =
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = 211.39.x.xxx)(PORT = 2481))
    )
  )


and tnsnames.ora file as follows :

# TNSNAMES.ORA Configuration
File:/sktdata/oracle/app/oracle/product/8.1.5/netwo
rk/admin/tnsnames.ora
# Generated by Oracle Net8 Assistant

WIG_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
      (ADDRESS = (PORTOCOL = IPC)(KEY = PNP))
      (CONNECT_DATA =
      (SERVICE_NAME = wig_test)
    )
  )

and after configured I run listener and I got the following message :

LSNRCTL> service skt2
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   DEC OSF/1 AXP Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=211.39.x.xxx)(PORT=1
521)))
Services Summary...
  SKT2          has 2 service handler(s)
    DEDICATED SERVER established:22 refused:0
      LOCAL SERVER
    DISPATCHER established:0 refused:0 current:0 max:254 state:ready
      D000 <machine: skt2.netsgo.com, pid: 20512>
      (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx)(PORT=2145))
      Presentation: oracle.aurora.server.SGiopServer
The command completed successfully

--------------------------------------------------------------------

Finally, when I run my external procedure , I got the following error
message :

>>>>An error occurred while the cartridge performed authorization check.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Thanks for reading!
Best regards!




--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
��� �ż��� (Thiat Shin)
thiatvil@yahoo.com
http://www.thiat.pe.kr/
thiat : AOL Instant Messenger
"�ų���,������,�ٸ��� ����"