Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ODBC Error in OBIEE Environment

Received Response
71
Views
8
Comments
3351806
3351806 Rank 1 - Community Starter
edited Aug 13, 2024 6:00PM in Oracle Analytics Cloud and Server

I have some problems in my environment of OBIEE 11.1.1.7. ( On Linux )

I have tried some random ways to figure out but I thought to get help from experts as I am not expert in such environment.

Problem 1:  ODBC Error comes up with opening Analytics page.

ODBCError.PNG

What I have done for to resolve this.

1 - Find out the underlying user In repository and unlock it.

Then I get this error.

Invalid Username and password.

Problem 2:  Bi admistrator gives error right away.

RepDNSError.PNG

What I have done for this problem.

Copy my tnsNames.ora files under the directories.

D:\MWHOME\Oracle_BI1\network\admin

and D:\MWHOME\oracle_common\network\ADMIN

Edit: User.cmd file to put path of tnsNames.ora file.

Problem 3: I really don't know what to check with ODBC Connection. I don’t' know the password either

DNSAdminError.PNG

From where should I start?

These problems are taking my days because I am not very expert in such environment.

Answers

  • Ana GH
    Ana GH Rank 3 - Community Apprentice

    Problem 1: Ask your team or the DB team for the user password, if nobody knows it, then you'll have to change it, but other users/applications/tools will be affected by that change.

    Problem 2: You'll need to be sure of the correct information to connect to the database before trying to import metadata to the RPD, to be sure that the information in the variables OLAP_XXX and the password is correct, try first connecting with SQL Plus/ SQL Developer or the tool of your choice and once you are sure of the correct information, check the configuration in RPD.

    Problem 3: That is the information to connect to the RPD online, you'll need weblogic user password, or another user with the correct privileges to connect online.

    Regards

    ANA GH

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    +1 to Ana. That's a pure connectivity issue where you

    a) MUST know the password for that user and

    b) make sure that the user account hasn't been locked on the DB: https://www.google.com/search?q=ora-28000

    ORA-..... errors always clearly point to a database issue

  • 3351806
    3351806 Rank 1 - Community Starter

    Thaks.

    I checked with Weblogic User and password.

    The problem 3: Is solved.

    Now Problem 2:

    I tried with multiple ways.  Creating new fresh repository. Data source and correct password of schema that I can login with SQL developer tool. And I tried "Data Source Name" multiple ways of tnsNames entries e.g direct and like this

    DESCRIPTION =   (ADDRESS = (PROTOCOL = TCP)(HOST = Myhost)(PORT = 1521))   (CONNECT_DATA =    (SERVER = DEDICATED)  (SERVICE_NAME = MYSID))

    But it gives error right away like it's not considering any values.

  • Gianni Ceresa
    Gianni Ceresa Mod

    As you managed to connect the the RPD in "online" mode (as you fixed problem 3), did you find which user the RPD is using to connect to the database?

    Simply ask your DBA to unlock that user and, if password changed or you are unsure also change it.

    Or your only issue now is that you can't connect to your database with the wizard to import metadata?

    As you had multiple issues it isn't easy to clearly understand what you are now trying to do ...

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    SERVICE_NAME = MYSID

    SID is not the same as Service Name ....

  • Ana GH
    Ana GH Rank 3 - Community Apprentice

    Besides checking up the SERVICE_NAME information, , there's something else missing:

    (DESCRIPTION =   (ADDRESS = (PROTOCOL = TCP)(HOST = Myhost)(PORT = 1521))   (CONNECT_DATA =    (SERVER = DEDICATED)  (SERVICE_NAME = MYSID)))

  • 3351806
    3351806 Rank 1 - Community Starter

    Thanks guys with hints I have figured out Problem 2 and problem 3. Once I solve Problem 1 then I will post full procedure and steps collectively I have performed.

    Here are the important information regarding Problem 1.

    I have found Database user name and correct password that has been configured in RPD file. Lets say the user name is REP_DWH

    1 - Database Case sensitive property is true. I checked with.

    Show parameter Set Sec_Case_Sensitive_Logon;

    That can be reason that some times it says Invalid user and Password. I made it false for the time being.

    2 - When I try to login with Analytics Link. The user REP_DWH gets locked automatically. That results to spread "Account locked" Every where in my Dashboards. (I don't know this behavior).

    And I am using weblogic Username and password.

    I can't figure out the logic. Is that programmed by previous Admin/programmer or it's default behavior.

    When I try to login with Analytics link, quickly I checked the status of account it has been updated from OPEN to LOCKED.

    I think it should not be done. When I open the link, it should load repositories with right credentials and obviously with OPEN state.

  • Ana GH
    Ana GH Rank 3 - Community Apprentice 
    3351806 wrote:2 - When I try to login with Analytics Link. The user REP_DWH gets locked automatically.

    That problem looks like the password for user REP_DWH in then Connection Pool in the RPD is not correct.