Oracle Service Bus Deployment and Remove the Deployed OSB Components

The deployment process is:

1.     Open the Oracle Service Bus (OSB) (http://osb-as-vip.soa-{deployment-environment}.bcc.qld.gov.au:7001/sbconsole) and login using an admin account

2.     On the left navigation bar, Change Center, click Create to create a new session

3.     On the left navigation bar, click System Administration

4.     On the left navigation bar, click Import Resources

5.     Click Browse

6.     Select the deployment archive (.jar) file (dart-application-sbconfig-01.01.00.jar)

7.     Click Next

8.     Click Import

9.     On the left navigation bar, click Execute Customization File

10.  Click Browse

11.  Select the deployment customisation file ({deployment-environment}-dart-application-osb-customization-01.01.00.xml)

11.1        If the following files are not attached to a relevant ITSM7 task, extract them from the Development PVCS project (\\pvcs-prd\pvcs\Development) in the location /Application/Component/Service/dart-application/deployment

dart-application-sbconfig-01.01.00.jar
{deployment-environment}-dart-application-osb-customization-01.01.00.xml

Ensure the revisions labelled with the version label 01.00.00 are the revisions that are extracted.

11.2        A separate deployment customisation file will exist for each target environment. The customisation file for each environment will contain the appropriate settings for that environment.

Environment	Customisation File
DEV	dev-dart-application-osb-customization-01.01.00.xml
TST	tst-dart-application-osb-customization-01.01.00.xml
UAT	uat-dart-application-osb-customization-01.01.00.xml
PRD	prd-dart-application-osb-customization-01.01.00.xml

12.  Click Next

13.  To ensure that only the newly loaded items are altered, select the check box Only Items Changed In Current Session.

14.  Click Execute

15.  On the left navigation bar, Change Center, click Activate to create a new session

16.  Enter the description of: Deployment of DART Application Component Service OSB component revision 01.01.00.

17.  Click Submit

Process to Remove the Deployed OSB Components

1.     Open the Oracle Service Bus (OSB) (http://osb-as-vip.soa-{deployment-environment}.bcc.qld.gov.au:7001/sbconsole) and login using an admin account

2.     On the left navigation bar, Change Center, click View Changes.

3.     Identify the update to be rolled back using the description and execution time to assist.

4.     In the Options column, click the Click to undo this task icon.

5.     The update will now have a task status of Undone.

SOA Composite Deployment and Remove the Deployed Composite

The deployment process is:

1.     Open the Oracle Enterprise Manager (EM) (http://soa-as-vip.soa-{deployment-environment}.com:7002/em) and login using an admin account

2.     On the left navigation bar, click WebLogic Domain > soa_domain.

3.     Right click soa_cluster.

4.     Select SOA Deployment > Deploy

5.     Select the Service archive (SAR) file (sca_dart-application-composite_rev01.01.00.jar)

6.     Select the Configuration Plan file (({deployment-environment}-dart-application-composite_cfgplan-01.01.00.xml)

6.1  If the following files are not attached to a relevant ITSM7 task, extract them from the Development PVCS project (\\pvcs-prd\pvcs\Development) in the location /Application/Component/Service/dart-application/deployment

sca_dart-application-composite_rev01.01.00.jar
({deployment-environment}-dart-application-composite_cfgplan-01.01.00.xml

Ensure the revisions labelled with the version label 01.01.00 are the revisions that are extracted.

6.2  A separate deployment customisation file will exist for each target environment. The customisation file for each environment will contain the appropriate settings for that environment.

Environment	Customisation File
DEV	dev-dart-application-composite_cfgplan-01.01.00.xml
TST	tst-dart-application-composite_cfgplan-01.01.00.xml
UAT	uat-dart-application-composite_cfgplan-01.01.00.xml
PRD	prd-dart-application-composite_cfgplan-01.01.00.xml

7.     Select Next

8.     Select the WebLogic cluster (Farm_soa_domain/soa_domain/soa_cluster) to deploy the composite

9.     Select Next

10.  Confirm that the application will deploy as default revision

11.  Select Deploy

12.  Check the displayed message for any errors.

         Process to Remove the Deployed Composite

1.     Open the Oracle Enterprise Manager (EM) (http://soa-as-vip.soa-{deployment-environment}.com:7002/em) and login using an admin account

2.     On the left navigation bar, click WebLogic Domain > soa_domain.

3.     Right click soa_cluster.

1.     Select SOA Deployment > Undeploy

4.     Select the radio box to the left of the composite to be rolled back.

5.     Click the Next button.

6.     Click the Undeploy button.

7.     Check the displayed message for any errors.

SOA Database Adapter Configuration

1. In the left navigation bar, click Deployments.
2. Click the DbAdapter application (click the name, not the checkbox)
3. Click the Configuration tab, and then click the Outbound Connection Pools tab.
4. Click New
5. Select the radio button for javax.resource.cci.ConnectionFactory and click Next
6. Enter the JNDI Name: eis/db/dart_application_csvc/dart_application_csvc
7. Click Finish
8. Click the Configuration tab, then click the Outbound Connection Pools tab,
and expand the connection factory and click the connection pool eis/db/dart_application_csvc/dart_application_csvc (click on the name, not the checkbox)
9. Select the box to the far right of dataSourceName. An edit box will appear
10. Type in the data source name jdbc/dart_application_csvc/dart_application_csvc.
11. Press the ENTER key to apply the value.
12. Select Save.
13. Click Deployments in the left navigation bar.
14. Select the checkbox next to DbAdapter.
15. Click Update.
16. Select Redeploy this application and confirm the deployment plan location.
17. Click Finish
18. Confirm that the connection pool is added by accessing  DbAdapter >Configuration > Outbound Connection Pools and expanding the connection factory details.
19. Confirm the value of the xADataSource property.

SOA Datasource Configuration

1. Open the Web Logic Server (WLS) console (http://soa-as-vip.soa-{deployment-environment}.com:7002/console) and login using an admin account
2. On the left navigation bar, click Services > JDBC > Data Sources.
3. In the data source table, click New.
4. Enter the data source information
5.1 Name: jdbc/dart_application_csvc/dart_application_csvc
5.2 JNDI Name: jdbc/dart_application_csvc/dart_application_csvc
5.3 Database Type: Oracle
5.4 Check the Database driver is the  correct driver: Oracle’s Driver (Thin) for Instance connections
6. Click Next
7. Untick the Supports Global Transactions checkbox.
8. Click Next
9. Enter the database information based on the database configuration details table in 4.1.
10.1 Database Name: Relevant environment database SID (Column SID in the table)
10.2 Host name: Relevant environment database host name (Column Host in the table)
10.3 Port: Relevant environment database port number (Column Port in the table)
10.4 Database user name: DART_APP_CSVC
10.5 Database user password: Consult DBA for details
11. Click Next
12. Check the entered details and then click Test Configuration. Confirm success message at top of page.
13. Click Next
15. Select the target cluster (soa_cluster) where the SOA component is running.
15. Click Finish