Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
The system cannot find the path specified. The system cannot find the path specified.
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
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
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 😉
Same problem here.. Any solution?
Thanks everyone.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |