My Oracle Support Banner

OAC: An Analysis Fails With ORA-01017 Error When The Data Model Is Built On A Connection As The SYS User (Doc ID 2431567.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle Analytics Cloud - Classic - Version N/A to N/A [Release 14.1]
Information in this document applies to any platform.

Symptoms

1. Create a Connection to a Database instance, connecting as the SYS user
    For example:  Login to OAC (/dv/ui) > Navigator > Console > Connections > New Connection ... Connect As: SYS AS SYSDBA

2. Create a Data Model via the Thin Client Modeller (TCM), using the Connection created
    For example:  Login to OAC (/dv/ui) > Navigator > Data > Page Menu > Manage Models > Create Model ... Select the Connection above

3. Create an Analysis on the Data Model, once the design is completed
    For example:  Login to OAC (/dv/ui) > Open Classic Home > New - Analysis ... Select columns etc.

4. Navigate to the Results tab to run the Analysis, and see the following error is thrown:

Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17025. [nQSError: 17025] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied at OCI call OCISessionBegin. (HY000)
State: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: ...

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.