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

Oracle 11.1.1.9 BI AdminTool Physical Connection Pool

Received Response
31
Views
9
Comments
Zambrtp72
Zambrtp72 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:16PM in Oracle Analytics Cloud and Server

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?

Answers

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    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
    Zambrtp72 Rank 3 - Community Apprentice

    rpd.JPG

    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
    Gianni Ceresa Mod

    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
    Zambrtp72 Rank 3 - Community Apprentice

    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
    Zambrtp72 Rank 3 - Community Apprentice

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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    Zambrtp72 Rank 3 - Community Apprentice

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

  • handat
    handat Rank 5 - Community Champion

    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
    Zambrtp72 Rank 3 - Community Apprentice

    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?