Hi, I am installing Oracle Analytic Server 7.0 on linux. On running the config.sh file in bi/bin/, I am getting the error below.
@Gianni Ceresa I have been able install it now by having the database and the application on the same server as a work around.
Thank you
Hi,
Any chance that you can open the log file (the path is right there in your screenshot) and post back the full error message? The screenshot only show part of it, therefore nothing can really be said.
Also: what linux distribution and version are you installing on?
On a different topic: this OAS version will still have 8-9 months of support only. If you don't plan on upgrading in the coming months, you should consider installing OAS 7.6 (aka 2024) directly (it has 20-21 months of support still).
Thanks. Linux version is REH 8.10
See below logs
2024-08-12 12:22:46,078 INFO [38] oracle.bi.exec.ExecScript - Executing: [/usr/app/Oracle/Middleware/Oracle_Home/oracle_common/common/bin/wlst.sh, /usr/app/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/biee.py, /usr/app/Oracle/Middleware/Oracle_Home, /usr/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi, weblogic, example.com, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//ip:port/SID, BIDEV, jdbc:oracle:thin:@//ip:port/SID, ] 2024-08-12 12:22:46,078 INFO [38] oracle.bi.exec.ExecScript - Logging script stderr and stdout to /usr/app/Oracle/Middleware/Oracle_Home/config2024-08-12_12-19-10PM/biee.log 2024-08-12 12:24:30,507 INFO [38] oracle.bi.install.config.basesteps.BIActionStep$1 - Failed single shot step: Oracle Analytics Server with: Execution of /usr/app/Oracle/Middleware/Oracle_Home/oracle_common/common/bin/wlst.sh /usr/app/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/biee.py /usr/app/Oracle/Middleware/Oracle_Home /usr/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi weblogic example.com 9502 9503 ORACLE oracle.jdbc.OracleDriver jdbc:oracle:thin:@//ip:port/SID BIDEV jdbc:oracle:thin:@//ip:port/SID failed with exit value 1 2024-08-12 12:24:30,507 SEVERE [38] oracle.bi.install.config.actions.BIConfigAction - Non-skipped failure during configuration action: Execution of /usr/app/Oracle/Middleware/Oracle_Home/oracle_common/common/bin/wlst.sh /usr/app/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/biee.py /usr/app/Oracle/Middleware/Oracle_Home /usr/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi weblogic example.com 9502 9503 ORACLE oracle.jdbc.OracleDriver jdbc:oracle:thin:@//ip:port/SID BIDEV jdbc:oracle:thin:@//ip:port/SID failed with exit value 1 oracle.bi.exec.ExecutionStatusException: Execution of /usr/app/Oracle/Middleware/Oracle_Home/oracle_common/common/bin/wlst.sh /usr/app/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/biee.py /usr/app/Oracle/Middleware/Oracle_Home /usr/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi weblogic example.com 9502 9503 ORACLE oracle.jdbc.OracleDriver jdbc:oracle:thin:@//ip:port/SID BIDEV jdbc:oracle:thin:@//ip:port/SID failed with exit value 1 at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:106) at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191) at oracle.bi.exec.ExecScript.executeSynchronousScript(ExecScript.java:95) at oracle.bi.exec.ExecWLST.executeWLSTScript(ExecWLST.java:62) at oracle.bi.install.config.steps.WLSTStep.executeSingleShot(WLSTStep.java:55) at oracle.bi.install.config.basesteps.SingleShotActionStep.execute(SingleShotActionStep.java:31) at oracle.bi.install.config.basesteps.StepList.execute(StepList.java:85) at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:137) at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:412) at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:99) at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:122) at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15) at oracle.as.install.engine.modules.configuration.action.RequestQueue.performSequentialExecution(RequestQueue.java:339) at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:315) at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:198) at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:82) at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:87) at java.lang.Thread.run(Thread.java:750) 2024-08-12 12:24:30,508 INFO [38] oracle.bi.configassistant.config.actions.main.BIConfigMain - Collecting diagnostic information following startup failure. See log file: /usr/app/Oracle/Middleware/Oracle_Home/config2024-08-12_12-19-10PM/jpsOnFailedStartup.out 2024-08-12 12:24:30,508 INFO [38] oracle.bi.exec.ExecScript - Executing: [jps, -l] 2024-08-12 12:24:30,508 INFO [38] oracle.bi.exec.ExecScript - Logging script stderr and stdout to /usr/app/Oracle/Middleware/Oracle_Home/config2024-08-12_12-19-10PM/jpsOnFailedStartup.out 2024-08-12 12:24:30,633 INFO [38] oracle.bi.install.config.actions.BIConfigAction$1 - Zipping up config assistant log files to /usr/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/bilogs/bieeconfiglogs_2024-08-12_12-19-10PM.zip 2024-08-12 12:24:30,635 INFO [38] oracle.bi.install.config.actions.BIConfigAction$1 - Zipping up the following log files and directories: /usr/app/Oracle/Middleware/Oracle_Home/install2024-08-12_12-19-10PM.log /usr/app/Oracle/Middleware/Oracle_Home/config2024-08-12_12-19-10PM
2024-08-12 12:24:30,650 INFO [38] oracle.bi.install.config.actions.BIConfigAction$1 - Completed zipping up log files to /usr/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/bilogs/bieeconfiglogs_2024-08-12_12-19-10PM.zip on host example.com 2024-08-12 12:24:30,653 SEVERE [38] oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager - One or More configurations failed. Exiting 2024-08-12 12:24:30,655 SEVERE [38] oracle.sysman.oii.oiio.oiiol.OiiolTextLogger - java.lang.Exception: One or More configurations failed. at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:205) at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:82) at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:87) at java.lang.Thread.run(Thread.java:750) Caused by: java.lang.IllegalStateException: Action:Oracle_Analytics_Configuration failed with error:Configure BI Failed with Execution of /usr/app/Oracle/Middleware/Oracle_Home/oracle_common/common/bin/wlst.sh /usr/app/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/biee.py /usr/app/Oracle/Middleware/Oracle_Home /usr/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi weblogic example.com 9502 9503 ORACLE oracle.jdbc.OracleDriver jdbc:oracle:thin:@//ip:port/SID BIDEV jdbc:oracle:thin:@//ip:port/SID failed with exit value 1 at oracle.as.install.engine.modules.configuration.client.ConfigAction.fail(ConfigAction.java:288) at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:148) at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:412) at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:99) at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:122) at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15) at oracle.as.install.engine.modules.configuration.action.RequestQueue.performSequentialExecution(RequestQueue.java:339) at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:315) at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:198) ... 3 more
2024-08-12 12:24:30,655 SEVERE [38] oracle.as.install.engine.logging.EngineLogUtils - One or More configurations failed. java.lang.Exception: One or More configurations failed. at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:205) at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:82) at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:87) at java.lang.Thread.run(Thread.java:750) Caused by: java.lang.IllegalStateException: Action:Oracle_Analytics_Configuration failed with error:Configure BI Failed with Execution of /usr/app/Oracle/Middleware/Oracle_Home/oracle_common/common/bin/wlst.sh /usr/app/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/biee.py /usr/app/Oracle/Middleware/Oracle_Home /usr/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi weblogic example.com 9502 9503 ORACLE oracle.jdbc.OracleDriver jdbc:oracle:thin:@//ip:port/SID BIDEV jdbc:oracle:thin:@//ip:port/SID failed with exit value 1 at oracle.as.install.engine.modules.configuration.client.ConfigAction.fail(ConfigAction.java:288) at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:148) at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:412) at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:99) at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:122) at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15) at oracle.as.install.engine.modules.configuration.action.RequestQueue.performSequentialExecution(RequestQueue.java:339) at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:315) at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:198) ... 3 more 2024-08-12 12:24:30,656 INFO [38] oracle.as.install.engine.modules.statistics.standard.StandardInstallAdapter - Install Adapter: Mark End for:CONFIG 2024-08-12 12:24:30,656 INFO [38] oracle.as.install.engine.modules.statistics.standard.StandardInstallAdapter - Install Adapter: Mark End for:INSTALL 2024-08-12 12:24:30,657 INFO [38] oracle.as.install.engine.modules.statistics.standard.StandardInstallAdapter - Install Adapter: Mark End for:DEINSTALL 2024-08-12 12:24:30,657 INFO [38] oracle.as.install.engine.modules.statistics.standard.StandardInstallAdapter - Install Adapter: Mark End for:INTERVIEW 2024-08-12 12:24:30,657 INFO [38] oracle.as.install.engine.modules.statistics.standard.StandardInstallAdapter - Install Adapter: Mark End for:LINK 2024-08-12 12:24:30,657 INFO [38] oracle.as.install.engine.modules.statistics.standard.StandardInstallAdapter - Install Adapter: Mark End for:COPY 2024-08-12 12:24:30,657 INFO [38] oracle.as.install.engine.modules.presentation.PresentationModule - Presentation Module Received Event Id: 12215 Event: CONFIG_MODULE_FINISH 2024-08-12 12:24:30,668 INFO [38] oracle.as.install.engine.datamodel.content.DataCenter$AbstractContent - Setting valueOf(IS CONFIGURATION SUCCESSFUL) to:false. Value obtained from:USER
Please ensure and confirm that Oracle JDK 1.8.0_341+ is being used for this installation.
Hi @User_HMAIF .
Welcome to the Oracle Analytics Online Forum! We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together! As per the logs, the connection to the RCU database is failing, you will need to correct that. Additionally, I agree with @Gianni Ceresa , if this is a new installation, then install OAS 2024, not OAS 2023 for the latest feature set and error correction support timeline.
Hi @SteveF-Oracle,
Thank you very much. I have downloaded and try installing OAS 2024, I am having the same error. Are there different ports involved during the RCU connection when running the oracle_home/bi/bin/config.sh? I am asking this because I am able to create the RCU when I run /Oracle_Home/oracle_common/bin/rcu.
I will be updating the profile as well
Hi @User_HMAIF You should be able to create RCU schemas by pre-creating with RCU or during the Configuration Assistant. Per, the original log post above for OAS 2023See log file: /usr/app/Oracle/Middleware/Oracle_Home/config2024-08-12_12-19-10PM/jpsOnFailedStartup.out Check your current failure logs to see if the same, if so, check the log it is referring to for additional details.
See log file: /usr/app/Oracle/Middleware/Oracle_Home/config2024-08-12_12-19-10PM/jpsOnFailedStartup.out
@User_HMAIF
Looks like the problem in DB settings or connection to DB
What is your Back-end DB & Version ?
As @SteveF-Oracle mentioned run RCU utility to create the RCU Schema and check the error you will get there
Hi @Mostafa Morsy-Oracle
The RCU schemas are created successfully. See below screenshot
Also, the database version is Oracle 19.
this is the logs from the biee.log
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
dbargs.py /usr/app/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/biee.py /usr/app/Oracle/Middleware/Oracle_Home /usr/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi weblogic epg-autoeod-01.ecobank.group 9502 9503 ORACLE oracle.jdbc.OracleDriver jdbc:oracle:thin:@//ip:port/sid NEWBIDEV jdbc:oracle:thin:@//ip:port/sid Reading passwords from stdin... Enter admin password Enter DBSchema password Extending domain with BIEE Suite template Configuring datasources ... Configuring LocalSvcTblDataSource to JDBC URL jdbc:oracle:thin:@//ip:port/sid user NEWBIDEV_STB Setting JDBC url to jdbc:oracle:thin:@//ip:port/sid Deleting old user of type Property Creating user of type Property at /JDBCSystemResource/LocalSvcTblDataSource/JdbcResource/LocalSvcTblDataSource/JDBCDriverParams/NO_NAME_0/Properties/NO_NAME_0 Master STB data source defined Initial BIPLATFORM datasource: jdbcURL jdbc:oracle:thin:@dbhost.example.com:port/orcl, schema name DEV_BIPLATFORM Aug 12, 2024 11:14:05 PM oracle.simplefan.impl.FanManager configure SEVERE: attempt to configure ONS in FanManager failed with oracle.ons.NoServersAvailable: Subscription time out Individual schema credentials applied from master STB data source STB modified BIPLATFORM datasource: jdbcURL jdbc:oracle:thin:@//ip:port/sid, schema name NEWBIDEV_BIPLATFORM Searching for datasources starting with NEWBIDEV_ with JdbcUrl jdbc:oracle:thin:@//ip:port/sid Candidate data source WLSSchemaDataSource url: jdbc:oracle:thin:@//ip:port/sid type: None user: NEWBIDEV_WLS_RUNTIME Updating data source WLSSchemaDataSource to use jdbc url jdbc:oracle:thin:@//ip:port/sid Candidate data source LocalSvcTblDataSource url: jdbc:oracle:thin:@//ip:port/sid type: None user: NEWBIDEV_STB Updating data source LocalSvcTblDataSource to use jdbc url jdbc:oracle:thin:@//ip:port/sid Candidate data source opss-data-source url: jdbc:oracle:thin:@//ip:port/sid type: None user: NEWBIDEV_OPSS Updating data source opss-data-source to use jdbc url jdbc:oracle:thin:@//ip:port/sid Candidate data source opss-audit-viewDS url: jdbc:oracle:thin:@//ip:port/sid type: None user: NEWBIDEV_IAU_VIEWER Updating data source opss-audit-viewDS to use jdbc url jdbc:oracle:thin:@//ip:port/sid Candidate data source opss-audit-DBDS url: jdbc:oracle:thin:@//ip:port/sid type: None user: NEWBIDEV_IAU_APPEND Updating data source opss-audit-DBDS to use jdbc url jdbc:oracle:thin:@//ip:port/sid Candidate data source biplatform_datasource url: jdbc:oracle:thin:@//ip:port/sid type: None user: NEWBIDEV_BIPLATFORM Updating data source biplatform_datasource to use jdbc url jdbc:oracle:thin:@//ip:port/sid Candidate data source mds-owsm url: jdbc:oracle:thin:@//ip:port/sid type: None user: NEWBIDEV_MDS Updating data source mds-owsm to use jdbc url jdbc:oracle:thin:@//ip:port/sid Final BIPLATFORM datasource: jdbcURL jdbc:oracle:thin:@//ip:port/sid, schema name NEWBIDEV_BIPLATFORM Setting Credentials ... Set system.user Aug 12, 2024 11:30:41 PM oracle.security.jps.az.internal.runtime.policy.AbstractPolicyImpl initializeReadStore INFO: Property for read store in parallel: oracle.security.jps.az.runtime.readstore.threads = null Error: runCmd() failed. Do dumpStack() to see details.
Problem invoking WLST - Traceback (innermost last): File "/usr/app/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/biee.py", line 20, in ? File "/usr/app/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/bieeimpl.py", line 57, in configureBIEE File "/tmp/WLSTOfflineIni4484182534152499421.py", line 143, in updateDomain File "/tmp/WLSTOfflineIni4484182534152499421.py", line 19, in command 64254: Error occurred in "Post Processing" phase execution 64254: Encountered error: oracle.security.opss.tools.lifecycle.LifecycleException: JPS-01055: Could not create credential store instance. Reason oracle.security.jps.JpsException: JPS-00027: There was an internal error: java.sql.SQLRecoverableException: No more data to read from socket 64254: Check log for more detail. null at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:69) at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:3085) at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:738) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498)
com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: Error updating domain: 64254: Error occurred in "Post Processing" phase execution 64254: Encountered error: oracle.security.opss.tools.lifecycle.LifecycleException: JPS-01055: Could not create credential store instance. Reason oracle.security.jps.JpsException: JPS-00027: There was an internal error: java.sql.SQLRecoverableException: No more data to read from socket 64254: Check log for more detail. null
