[INS-20802] Fallo de Oracle Services For Microsoft Transaction Server.

[thernandez]

Hello.

I'm new at Power BI, and I'm getting an issue in the installation. I installed Power BI Version: 2.48.4792.721 64-bit (julio de 2017) and I used  installing-the-oracle-client and downloaded ODAC121024_x64.zip client. I got the installation all right, but when it tries to configure the connection I get this error:

If Iook the logs I got this:

1. oraInstall2017-08-24_08-08-11PM.err

The system cannot find the path specified.
The system cannot find the path specified.

1. oraInstall2017-08-24_08-08-11PM.out

Encontrará el log de esta sesión de instalación en:
 C:\Program Files\Oracle\Inventory\logs\installActions2017-08-24_08-08-11PM.log
PersistEnv
PersistEnv

1. installActions2017-08-24_08-08-11PM.log (it's bigger thatn that, I only copy since the last "Successfully".

INFO: Successfully updated Transient Parameters in the Aggregates
INFO: Entering ConfigClient.getToolsList method
INFO: Selecting job named 'Oracle Services For Microsoft Transaction Server' for retry
INFO: Configuration log directory - C:\app\client\!81232563\product\12.1.0\client_1\cfgtoollogs
INFO: 
 The Runconfig command constructed is C:\app\client\!81232563\product\12.1.0\client_1\oui\bin\runConfig.bat ORACLE_HOME=C:\app\client\!81232563\product\12.1.0\client_1 MODE=perform ACTION=configure RERUN=true %*
INFO: Since the option is to overwrite the existing C:\app\client\!81232563\product\12.1.0\client_1\cfgtoollogs\configToolAllCommands file, backing it up
INFO: The backed up file name is C:\app\client\!81232563\product\12.1.0\client_1\cfgtoollogs\configToolAllCommands.bak.2
INFO: Entering ConfigClient.executeSelectedToolsInAggregate method
INFO: ConfigClient.executeSelectedToolsInAggregate oAggregate=oracle.odac.client:oracle.odac.client:12.1.0.2.0:common
INFO: Entering ConfigClient.assignAction method
INFO: ConfigClient.assignAction actionref=[Loracle.sysman.emCfg.common.IActionReference;@122638d0
INFO: ConfigClient.assignAction action is of type :configuration
INFO: Exiting ConfigClient.assignAction method
INFO: ConfigClient.executeSelectedToolsInAggregate action assigned
INFO: Started Plugin named: Oracle Services For Microsoft Transaction Server
INFO: Found associated job
INFO: Iniciando "Oracle Services For Microsoft Transaction Server"
INFO: Iniciando "Oracle Services For Microsoft Transaction Server"
INFO: MTSInternalPlugIn: ... adding </ouiinternal>
INFO: Executing MTS
INFO: Command C:\WINDOWS\system32\cmd /c call C:\app\client\!81232563\product\12.1.0\client_1\bin\oramtsctl.exe -new    -internal -new    -internal 
INFO: ... GenericInternalPlugIn.handleProcess() entered.
INFO: ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: ... GenericInternalPlugIn: checking secretArguments.
INFO: No arguments to pass to stdin
INFO: ... GenericInternalPlugIn: starting read loop.
INFO: Read: OracleMTSRecoveryService Control Utility: Version 12.1.0.0.0 - Production
ADVERTENCIA: Skipping line: OracleMTSRecoveryService Control Utility: Version 12.1.0.0.0 - Production
INFO: End of argument passing to stdin
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: Copyright (c) 2012, Oracle.  All rights reserved.
ADVERTENCIA: Skipping line: Copyright (c) 2012, Oracle.  All rights reserved.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: Usage:
ADVERTENCIA: Skipping line: Usage:
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: oramtsctl <-new|-delete|-start|-stop|-status|-config|-passwd|-trace|-trcdir>
ADVERTENCIA: Skipping line: oramtsctl <-new|-delete|-start|-stop|-status|-config|-passwd|-trace|-trcdir>
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:           [-host    <hostname|IP_address> ...]
ADVERTENCIA: Skipping line:           [-host    <hostname|IP_address> ...]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:           [-port    <number>]
ADVERTENCIA: Skipping line:           [-port    <number>]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:           [-ip      <IP_address>]
ADVERTENCIA: Skipping line:           [-ip      <IP_address>]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:           [-dtchost <DTC_hostname>]
ADVERTENCIA: Skipping line:           [-dtchost <DTC_hostname>]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:           [-cluster <on|off>]
ADVERTENCIA: Skipping line:           [-cluster <on|off>]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:           [-default]
ADVERTENCIA: Skipping line:           [-default]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:  -new    Create and start a new OracleOraClient12Home1MTSRecoveryService service.
ADVERTENCIA: Skipping line:  -new    Create and start a new OracleOraClient12Home1MTSRecoveryService service.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:  -delete [Oracle_home_directory]
ADVERTENCIA: Skipping line:  -delete [Oracle_home_directory]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:          Delete OracleMTSRecoveryService of current home or specified home.
ADVERTENCIA: Skipping line:          Delete OracleMTSRecoveryService of current home or specified home.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:  -start  Start OracleOraClient12Home1MTSRecoveryService service.
ADVERTENCIA: Skipping line:  -start  Start OracleOraClient12Home1MTSRecoveryService service.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:  -stop   Stop OracleOraClient12Home1MTSRecoveryService service.
ADVERTENCIA: Skipping line:  -stop   Stop OracleOraClient12Home1MTSRecoveryService service.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:  -status Query OracleOraClient12Home1MTSRecoveryService service status.
ADVERTENCIA: Skipping line:  -status Query OracleOraClient12Home1MTSRecoveryService service status.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:  -config [-port <number>] [-ip <IP_address>] [-dtchost <DTC_hostname>]
ADVERTENCIA: Skipping line:  -config [-port <number>] [-ip <IP_address>] [-dtchost <DTC_hostname>]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:          [-cluster <on|off>] [-default]
ADVERTENCIA: Skipping line:          [-cluster <on|off>] [-default]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:          Show or set OracleOraClient12Home1MTSRecoveryService service configuration.
ADVERTENCIA: Skipping line:          Show or set OracleOraClient12Home1MTSRecoveryService service configuration.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:          Use -default to reset OracleOraClient12Home1MTSRecoveryService configuration.
ADVERTENCIA: Skipping line:          Use -default to reset OracleOraClient12Home1MTSRecoveryService configuration.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:1 Total args:0
INFO: Read:  -passwd Update OracleOraClient12Home1MTSRecoveryService service user password.
ADVERTENCIA: Missing secret argument for -winServiceUserPassword
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:  -trace  [0-5]
ADVERTENCIA: Skipping line:  -trace  [0-5]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:          Show traces or set trace level. Set level 0 to turn off tracing.
ADVERTENCIA: Skipping line:          Show traces or set trace level. Set level 0 to turn off tracing.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:  -trcdir [trace_directory]
ADVERTENCIA: Skipping line:  -trcdir [trace_directory]
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:          Show or set trace directory.
ADVERTENCIA: Skipping line:          Show or set trace directory.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:  -host   <hostname|IP_address> ...
ADVERTENCIA: Skipping line:  -host   <hostname|IP_address> ...
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:          Execute operation on host(s) identified by name(s) or IP address(es).
ADVERTENCIA: Skipping line:          Execute operation on host(s) identified by name(s) or IP address(es).
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:          Local host is used if option not specified.
ADVERTENCIA: Skipping line:          Local host is used if option not specified.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:  -port   <number>
ADVERTENCIA: Skipping line:  -port   <number>
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:          Execute -new or -config with this option to specify a service port.
ADVERTENCIA: Skipping line:          Execute -new or -config with this option to specify a service port.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:          Service port is configured automatically if option not specified.
ADVERTENCIA: Skipping line:          Service port is configured automatically if option not specified.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:  -ip     <IP_address>
ADVERTENCIA: Skipping line:  -ip     <IP_address>
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:          Execute -new or -config with this option to specify an IP address.
ADVERTENCIA: Skipping line:          Execute -new or -config with this option to specify an IP address.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:  -default
ADVERTENCIA: Skipping line:  -default
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read:          Execute -new or -config with this option to set default configuration.
ADVERTENCIA: Skipping line:          Execute -new or -config with this option to set default configuration.
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: Examples:
ADVERTENCIA: Skipping line: Examples:
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: Install the service with automatic configuration:
ADVERTENCIA: Skipping line: Install the service with automatic configuration:
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: oramtsctl -new
ADVERTENCIA: Skipping line: oramtsctl -new
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: Install the service on port 2032:
ADVERTENCIA: Skipping line: Install the service on port 2032:
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: oramtsctl -new -port 2032
ADVERTENCIA: Skipping line: oramtsctl -new -port 2032
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: Configure the service to use port 2033:
ADVERTENCIA: Skipping line: Configure the service to use port 2033:
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: oramtsctl -config -port 2033
ADVERTENCIA: Skipping line: oramtsctl -config -port 2033
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:2 Total args:0
INFO: Read: Update the service user password:
ADVERTENCIA: Missing secret argument for -winServiceUserPassword
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:3 Total args:0
INFO: Read: oramtsctl -passwd
ADVERTENCIA: Skipping line: oramtsctl -passwd
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:3 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:3 Total args:0
INFO: Read: Install the service on several hosts and use uniform port 2033:
ADVERTENCIA: Skipping line: Install the service on several hosts and use uniform port 2033:
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:3 Total args:0
INFO: Read: oramtsctl -new -host host1 host2.domain.com host3 -port 2033
ADVERTENCIA: Skipping line: oramtsctl -new -host host1 host2.domain.com host3 -port 2033
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:3 Total args:0
INFO: Read: 
ADVERTENCIA: Skipping line: 
INFO: Exceeded the number of arguments passed to stdin. CurrentCount:3 Total args:0
INFO: Completed Plugin named: Oracle Services For Microsoft Transaction Server
INFO: Fallo de Oracle Services For Microsoft Transaction Server.
INFO: Fallo de Oracle Services For Microsoft Transaction Server.
INFO: ConfigClient.executeSelectedToolsInAggregate action performed
INFO: Exiting ConfigClient.executeSelectedToolsInAggregate method
INFO: 
 The Runconfig command constructed is C:\app\client\!81232563\product\12.1.0\client_1\oui\bin\runConfig.bat ORACLE_HOME=C:\app\client\!81232563\product\12.1.0\client_1 MODE=perform ACTION=configure RERUN=false %*
INFO: Since the option is to overwrite the existing C:\app\client\!81232563\product\12.1.0\client_1\cfgtoollogs\configToolFailedCommands file, backing it up
INFO: The backed up file name is C:\app\client\!81232563\product\12.1.0\client_1\cfgtoollogs\configToolFailedCommands.bak.1
INFO: Adding ExitStatus SUCCESS_MINUS_RECTOOL to the exit status set
INFO: ConfigClient.saveSession method called
INFO: Calling event ConfigSessionEnding
INFO: ConfigClient.endSession method called
INFO: Completed Configuration
INFO: Waiting for completion of background operations
INFO: Completed background operations
INFO: Validating view at state <setup>
INFO: Completed validating view at state <setup>
INFO: Validating state <setup>
ADVERTENCIA: [WARNING] [INS-32091] La instalación del software ha sido correcta, pero han fallado, se han cancelado o se han saltado algunos asistentes de configuración.
   ACCIÓN: Consulte los logs o póngase en contacto con los Servicios de Soporte Oracle.
INFO: Advice is CONTINUE
INFO: Completed validating state <setup>
INFO: Verifying route success
INFO: Get view named [FinishUI]
INFO: View for [FinishUI] is oracle.install.ivw.odac.view.FinishGUI@482b32f1
INFO: Initializing view <FinishUI> at state <finish>
INFO: Completed initializing view <FinishUI> at state <finish>
INFO: Displaying view <FinishUI> at state <finish>
INFO: Completed displaying view <FinishUI> at state <finish>
INFO: Loading view <FinishUI> at state <finish>
INFO: Install Succeeded: true
INFO: Config Tool Succeeded: false
INFO: Remote Install Succeeded: true
INFO: Completed loading view <FinishUI> at state <finish>
INFO: Localizing view <FinishUI> at state <finish>
INFO: Completed localizing view <FinishUI> at state <finish>
INFO: Waiting for completion of background operations
INFO: Completed background operations
INFO: Executing action at state finish
INFO: Completed executing action at state <finish>
INFO: Waiting for completion of background operations
INFO: Completed background operations
INFO: Moved to state <finish>
INFO: Dispose the current Session instance
INFO: Dispose the install area control object
INFO: Update the state machine to STATE_CLEAN
INFO: Finding the most appropriate exit status for the current application
INFO: Exit Status is 3
INFO: Shutdown ODAC 12c Release 4 (12.1.0.2) Installer

[mbore]

If anyone still having this problem, continue the installation despite the configuration of the oracle client error as shown up there. Once all installed, edit the tnsnames.ora file inside the client, for example: 

C:\app\client\User\product\12.2.0\client_1\Network\Admin 

There it may be added the conection string like this example:

MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname/ip address)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)

With all that done you can now add a new ODBC data source throug "control panel > administrative tools" using the oracle database credential access.

Hope it works for you 😉

[sirros_iot]

Same problem here.. Any solution?

Thanks everyone.

[v-ljerr-msft]

Hi @thernandez,

Here is an article about how to fix the INS-2802 error. Could you go to check if it helps in your scenario?

In addition, if the issue persists, I would suggest that you also post it on the Oracle Forum for better assistance. 

Regards