nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

ODBC Error in OBIEE Environment

3351806

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.

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.

What I have done for this problem.

Copy my tnsNames.ora files under the directories.

\MWHOME\Oracle_BI1\network\admin

and \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

From where should I start?

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

Find more posts tagged with

Accepted answers

All comments

Ana GH

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]

+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

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

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

SERVICE_NAME = MYSID

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

Ana GH

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

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

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.