r/oracle

I work with Oracle Fusion Reporting, HCM Extracts, and FF, but other than using AI for queries, I really don’t know how else I should utilise AI. I want to work with something in AI, but as per my knowledge, Oracle is still building something substantial with AI. I know about text scan, document understanding, etc., but they really aren’t something groundbreaking now.

The way Claude and other AI models have been impacting the rest of the tech stack. I am confused about what the future holds for someone working with what I am working on.

We are encouraged to train AI in everything we do. How long till the replacement?

We have a legacy 32bit ERP Application from 2006 which is highly specialized and would be a huge lift to replace, financially and practically. The application was originally installed as administrator on WXP Pro SP3. We migrated it to W7 Pro, installed as administrator, and the only issue we had was local users group Users's permissions to the Program Files (x86)\Installation Directory needed to be bumped to Modify.

Now it's installed on W11 pro 24H2 as administrator, and the shortcut to launch the application is placed on \users\public\desktop. The backend for the app is Oracle 19c. Client is 11gR2. The app compatibility settings are at default. It works fine for all domain users.

From within the app, you can run Crystal Reports (XI) and print, export (to different formats, Excel and PDF are the most common), or preview the report to the screen, and then print or export from the preview screen. This all was working fine under W11Pro 24H2.

Our Windows updates are not under house control, so they are applied sporadically. Since the suspected trigger event 25H2, we've gotten a few (less than 10) tickets, where the user A chooses to preview a report, the preview screen appears, and then Crystal Reports asks for any required user input data, the Print button is clicked, and that’s it. The application stops responding, turns white, and then must be task killed. We’ve tried enabling logging in Crystal Reports with reg keys, but haven’t succeeded thus far in getting it to create logs. The application doesn’t write any logs we can find to the event viewer, and the only event recorded says xxxx.exe applicaion stopped responding. Application hang.

Troubleshooting, user A can print and preview on other workstations without issue. We’ve determined that it doesn’t have anything to do with which report file is called, they all hang equally. We think the hang is triggered by a call to the oracle client and are trying to get the Oracle Trace File Analyzer to look at some trc files we found on the workstation, and will continue to work that. As previously noted the backend is Oracle 19c, the workstation client is 11g. The application uses the 2.xx version of OCI. The user A can directly Print or Export the report (any report) without issue. It’s only the preview function that’s causing the hang. But wait, it gets better.

If a new (to that workstation) domain user B logs in on the very same machine, it works flawlessly. If you copy user A’s data out and whack his profile on the machine, and log him back in, same result, it works flawlessly, so that kind of rules out something with the installation or configuration. Pursuing the theory that it’s in the user registry hive, we have tried comparison tools but the volume of data they dump is daunting. I haven’t fed it to an AI yet, and would rather not, but it’s not out of the question.

For background, we are a SMB with only about 150 endpoints and the IT Department is me, a co-sysadmin, and a helpdesk guy. Workstations are HP600SFF, and we do not believe it is hardware or resource problem.

Edit: I'm aware the app is old. The company is aware the app is old, and needs to be replaced. However it is running on modern hardware, with modern EDR behind a modern network firewall. It works perfectly (for now) on 90+ percent of the endpoints. I've made them aware that M$ could deprecate it out of existence at any time, but is not generally in the habit of doing that without giving due notice.

TL;DR: 2005 Application Embedded Crystal Reports 11.0 (XI) migrated from W11Pro 24H2 to W11Pro 25H2 works to print or export, but hangs on preview, but only for the normal user of the workstation. Works fine for new users or if you replace the user’s profile with a new one.

Most DBAs learn wait events backwards—from a dry list of definitions, or from an AWR report after a fire.

The concept finally clicked for me when I started causing them on purpose to watch their signatures live in v$session_event. I packaged these drills into a lightweight, throwaway lab environment so anyone can test cause-and-effect locally.

How it works:

• Runs on the community Oracle Database Free Docker image.
• No Oracle account or licensing required.
• Each script flushes the buffer cache.
• Runs a workload engineered to trip one specific wait.
• Prints the session's live v$session_event delta.
• Safe to run without a Diagnostics Pack license.

Current drills included:

• db file sequential read (single-block index/rowid reads)
• db file scattered read (buffered multi-block full scan)
• direct path read (large scan bypassing cache into PGA)
• log file sync (row-by-row commit loop performance hit)

The logic check:
On fast local NVMe, wait times are tiny. The goal here is proving the structural shape and wait count behavior of the queries. For example, the commit drill runs 50,000 single-row inserts to show how high log file sync is a commit-frequency problem, not a slow disk issue. Moving the commit outside the loop collapses the wait count instantly.

I am genuinely curious where this setup might be too simplified, what edge cases it misses, and which specific wait event you think trips people up the most in production.

(GitHub link posted in the comments below to avoid spam filters).

We design and audit Oracle Fusion Security and the outcomes for most implementations are HORRIBLE. Are there any others that have experienced similar challenges when implementing ERP or HCM Cloud?

hi everyone

about 6 months ago we provisioned new servers for nessus on OCI using the tenable core ol8 custom image
during creation i injected our standard SSH public key as we always do
since then we haven't been able to access these servers via ssh.. the web applications running on them are working perfectly fine! but ssh is completely blocked(?)
every time we try to connect it prompts us for a password instead of accepting our ssh key

someone from our enterprise architecture team mentioned that ssh might be disabled by default on this specific tenable image, but we are stuck because we cannot log in to change anything

im looking for suggestions official documentation orrr workarounds for this this is becoming urgent because if the storage fills up tomorrow we won't be able to increase it nor can we install any security agents on the servers..

has anyone faced this with Tenable Core on OCI? how can we gain access to these servers?
any documentation or advice would be highly appreciated 🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼

thanks!

So, color me surprised when I got a question from one of our developers why a pretty simple query didn't return the expected results.

Basically, the query was:

>SELECT * FROM table WHERE table.field IS NULL or table.field <= 'someValue';

And it returned only rows with values, ignoring the rows with NULL.

After testing, I found another weird behaviour: The table had a couple of NUMERIC columns. When I included one of those, the bug appeared. When I only selected other columns, it worked, and returned all expected rows.

After much googling, I found another way to make it work:

>SELECT /*+ RULE */ * FROM table WHERE table.field IS NULL or table.field <= 'someValue';

Forcing the Rule Based Optimizer makes it work as well.

So, we now have a ticket with Oracle, let's see what happens. But a bug of this severity is pretty crazy to me.

Version is 23.26.0.0, btw. And yes, it's only on our staging systems, but still. Not even a 0.0 version should have these kind of bugs.

So, if you're running (or testing) that version, and you get unexpected results, maybe it's that.

Hi everyone,

I'm wondering if anyone has successfully changed the legal name on a personal Oracle Cloud account recently.

Here is my situation.

Background 1.I have a personal Oracle Cloud Free Tier account. 2.Later I realized that the account name should be updated to my legal name before upgrading to PAYG. 3.My goal is simply: a.Change the account name to my legal name. b.Continue the pending PAYG upgrade.

What I've done 1.Submitted the PAYG upgrade request. 2.Opened a Service Request. 3.The Collections team replied. The representative (Vasant) explained that their team does not have permission to change the account name and asked me to contact saleshelp@oracle.com. 4.I emailed SalesHelp exactly as instructed. 5.However, SalesHelp immediately sent an automatic reply saying that this email channel is no longer supported. It now tells users to use AI Assist or Fusion HelpDesk instead. 6.I then tried Oracle Support / My Oracle Support, but my personal Free Tier account does not have an active User Group with SR creation privileges, so I cannot create a support request there. 7.I replied to the original email thread, informed Collections that SalesHelp has been discontinued, attached the automatic reply, and politely asked whether there is a new official team or workflow for account name changes.

At the moment, I am still waiting for a reply.

Current status 1.PAYG upgrade: Pending 2.Account name: Not updated 3.Existing Free Tier resources: Working normally 4.No rejection has been issued so far.

My questions 1.Since the SalesHelp email is now discontinued, what is the current official channel for changing the legal name on a personal Oracle Cloud account? 2.Has anyone successfully changed their account name recently? 3.Is there another Oracle team that handles this type of request?

I'm not trying to bypass Oracle's policies. I simply want to update my account to my legal name and continue the normal PAYG upgrade process.

Any recent experience would be greatly appreciated.

Thank you!

Small nonprofit here. We used Oracle Cloud Free Tier for a few months in 2024, and then need for the workload ended, so we moved on. today I tried to log back in and our credentials don't work (both the Cloud and Oracle portals).

Fine, reset the password. Except the reset email never comes. Forgot username? That email doesn't come either. Phone support only handles existing tickets and just tells you to use the portal (login required). There is no support email. Tried to create a new account with the same email, but it says the email is already taken.

You literally can't get into your account without being logged in. That's it - that's the whole loop.

What's extra annoying is that they are very clear about not creating multiple accounts, but what do you expect us to do??

I created a new account with a different email (just an alias), and it worked immediately, so it's not our spam filter, something is just broken on their end for our original account, with no way to diagnose it and no humans to contact.

For paid customers I'm sure there's some path, but for free tier you're just screwed. Recreate everything and don't expect to ever use your original email again, I guess.

I suppose I'm hoping someone from Oracle sees this and fixes their process.

I'm curious about Oracle Cloud's policy and real user experiences.

Suppose someone permanently loses access to their Oracle Cloud account, or the account is permanently closed and cannot be recovered.

In that situation, is it possible to legitimately register a new Oracle Cloud account in the future, or is Oracle generally one account per person for life?

I'm not looking for ways to bypass Oracle's policies. I'm only interested in understanding the policy and hearing from people who have actually experienced this.

Thanks!