Ora_setup in spUtil gets cored, and even running ora_setup.exe manually also failed with 'Segmentation fault' or core dump messages.
Aside from that, new installation for the second Oracle instance deesn't generate a connection.yaml in the proper location.
It is a product defect on 8.6.x.
Ora_setup failed to pick up the correct ORACLE_HOME information.
Workaround:
1. Get ST110746e ( sp_setup-8.6.1.005-ONEOFF-CR110746e.exe ) from Support
2. Please make sure to keep ORACLE_SID with the value SharePlex is pointing for the first time.
For example, if the ORACLE_SID=FIRST which SharePlex points for your first installation, please change it with FIRST then follow below procedures.
With ORACLE_SID=FIRST
a. port 2100 / Instance:FIRST
spUtil(ora_setup) + Activation will be successful
b. port 2200 / Instance:SECOND
Click 'Cancel' button when the ora_setup screen in spUtil is displayed.
spUtil(ora_setup/cancel/service creation) + ora_setup.exe -p2200 + service up + Activation
c. port 2300 / Instance:THIRD
Click 'Cancel' button when the ora_setup screen in spUtil is displayed.
spUtil(ora_setup/cancel/service creation) + ora_setup.exe -p2300 + service up + Activation
Status:
Issue resolved in hotfix. Additionally the steps above is necessary.