Oracle Analytics Publisher

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

installation problem

Received Response
76
Views
14
Comments

Morning folks. I'm reaching out cause I am having an issue installing OAP. It fails consistently at configure_bi_components.sh ssi

OS Red Hat 64bit 8.10

Database 19.22

java version "1.8.0_431"

OAS 7

INFO: Getting new DataSource through DataSourceFactory
Dec 04, 2024 2:12:31 PM com.oracle.bi.datasource.DomainHomeDataSourcePropertiesFile readDatasourceProperties
INFO: Reading config from /u02/app/oracle/fmw12214/fmw_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)
at oracle.ucp.common.Core.start(Core.java:2416)
at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:690)
at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129)
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:962)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:2013)
at oracle.ucp.jdbc.PoolDataSourceImpl.access$500(PoolDataSourceImpl.java:206)
at oracle.ucp.jdbc.PoolDataSourceImpl$31.build(PoolDataSourceImpl.java:4368)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1969)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1932)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1917)
at oracle.bi.servicelcm_v2.support.flyway.DatabasePreparation.getDatabaseType(DatabasePreparation.java:59)
at oracle.bi.servicelcm_v2.support.flyway.DatabasePreparation.getMigrationFilesLocation(DatabasePreparation.java:47)
at oracle.bi.servicelcm_v2.support.flyway.DatabasePreparation.<init>(DatabasePreparation.java:43)
at oracle.bi.servicelcm_v2.db.DatabaseServiceLcmApi.<init>(DatabaseServiceLcmApi.java:286)
at oracle.bi.servicelcm_v2.db.DatabaseServiceLcmApi.<init>(DatabaseServiceLcmApi.java:42)
at oracle.bi.servicelcm_v2.db.DatabaseServiceLcmApi$Builder.build(DatabaseServiceLcmApi.java:213)
at oracle.bi.servicelcm_v2.support.weblogic.WebLogicDatabaseServiceLcmApiBuilder.build(WebLogicDatabaseServiceLcmApiBuilder.java:59)
at oracle.bi.servicelcm_v2.ServiceLcmApi$DelegatingBuilder.build(ServiceLcmApi.java:123)
at oracle.bi.servicelcm_v2.DefaultServiceLcmApi$Builder.build(DefaultServiceLcmApi.java:74)
at oracle.bi.util.ServiceLCMAPIUtil.<init>(ServiceLCMAPIUtil.java:44)
at oracle.bi.util.ServiceLCMAPIUtil.getInstance(ServiceLCMAPIUtil.java:78)
at oracle.bi.util.ServiceLCMAPIUtil.getInstance(ServiceLCMAPIUtil.java:52)
at oracle.bi.util.BISecurityCoreUtils.getBITempDir(BISecurityCoreUtils.java:161)
at oracle.bi.security.mapping.BIContentStorageHelper.upgradeMappingContent(BIContentStorageHelper.java:122)
at oracle.bi.security.opss.policy.MappingUpgrade.main(MappingUpgrade.java:35)
Dec 04, 2024 2:12:31 PM com.oracle.bi.security.plugins.config.BISecurityConfigPlugin updateBootstrapRoleDefinitions
INFO: Mapping upgrade result: Mapping content is absent in associated setup
Exception in thread "main" java.lang.RuntimeException: Mapping content is absent in associated setup
at com.oracle.bi.security.plugins.config.BISecurityConfigPlugin.updateBootstrapRoleDefinitions(BISecurityConfigPlugin.java:192)
at com.oracle.bi.security.plugins.config.BISecurityConfigPlugin.update(BISecurityConfigPlugin.java:138)
at com.oracle.bi.schema.plugin.pluginrunners.ConfigPluginRunner.lambda$executeUpdateApi$0(ConfigPluginRunner.java:28)
at com.oracle.bi.schema.plugin.pluginrunners.ConfigPluginRunner.runPlugin(ConfigPluginRunner.java:154)
at com.oracle.bi.schema.plugin.pluginrunners.ConfigPluginRunner.lambda$runActionOnAllConfigPlugins$4(ConfigPluginRunner.java:139)
at java.lang.Iterable.forEach(Iterable.java:75)
at com.oracle.bi.schema.plugin.pluginrunners.ConfigPluginRunner.runActionOnAllConfigPlugins(ConfigPluginRunner.java:136)
at com.oracle.bi.schema.plugin.pluginrunners.ConfigPluginRunner.executeUpdateApi(ConfigPluginRunner.java:28)
at com.oracle.bi.schema.plugin.entrypoints.OasConfigAssistantAndOacUpgrade.main(OasConfigAssistantAndOacUpgrade.java:76)

«1

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Jeremy D Smith

    You are getting Runtime null pointer Exception. Can you confirm below -

    1. Are you able to create your RCU DB with out any issue?
    2. Is it out of box installation or inplace upgrade?
    3. Is your domain configuration has been done with any issue?
    4. Is it Standalone OAP installation or Are you doing Enterprise Installation along with OAS BI application like /analytics and /dv ..etc?

    Regards,

    Arjun

  • Jeremy D Smith
    Jeremy D Smith Rank 2 - Community Beginner

    Thanks for your reply Mallikarjuna. Here are my answers.

    1. This occurs as I run rcu. See attachment
    2. Out of the box
    3. Looks ok to me. I installed the Middleware successfully and POAP then put the October 2024 patches on with spbat
    4. This is going to be standalone and just installing OAP
    5. In addition I have raised a SR with Oracle who have just told me to install OAP 2024 which doesn't help me because my vendor doesn't support it.
  • Jeremy D Smith
    Jeremy D Smith Rank 2 - Community Beginner
  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Jeremy D Smith

    Are you seeing any other error from installation log file ?

    Install<YYYY-MM-DD_HH-MM-SS>PM.log

    Regards

    Arjun

  • Jeremy D Smith
    Jeremy D Smith Rank 2 - Community Beginner

    I have attached the install log, thanks

  • Jeremy D Smith
    Jeremy D Smith Rank 2 - Community Beginner

    To me it looks like a database connection issue it is having, but it's all correct. Could there be some sort of encryption going on? thanks

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Jeremy D Smith

    Are you able to see any Error from below file?

    /u02/app/oracle/fmw12214/fmw_OAS_home/config2024-11-18_03-41-29PM/summary.txt

    Regards,

    Arjun

  • Jeremy D Smith
    Jeremy D Smith Rank 2 - Community Beginner

    Hi

    It looks ok to me

    cat /u02/app/oracle/fmw12214/fmw_OAS_home/config2024-11-18_03-41-29PM/summary.txt
    Configure
    Configuration
    Components
    Oracle Analytics Publisher
    New domain
    Domain Name: bi
    Domains Directory: /u02/app/oracle/fmw12214/fmw_domains
    Admin server (HTTP port 9505, HTTPS 9501, internal 9507)
    Managed server (HTTP port 9508, HTTPS 9503, internal 9509)
    Database
    Existing schemas
    Database type: ORACLE
    Connect string: dchrt03db:1668:hrtest
    Existing RCU prefix: OATEST
    Port Management
    Port range
    Port range start: 9500
    Port range end: 9999
    Application
    Archive: /u02/app/oracle/fmw12214/fmw_OAS_home/oui/mw/common/framework/bin
    Service Instance Key: ssi
    Service Instance Limit: 1
    Entry points
    WebLogic Console
    http://dchrt03.sjog.org.au:9505/console
    Fusion Middleware Control
    http://dchrt03.sjog.org.au:9505/em
    Publisher
    http://dchrt03.sjog.org.au:9508/xmlpserver
    Start configuration
    Start immediately

  • Karthik-Oracle
    Karthik-Oracle Rank 5 - Community Champion

    Hello,

    any solution found for this?

    I am also facing same..

  • Karthik-Oracle
    Karthik-Oracle Rank 5 - Community Champion

    Seems no DB connection issue..

    seems this issue has started from October Patch, now I did a test on our pods..

    I ran installation with old patch & it worked without any issue..

    however with october patch & even january patched installation is throwing out this issue..

    I have also posted a comparison of logs in