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
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
This indicates there is connectivity issues with the database… this could be username/password, firewall, SSL connection, database configuration, network timeout, bad network hardware, etc. There is a slight chance the jdbc.url syntax is not correct in the jps-config.xml, but that is unlikely. I suggest you start with some basics: netcat to check access to database port check database sqlnet.ora for configuration potentially, install sql*developer on the OAS server and make a connection with JDBC
Please work with your DBA
@User_XVFC1
1- Please check the DB User's password if it does have special Characters if yes please try to change the User and schema password to NOT have any special characters
2- Make sure your DB User does have SYSDBA Privileges .
3- Double check the Firewall to allow connection between OAS & DB Servers on DB Port
Hi @Mostafa Morsy-Oracle & @SteveF-Oracle
Thank you.
2. On the firewall, we are still checking we haven't seen anything on that yet
3. Also changing the password of the RCU schema password, now getting the errors below
@Eugene_A_O
The Problem now with the schema Already used Caused by: com.oracle.cie.domain.security.external.ConfigSecurityException: oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: The schema NEWOASDEV_OPSS is already in use for security store(s). Please create a new schema
Expanding on Mostafa reply, you can also run the RCU manually to delete (clean up) the RCU schemas created, so that you can then create them again with the same name (but a different password if your original password didn't follow the requirements and limitations for a RCU schema password).
Hi,
I tried with a new schema
Can you ask your DBA to create the RCU Schema with SYS User during the configuration with password only have _ as special character
Please share the solution if you resolved the OAS configuration issue.
@Shekar-Oracle challenge still persists
@Eugene_A_O , so the issue isn't solved? Because the thread is marked as answered (and that's why it doesn't get any attention anymore).
Was the reply marked as "correct" (best answer) not the correct one? I can unmark it for you if you want, that will "reopen" the thread marking it as not answered.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…