Import Database Connections into Oracle SQL Developer

These screenshot are from JDevelopers - 12c

1. Click on Window - Resources

2. In the Resources pallet - Click on Import to open the 'Import Catalogs and Connections' window.

3. Now browse to locate the *.rcx file containing connection details.

4. Then click on Import to import the connections.

SOA 12C Instance Auto Recovery

Instance Auto recovery is the functionality to recover the failed instances with in a stipulated time period. The Instances which are faulted and marked to be recovered can be recovered in a particular time.

At sometime it's a disadvantage if your instances are falling which might lead increase table spaces issue in soa-infra.

To overcome this, we need to change the recoveryConfig property as mentioned below:

STEPS

Login to Enterprise Manager and Go to SOA Administrator - BPEL Properties.

2. Click on 'More BPEL Configuration Properties'

3. Under RecoveryConfig --> RecurringScheduleConfig.

Update the MaxMessageRaiseSize to 0.

Deployment over different environments

Use ORAMDS for all XSD / WSDL files on the project (oramds:...) in all composite.xml and wrappers in location tag. Doing that you will guarantee that you can deploy anywhere even when you don't have remote access to a environment. 

Also, in this way it is not necessary to change endpoints in composite.xml during compilation time (by script for instance) then use configuration plans.

Cheers!!