Categories
installation problem
Answers
-
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.
0 -
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 DataSourceFactorycom.oracle.bi.datasource.DomainHomeDataSourcePropertiesFile readDatasourcePropertiesINFO: Reading config from /u01/oracle/user_projects/domains/bi/config/fmwconfig/bienv/core/datasource.propertiesException 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 DataSourceFactorycom.oracle.bi.datasource.DomainHomeDataSourcePropertiesFile readDatasourcePropertiesINFO: Reading config from /u01/oracle/user_projects/domains/bi/config/fmwconfig/bienv/core/datasource.propertiescom.oracle.bi.datasource.OracleUcpBiplatformDataSourceFactory createFINE: Creating UCPcom.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..
0 -
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)
0 -
I would suggest you need to raise an SR to team to get the fix for the issue.
Regards,
Arjun
0
