was anyone able to resolve the issue. We are having the same problem with the api call in OAS2025. Worked perfectly fine in OAS6.4 Thanks, Paami

select count(*),program from gv$session where LAST_CALL_ET > 600 and status = 'INACTIVE' group by program; rcu COUNT(*) PROGRAM 1 oraagent.bin@pdoradbadm02.eprod.com (TNS V1-V3) 1 java.lang.Thread 8 Oracle REST Data Services 2 com.informatica.jdbc.oraclebase.ddae 1 JDBC Thin Client datawarehouse COUNT(*) PROGRAM 1 JDBC…

we ran the query select count(*),program from gv$session where LAST_CALL_ET > 600 and status = 'INACTIVE' group by program; when we had the issue today. Just gets 6 records. rcu COUNT(*) PROGRAM 1 oraagent.bin@pdoradbadm02.eprod.com (TNS V1-V3) 1 java.lang.Thread 8 Oracle REST Data Services 2…

We ran the select count(*),program from gv$session where LAST_CALL_ET > 600 and status = 'INACTIVE' group by program; when we had the issue today. Get only 6 records rcu COUNT(*) PROGRAM 1 oraagent.bin@pdoradbadm02.eprod.com (TNS V1-V3) 1 java.lang.Thread 8 Oracle REST Data Services 2 com.informatica.jdbc.oraclebase.ddae 1…

Thank you so much Mostafa for the update. Nothing is crashing right now. Will run the query you provided when issue occurs. We already have DEFAULT_DB_MAX_EXEC_TIME = 3600 MARKING_QUERY_MAX_LOGICAL_QUERY_EXEC_TIME = 120 Also added the following to the instanceconfig.xml. Let's see what tomorrow brings us. <Query>…

Hi Steve, Thank you for responding. Here is my response. Update to the latest patched client tools —- working on it Clean diagnostic dump after the issue reproduces to assist in narrowing the issue/ check for any crashes, etc. - yes, yesterday i provided the diagnostic dump from last few days. —-We will limit it to the…

We did not make any other changes. Thanks,

Hi Steve, Thank you to everyone for all your help. We finally fixed the issue. It is quite wierd. One of the connection pools in the rpd was not checked for Enable Connection Pooling. We just tried that. That fixed the issue. Possible exadata was keeping all those sessions and not releasing them. Did not happen in earlier…

Hi Christian, We see these cache entries. When we run the command netstat -a | grep -i established | wc -l, the sessions are increasing to > 2000. Thanks, Paami.

Hi Christian, When we open the rpd online, we see these session of users which last used = Never. Even after we purged these sessions, we had to restart the obis1 and obips1. It is just not making any sense to us as well. Attached is a screenshot. Thanks, Paami

We have been able to pin point the issue. Sessions are created and not cleared. When we open the rpd online, there are more than 2000 sessions. Once we clear the sessions, we are able to login. Issue still continuing. Any suggestions where we need tweaking. Thanks, Paami.

Hi Steve, The SR# is SR 3-36907909631. As per the engineer, all the log files are clear. However, we are seeing "Authn token passed to the ObUserSession constructor is null or invalid." raw_code^201" in our webgate.log file. All the patches are up to date. We are still experiencing the same issue at least 2-3 times a day.…

Hi Steve, We have an SR with Oracle and it is going nowhere. We keep seeing a broken pipe error. Users are stuck in the Signining in screen. For users logged in, and running reports, the system is hung. We are stopping and starting the obis1 and obips1. Today we had to do it 3 times already. Loading the log files. Any help…

Thank you Steve for responding. How do i move to OAS channel. For Exadata, its not a clone. we take a final back up after you shutdown your app, and restore that DB to exadata