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

Oracle 11.1.1.9 BI AdminTool Physical Connection Pool

Zambrtp72

We need to change the Data source name in the physical layer of the RPD to Protocol tcps and port 2484. The connection fails. We know it is setup correctly because all the jdbc datasouces in OBIEE are using the tcps and 2484 settings.

Has anyone been successful in implementing this?

Find more posts tagged with

Accepted answers

All comments

Andrew Fomin.

Hi. I think you should provide a little bit more information on your problem. Right now it is very similar to "we have changed something, nothing works now". What was your previous setup? What have you changed? What do you want to achieve? Some relevant screenshots or logs could be useful too.

Zambrtp72

The database connection will only be accessible from 2484 TCPS. I need to change that connection string in the picture. The rest of the OBIEE internal and external communication is already SSL only. The JDBC DataSources database connection have also been changed to 2484 TCPS. However when I try to change the data source name ( which is what the RPD connection pool calls its database connection string) to TCPS port 2484 instead of TCP 1521 nonssl protocol the database can not make a connection.

Gianni Ceresa

Are you sure it's as simple as just putting a "s" in your protocol (and changing the port) ?

Don't you have to define anything else to make it work?

I guess to secure a JDBC connection you also need some settings as system properties or JSBC connection properties, so you maybe need some extra pieces to connect using OCI as well.

Ask your DBA what he would put in a tnsnames.ora to define that connection (and maybe try adding it there for OBIEE so in the connection pool you just put the tns name value instead of the full connection string.

Zambrtp72

I tried the tnsnames.ora , and sqlnet.ora file in OBIEE...I also tried adding the wallet in the connection string...Also tried creating a new ODBC connection with our custom keystores. Does anyone have any experience with doing this? This is the last huddle in switching our system to 100% SSL only ports.

Zambrtp72

The datasources are JDBC connections those we already have connecting at TCPS 2484.

Gianni Ceresa

Yeah, but OBIEE use a direct OCI connection (a lot better than JDBC) ...

Did you try googling on how you are supposed to configure an OCI connection to be SSL?

Right now I can't remember I saw somewhere all the data connections in SSL, so can't point you directly to a doc link for that. But as you can set OBIEE to be fully SSL (even between components etc.) I'm kind of sure it must accept sources being SSL as well, it's why I guess it's more about configuring it correctly ...

Zambrtp72

I opened an SR, according to them there is no documentation. I was hoping someone figured it out.

handat

You are using OCI libraries. In order for OCI to be able to connect it needs a wallet with trusted certificates from the DB imported.

Zambrtp72

I have a wallet, tnsnames.ora, sqlnet.ora ...I have tried using the wallet parameter in the connection string. Do you have specific instructions on how to accomplish this?