Installation & Configuration of Oracle Application Server.greenspun.com : LUSENET : DBAzine : One Thread
I'm trying to install the application server in Windows2000 as OS. I'm facing problem with preinstalltion steps. It says that we have to add some a new listener for the external procedure in the origin database listener.ora. LISTENER_01= (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP) (HOST = MY_HOSTNAME) (PORT = 1521))
) (ADDRESS_LIST= (ADDRESS= (PROTOCOL = IPC) (KEY=EXTPROC0))
) ) )
and to verify that there is a SID for the external procedure listener in the listener's SID list. SID_LIST_LISTENER= (SID_LIST= (SID_DESC = (SID_NAME=PLSEXTPROC) (ORACLE_HOME=DSK1/ORACLE/RDBMS/ORAHOME) (PROGRAM=extproc) ) ,,,,,,,,
(SID_DESC = (GLOBAL_DBNAME = global_DBname) (ORACLE_HOME = /DSK1/ORACLE/RDBMS/ORAHOME) (SID_NAME =ias) ) )
in this case do we have to change anything in the SID_List_Listener, AND to which oracle home we should refer, and what is the sid in the first case and in the second case.
the other thing is that it said we have to to edit the tnsname.ora of the origin database by adding
(ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=EXTPROC0)) ) (CONNECT_DATA= SID=PLSExtProc)
Note: Is there any thing should be changed to mach our database or we should add it as it is.
-- Najla Nasser (email@example.com), October 27, 2002