Cloning a PROCESSIT Environment

Cloning a PROCESSIT Environment

It is recommended to Clone the Virtual Machine.

Please note that when cloning a virtual environment, there is no guarantee that running invoice workflows will continue with success.

Attachments previously imported to Accounts Payable via PROCESSIT [source] will always point back to the [source] PROCESSIT Weblogic servlet in the Oracle E-Business Suite.

Source to target

Clone the Virtual Machine

Access the VMware environment via the vSphere client.

1. Shutdown the [source] machine.
2. Right Click on [source] machine.
3. Select Clone.
4. Add a name for the clone.
5. Select Folder.
6. Click Next.
7. Select Cluster / Host on ESX Servers.
8. Click Next.
9. Select Storage.
10. Click Next.
11. Select Power on.
12. Click Next.
13. Review the summary
14. Click Finish.

You can now start [source].

[target] is starting up.

Log in to [target] with the console or ssh

The [target] Machine should have an IP Address and registration in DNS.

Environment Transition

Modify the following files so they correspond to the [target] settings.

/etc/host

The entry for readsoft.servers.ebs must be changed from pointing to [source] to point to [target]

	172.20.1.98  readsoft.servers.ebs    oracle98.readsoft.local #XX
			

/oracle/as/product/10.1.3.1/OracleAS_1/j2ee/oc4j_soa/config/data-sources.xml

The entry for D4_OEBS_APPS_POOL must be changed from pointing to [source] to point to [target]

Also verify username and password for connection: APPS or XXD4_APPS

	<connection-pool name="D4_OEBS_APPS_POOL">
		<connection-factory
		factory-class="oracle.jdbc.pool.OracleDataSource"
		 user="XXD4_APPS"
		 password="XXD4_APPS"
		 url="jdbc:oracle:thin:@readsoft.servers.ebs:1521:RS198"/>
		

/oracle/as/product/10.1.3.1/OracleAS_1/j2ee/oc4j_soa/applib/EBSAdapter.xml

The entry must be changed from pointing to [source] to point to [target]

Also verify username and password for connection: APPS or XXD4_APPS

	<?xml version="1.0" encoding="UTF-8"?>
	<properties>
		<property Name="log.file" Value="/usr/tmp/EBSAdapter.log"/>
		<property Name="database.drv" Value="oracle.jdbc.driver.OracleDriver"/>
		<property Name="database.url" Value="jdbc:oracle:thin:@readsoft.servers.ebs:1521:rs198"/>
		<property Name="database.usr" Value="xxd4_apps"/>
		<property Name="database.pwd" Value="xxd4_apps"/>
		<property Name="cache.InactivityTimeout" Value="600"/>
		<property Name="cache.AbandonedTimeout" Value="900"/>
		<property Name="cache.PropertyCheckInterval" Value="900"/>
	</properties>
			

/oracle/db/app/oracle/product/11.2.0/dbhome_1/network/admin

The entry must be changed from pointing to [source] to point to [target]

	EBSDB  =
	  (DESCRIPTION =
		(ADDRESS_LIST =
		  (ADDRESS = (PROTOCOL = TCP)(HOST = readsoft.servers.ebs)(PORT = 1521))
		)
		(CONNECT_DATA =
		  (SERVICE_NAME = XXXXX)
		)
	  )
			

Weblogic jdbc/D4_OEBS_APPS

Log on to WebLogic console and change the jdbc connection for D4_APPS_OEBS

It is safest to do this on the server in WMWare Console, using localhost.

Standard username and password is weblogic and weblogic1.

1. Click Lock & Edit.
2. Click Data Sources.
3. Select to modify D4_OEBS_APPS.
4. Click Connection Pool.
5. URL, username & password should be modified.
6. Click Save.
7. Click Activate Changes.
8. Click Logout.
9. Stop SOA
10. Stop Weblogic

Modify Database link in PROCESSIT Database

Log on to the PROCESSIT database as D4/D4 (may not be neccessary), and perform these commands using ssh:

	. oraenv
	sqlplus d4/d4
			

	drop public database link ebsdb
	create public database link ebsdb connect to APPS identified by <APPSPW> using 'EBSDB';
			

Alternative:

	create public database link ebsdb connect to XXD4_APPS identified by <XXD4_APPSPW> using 'EBSDB';
			

If APPS (or XXD4_APPS has the same password in DEV and PROD), keep the database link.

1. Start Weblogic
2. Start SOA

Change Configuration Parameters

You must change all configuration parameters that are pointing to the DNS Name.

1. Log on to PROCESSIT DEV as a user that can access Configuration Manager.
2. Change any parameter that is pointing to PROD to point to DEV.

Most of the parameters that require changes are found in the category URL.