Migration of Oracle SOA Suite Composites

Migration of Oracle SOA Suite Composites from 11GR2PS3 to 12C

Follow the below steps:

--> Deploy the jar in 11g version to import in 12C version.

1) Open the SOA project in JDeveloper version 11.1.1.7.0 and create the SAR ( deployable) file into your deploy folder. ( Ex: scaProjectName_rev00*.jar )
2) Close the JDeveloper 11.1.1.7.0 and now open JDeveloper 12c.
3) File -> Import -> select "SOA Archive Into SOA Project" -> OK -> Next -> Composite Archive Browse to the above SAR file created ( Ex: scaProjectName_rev00*.jar )
4) The composite.xml and corresponding BPEL swim lanes will show the content now .

Note: To Deploy the Jar in 11gR2PS3 version we need to install the jDeveloper(11.1.1.7) then SOA extension separately to be installed either via offline file  (download available at OTN or through jDeveloper top menu >> Help >> Check for Updates >> SOA Extension.

unless, 12C Jdeveloper is readily available with QuickStart Installer(download available at https://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html). 

Issue:./sqlplus: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory

1) Run the below command :  ldd $ORACLE_HOME/bin/sqlplus

[oracle@ontoimd0bav101 instantclient]$ ldd $ORACLE_HOME/bin/sqlplus

linux-vdso.so.1 (0x00007ffccf3d8000)

libsqlplus.so => /opt/oneid/Oracle/Middleware/Oracle_OIM/instantclient/libsqlplus.so (0x00007f3d0d98c000)

libclntsh.so.18.1 => /opt/oneid/Oracle/Middleware/Oracle_OIM/instantclient/libclntsh.so.18.1 (0x00007f3d099ce000)

libclntshcore.so.18.1 => /opt/oneid/Oracle/Middleware/Oracle_OIM/instantclient/libclntshcore.so.18.1 (0x00007f3d093eb000)

libmql1.so => /opt/oneid/Oracle/Middleware/Oracle_OIM/instantclient/libmql1.so (0x00007f3d0918b000)

libipc1.so => /opt/oneid/Oracle/Middleware/Oracle_OIM/instantclient/libipc1.so (0x00007f3d08d19000)

libnnz18.so => /opt/oneid/Oracle/Middleware/Oracle_OIM/instantclient/libnnz18.so (0x00007f3d085c4000)

libdl.so.2 => /lib64/libdl.so.2 (0x00007f3d083c0000)

libm.so.6 => /lib64/libm.so.6 (0x00007f3d0803e000)

libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f3d07e1e000)

libnsl.so.1 => not found

librt.so.1 => /lib64/librt.so.1 (0x00007f3d07c16000)

libaio.so.1 => /lib64/libaio.so.1 (0x00007f3d07a13000)

libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f3d077fc000)

libc.so.6 => /lib64/libc.so.6 (0x00007f3d07439000)

libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f3d07221000)

libnsl.so.1 => not found

libons.so => /opt/oneid/Oracle/Middleware/Oracle_OIM/instantclient/libons.so (0x00007f3d06fd1000)

/lib64/ld-linux-x86-64.so.2 (0x00007f3d0dc80000)

libnsl.so.1 => not found

libnsl.so.1 => not found

 

You will see the missing packages

 

2) Install the libnsl

NOTE: to install this you need to have root user access

3) sudo su root

4) Yum install libnsl

5) dnf install libnsl.x86_64

 

Now that you have all the necessary package you will not see this error.

Basic Perfomance Tuning For stuck threads and response times

Documentation for performance tuning: https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/asper/redundant-cross-references-remo...