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 = (protocol = TCP) (Host = 192.168.16.27)) (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) # =================== ====================== ============ and the tnsnames.ora must be like this: # =================== begin ======= ==================== ===================================================================== IPC) (Key = extproc) #must match the key of address_list in the listener.ora) (Connect_Data = (SID = plsextproc) # Sid Must Equals to the Sid_Name In The Listener.ora) # = ================== =============================== 2 Validate a. Validate a. Validate the program oracle_home / bin / extproc.exe, if Display those information # =========================== =
======= Oracle Corporation - - Wednesday November 03 2004 21: 02: 58.931heterogeneous agent release 9.0.1.1.1 # ==================== ===================, IT IS OK! B. Validate the Database Environment Compare The Listener.ora and Tnsnames.ora File Strictionly 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: # === ================================================== Document file : E: /oracle/ora90/network/admin/sqlnet.ora E: /oracle/ora90/neetwork/admin/tnsnames.ora
The TNSNames adapter has been used to parse alias attempting to contact (address = (address = (protocol = ipc))) (Connect_Data = (SID = plsextproc)) OK (20 milliseconds)) OK (20 milliseconds) ) # ====================================================================================== ing.
Now, Congratulation, You External Procedure Environment IS OK!
