Oracle Analytics Publisher

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

installation problem

Received Response
66
Views
14
Comments
2»

Answers

  • Rank 5 - Community Champion

    Seems only oracle development could answer this one.

    From your initial post it says:

    com.oracle.bi.datasource.DomainHomeDataSourcePropertiesFile readDatasourceProperties

    is failing due to:

    exception in thread "main" java.lang.NoSuchMethodError: oracle.jdbc.pool.OracleConnectionBuilderImpl.sslContext(Ljavax/net/ssl/SSLContext;)Loracle/jdbc/pool/OracleConnectionBuilderImpl;

    Which if the error logs are correct goes down to line 35 of MappingUpgrade.java:

    at oracle.bi.security.opss.policy.MappingUpgrade.main(MappingUpgrade.java:35)

    If your datasource.properties file under $DOMAIN_HOME/config/fmwconfig/bienv/core/datasource.properties

    looks good then oracle development should troubleshoot. Your java version seems ok.

    One last comment, since I'm seeing opss & security in the surrounding error messages, and that this also broadly appears to be related to DB connectivity. You need to ensure you don't have any specials/crazy characters in the ABDC_BIPLATFORM schema password. Try it again with only A-Z,0-9 if the password has anything else.

  • Rank 5 - Community Champion

    And this issue is random, over last week, I have seen both successful & failure scenarios..

    I have also confirmed password to have only alphanumeric & only these 2 symbols allowed underscore _ or hash #

    Failure, stops at:

    INFO: Getting new DataSource through DataSourceFactory

    com.oracle.bi.datasource.DomainHomeDataSourcePropertiesFile readDatasourceProperties

    INFO: Reading config from /u01/oracle/user_projects/domains/bi/config/fmwconfig/bienv/core/datasource.properties

    Exception in thread "main" java.lang.NoSuchMethodError: oracle.jdbc.pool.OracleConnectionBuilderImpl.sslContext(Ljavax/net/ssl/SSLContext;)Loracle/jdbc/pool/OracleConnectionBuilderImpl;

    at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:103)

    at oracle.ucp.common.Database.createPooledConnection(Database.java:256)

    at oracle.ucp.common.Topology.start(Topology.java:279)

    Successful, going good like:

    INFO: Getting new DataSource through DataSourceFactory

    com.oracle.bi.datasource.DomainHomeDataSourcePropertiesFile readDatasourceProperties

    INFO: Reading config from /u01/oracle/user_projects/domains/bi/config/fmwconfig/bienv/core/datasource.properties

    com.oracle.bi.datasource.OracleUcpBiplatformDataSourceFactory create

    FINE: Creating UCP

    com.oracle.bi.datasource.OracleUcpBiplatformDataSourceFactory create
    FINE: Setting connection properties {SendStreamAsBlob=true, user=OAS_BIPLATFORM, tnsAdmin=/dev/shm/wallet, oracle.net.CONNECT_TIMEOUT=10000}

    datasource.properties file is all good, that also validated..

  • Rank 5 - Community Champion
    edited Mar 3, 2025 8:34AM

    And one more observation, when I compare with our old setup, this patch p35847501_122140_Linux-x86-64.zip

    is removed at OAS level & applied before in fmw setup itself as this patch mentioned their,

    (now 37297691 OSS 19C BUNDLE PATCH),

    is this can be the reason?

    I feel this should not be the reason right, just the difference is patch applied at fmw itself before OAS installation..

    as this patch document also listing it for fmw itself..

    Oracle Support Document 2806740.2 (Critical Patch Update Advisor for Oracle Fusion Middleware - Updated for January 2025)

  • Rank 8 - Analytics Strategist

    Hi @Jeremy D Smith

    I would suggest you need to raise an SR to team to get the fix for the issue.

    Regards,

    Arjun

Welcome!

It looks like you're new here. Sign in or register to get started.