作者：未知 来源：月光软件站 加入时间：2005-2-28　月光软件站

How to depoly the environment of C External Oracle Procdure on Oracle Server?
  1. Deploy
  There are two files need to focus on: at ORACLE_HOME\network\admin\Listener.ora and tnsnames.ora
  The Listener.ora must be like this:
  #====================Begin=========================
  LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.27)(PORT = 1521))
      )
      (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(HOST = 192.168.16.27)(KEY = EXTPROC))#Map to the ADDRESS in tnsnames.ora
      )
    )
  )

  SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)#Map to the SID in tnsnames.ora
      (ORACLE_HOME = E:\oracle\ora90)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = lbs)
      (ORACLE_HOME = E:\oracle\ora90)
      (SID_NAME = lbs)
    )
  )
  #===================End============================
  And the tnsnames.ora must be like this:
  #===================Begin===========================
EXTPROC_CONNECTION_DATA.CASWSOFT.CASW.COM =
  (DESCRIPTION =
    (ADDRESS_LIST = #Map to the ADDRESS_LIST in the Listener.ora
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) #Must match the KEY of ADDRESS_LIST in the Listener.ora
    )
    (CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO))#SID must equals to the SID_NAME in the Listener.ora
  )
  #===================End==============================
  2. Validate
  a. Validate the program of External Procedure
      Execute ORACLE_HOME\bin\extproc.exe, if display those information
      #==================================
      Oracle Corporation --- 星期三 11月 03 2004 21:02:58.931

      Heterogeneous Agent Release 9.0.1.1.1
     #======================================
     ,it is OK!
  b. Validate the database environment
      Compare the Listener.ora and tnsnames.ora file strictly following to the sample listed on the head of this file.
  c. Validate the Listener
      Confirm the Listener.ora file is correct firstly.
      Then with command: tnspint extproc_connect_data.DEFAULT_DOMAIN(in this case is extproc_connect_data.caswsoft.casw.com), if the tip information is:
         #================================================
         已使用的参数文件:
         E:\oracle\ora90\network\ADMIN\sqlnet.ora
         E:\oracle\ora90\network\ADMIN\tnsnames.ora

        已使用 TNSNAMES 适配器来解析别名
        Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)
        (KEY = EXTPROC))) (CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO)))
        OK（20毫秒）
        #============================================
      it is Ok.

Now, Congratulation, you External Procedure environment is OK!

相关软件：