Upgrading

Upgrading and Patching

Upgrade Assumptions

Do not use the PROCESSIT Installation Wizard when upgrading. The Wizard is for first time install only.

If you upgrade PROCESSIT using linux server as installation server, you need to run in an X environment, for example VMWare Console, VNCViewer, or putty/xMing.

Full Installation Upgrade

1. Create an installation folder, for example /oracle/install and unpack the PROCESSIT software package to the created folder. The software is packaged as a .zip archive and can be extracted with many archive extraction applications, including unzip, 7zip and winrar. The extracted installation folder is referred to as [inst.root] in this document.
2. Edit the properties file [inst.root]/config/processit.properties to reflect your environment settings. There are explanations for each property as comments above the respective property. Alternatively, you can copy the property file from a previous install into the [inst.root]/config/ directory.
3. Launch the installer. Navigate to [inst.root] and run the installation command:
   • Linux: sh install.sh
   • Windows: install.bat
4. Verify properties in Configuration Tab prior to performing the components installation.
5. Components installation. On the Installation tab of the installer window, click Install all to install all components. If any errors occur, double-click the component to see the log. When the problem has been resolved, select the individual components and click Install.
6. Restart the Oracle SOA Suite.
7. Restart the WebLogic server.

The log from the installation is in [inst.root]/installer/installer.log

Troubleshooting

It sometimes happens during an upgrade that the PROCESSIT installer hangs when installing D4_UTIL. The installer log after some time shows ERROR 2014-03-10 07:28:55,862 -0400 (ComponentsInstallationPanel.java:457) - ORA-04021: timeout occurred while waiting to lock object.

It is often due to a job D4.MV_REFRESH_JOB running, and the situation can be remedied.

Log in to the PROCESSIT Database with sqlplus as user D4 and issue the command:

	DECLARE
	  BEGIN
		 BEGIN
			SYS.DBMS_SCHEDULER.DISABLE(NAME=>'D4.MV_REFRESH_JOB', FORCE => TRUE);
		 EXCEPTION
		 WHEN OTHERS THEN
			NULL;
		END;
	  BEGIN
		 SYS.DBMS_SCHEDULER.STOP_JOB(JOB_NAME=>'D4.MV_REFRESH_JOB', force => true);
	  EXCEPTION
		WHEN OTHERS THEN
			NULL;
		END;
	END;
	/
			

Next retry the component installation in the PROCESSIT Installer Window.