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

Direct Database Request results in ORA-12154: TNS:could not resolve the connect identifier specified

3240307

We are trying to create a test analysis using Direct Database Request and keep running into this error. We have checked the database details, the connection pool seems to be correct (Import Metadata works flawlessly) but when we use the same connection pool for the DDBR, it errors out with the above error.

Any pointers in where the issue could be?

OBIEE 11.1.1.9.0

Oracle 12.1.0.2 on Exadata

Find more posts tagged with

Accepted answers

All comments

Joel Acha

If you import your table into physical layer for test purposes, can you update the table count or select from it?

3240307

Yes I can, I can do both.

Joel Acha

How do you reference your connection pool in you DDR? Do you qualify it with the database name as defined in the physical layer?

for example:

"database name"."connection pool"

3240307

No, never had to do that before. Just use the name of the connection pool. You think that would help? With the quotes?

3240307

Just tried it, same error.

3310714

Are you running the Analysis and Import from the same workstation? How about your SID, does it need to be fully qualified? Orcl.abc.com instead of Orcl?

3240307

Yes I am, but how does that matter? When you ask if my SID "needs" to be fully qualified, how does that create the difference in behavior I'm talking about? I have tried both though and the error is the same.

3310714

The error message says it can't resolve the connect identifier. If it was another workstation getting this error, maybe they don't have the drivers installed. But since you're running from the same PC, that's not it.

I'd noticed before in my network, i had to use a fully qualified SID and server name. otherwise OBI doesn't connect to the DB.

can you supply screenshots?

3240307

It is only 1 application server so I'm still unsure as to how a "workstation" will make a difference. The server that hosts the application (OBIEE) has the drivera/client installed. I unfortunately cannot provide screenshots beyond what I've mentioned already. I can post logs etc though if you'd like anything in particular.

3310714

How are you defining your data source, using tnsnames.ora ((DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server.domain.com)(PORT=your_port)))(CONNECT_DATA=(SID = your_db))))

easyconnect (server:port/sid)?

have you tried both?