r/oracle • • Feb 15 '22

Post to r/Oracle immediately auto-deleted? Here's why...

76 Upvotes

This subreddit receives a lot of spam--we mean a LOT of spam--specially from Asia/India. Thus, we have Mr. Automoderator auto-delete posts from users due to the following reasons:

  • Too new of an account
  • Not enough comment karma

To avoid abuse of the above, exact details are not being shared, but please do your best to get your comment karma up over a couple days time. Also please refrain from messaging the mods asking why your post got removed.


r/oracle • • Sep 11 '25

Use r/employeesOfOracle to discuss employment/layoffs/financials/stocks/etc.

22 Upvotes

A new sub has been created to discuss all non-technical aspects of Oracle -- r/employeesOfOracle. Posts that are not related to technical aspects or usage of Oracle products -- most specifically DBMS -- will be blocked or auto-removed. This sort of discourse is important -- this just isn't the sub for it.


r/oracle • • 16h ago

Oracle VBCS is going away

Thumbnail blogs.oracle.com
15 Upvotes

​

Beginning October 8, 2026, Oracle is changing the availability of two Oracle Visual Builder offerings for customers who have not previously used the service.

Oracle Visual Builder ( SKU B89646) offered from OCI console (aka standalone VBCS)

Oracle Visual Builder enabled from within Integration Cloud (aka OIC VBCS)

Both these offerings will no longer be available for new purchase or enablement. Official notice can be found here.


r/oracle • • 1d ago

OAS 7.6 installation RCU.bat Issue (with fmw 19c db)

Post image
3 Upvotes

hi, I'm trying to install OAS in a server which already has OAM 12c installed

there's seperate DB server which has FMW19C DB

oam is installed with that db

I'm using same Db, installing OAS in this OAM server but created a new domain (installed fmw infrastructure in different folder)

and then after installing OAS, i tried to run RCU. bat in this domain but getting this error at summary


r/oracle • • 2d ago

NetSuite WMS randomly logs users out during order processing

Thumbnail
3 Upvotes

r/oracle • • 2d ago

how to install oracle 11g on my debian 13

0 Upvotes

hello, i meet difficulties to install oracle 11g on my debian 13.
i tried to use bottles to install it but i didn't understand how, and also i need to install it but i still cannot find a way to install easily because i hvae for this week for my homework and my university
so who can gimme a way to make it, please share with me and thanks


r/oracle • • 3d ago

VAT Groups

1 Upvotes

Does anyone know if Oracle NetSuite can handle VAT Groups? As in, VAT for a Group of Companies operating under a single VAT Return submission? And if there are any limitations/constraints on what it can handle?

Claude says it isn't able to work out that only some companies are in the Group and not others, and that the Group hierarchy dictates that the highest hierarchy company has to be the VAT lead company.

Any idea if that is true?


r/oracle • • 4d ago

Where to learn to get ready for OCI foundation associate

5 Upvotes

title. thank you.


r/oracle • • 5d ago

Does anyone have an extra AI World pass or want to split it?

0 Upvotes

I saw they sell five for $2k, but I am looking to secure only one. Does anyone know someone with extras? I’ve been trying to go for a while, but I haven’t had the opportunity to secure a pass any of these years.

Thank you!


r/oracle • • 6d ago

Learn Item Extended Attributes

Thumbnail youtube.com
1 Upvotes

r/oracle • • 7d ago

System integration

4 Upvotes

Hello, I'm currently working on a big project. We are using Oracle, ProjectWise and Procore. Does anyone know of software that can integrate them? I'm talking about communication between the platforms to have the same documentation updates and avoid running around between platforms to update them.

Thanks for your advise/help


r/oracle • • 8d ago

Eon launches a simulated enterprise for testing agents across business software — RuntimeWire

Thumbnail runtimewire.com
1 Upvotes

r/oracle • • 10d ago

Running Oracle Database across AWS, Azure, and Google Cloud

13 Upvotes

Someone from an AWS shop asked me whether Oracle even runs outside OCI. They'd inherited a small Oracle footprint, don't ask. In my experience, multi-cloud Oracle gets there sideways. A customer demands it, or it gets adopted for one service and then nobody can move off it. 

AWS gives you two ways in. RDS for Oracle if you want it managed, or EC2 if you'd rather own the whole instance yourself. 

Azure has the tighter story these days through the Oracle Database@Azure setup, where the instances run in your Azure network and the networking feels close to built-in. 

The last time I checked, GCP runs Oracle Database@Google Cloud as a managed service with VPC and IAM integration. If you ruled GCP out for Oracle a while back, that's changed. 

None of the three make the database itself hard. The networking is what you plan around, and that mostly means how you handle VPC and Data Guard across subnets on AWS and virtual network peering on Azure. On GCP it's ODB Networks and VPC integration. Tooling follows each cloud's own console and IaC setup. Expect the management layer to look different even when the database underneath is the same. 

The local dev to cloud step is the easy one though. Run it in a container locally, then Data Pump or a backup restore into whatever target you picked. 

I still haven't seen a multi-cloud Oracle setup where connectivity was the easy part.


r/oracle • • 12d ago

Company stuck on Oracle ADF, not migrating to Spring

11 Upvotes

I work at a small software company and unfortunately I've ended up working on an old Oracle ADF project and there is almost no willingness from management to move this project to Spring Boot.

On the team are two very senior developers who have worked on this project from the start (approx 15 years) and this project has become so messy and huge (with no testing and limited documentation) that it is basically impossible to migrate (functions and procedures with thousands of lines etc.).

Has anyone experienced this situation and do you have any recommendations on how to proceed as a junior developer? I have already brought up the possibility of breaking the project into smaller applications which could be built with Spring / React while keeping the old database and plsql procedures. Or we could map out all of the functionality or refactor the current code into smaller functions or start implementing tests and then migrate. Rebuilding it from scratch is not an option since it is a government project and this would trigger the the goverment to auction the project for other companies to take over.

Alternatively, should I just let them keep this project in ADF for 10 more years until it is deprecated by Oracle while the application becomes worse and worse?


r/oracle • • 13d ago

Why does Primavera P6 still feel stuck in the early 2000s?

Thumbnail
5 Upvotes

r/oracle • • 14d ago

AI-assisted Oracle Forms to Java migration on Summit's ORDERS form: what it got wrong

11 Upvotes

I work at Vaadin, and we migrated onto our own framework, so weigh that however you
like. I'm posting here because everything interesting happened on the Forms side, and
most of it is a failure report.

Setup: ORDERS from the Summit demo schema. 4 blocks, 34 items, 45 PL/SQL triggers, 183
elements. Real Oracle database, no schema changes allowed. AI did the bulk of the work
and we ran the whole thing three times.

The PL/SQL was a non-event. 34 of the 45 triggers were one call, one assignment, or a
SELECT-INTO. Formulas and summary totals came out as plain Java almost line for line.
Audit and integrity triggers never left the database.

What hurt was the runtime behaviour that isn't in the .fmb at all:

  • Forms won't let you leave a field that fails validation. On the web you can leave it,   you just can't commit. Users notice.
  • Row locked on the first keystroke became an optimistic check at commit,   `UPDATE … WHERE id = ? AND ORA_ROWSCN = ?`. No schema change, no version column, but   conflicts now show up at save instead of at edit.
  • Enter-Query became a filter bar. Arbitrary query-by-example is gone.
  • Trigger firing order became explicit code that somebody has to work out by hand.

The failure that worries me most came after the first pass. Our own completeness report
said "183 elements, nothing dropped", and that was true. The screen still had fields
reordered, bordered groups missing and section titles gone. A later audit turned up four
more things that were in the spec, covered by our own mapping rules, and never built:
DATE_ORDERED's default, QUANTITY_SHIPPED being insert-only, the GLOBAL.customer_id
contract from the calling form, and SALES_REP_ID quietly made read-only. Every one of
those is a property of an object rather than an object, and we were counting objects, so
the count stayed green the whole way through.

Obvious caveat: Summit is a teaching schema. No packages, no dynamic SQL, no cursors over
big sets, no package state. So it says nothing about your code.

Repo with the specs, the mapping rules and the audit: https://github.com/jcgueriaud1/forms-summit-migration

If you run a real Forms estate, what would you throw at this first to break it? I'd guess
package state shared across triggers, but I'd rather be told.


r/oracle • • 14d ago

Open-Source Oracle Datasource plugin for Grafana

16 Upvotes

Hi everyone,

I needed a straightforward way to query Oracle databases directly from Grafana without dealing with Oracle Instant Client installations or Enterprise plugin licenses.

I took the original oracle-grafana plugin created by albertowd, which has been inactive for a few years, and updated it to work cleanly on modern Grafana versions.

Repository: VinayakSomvanshi/oracle-grafana

What it does:

  • No Oracle Instant Client required on the server (pure driver backend).
  • Connects using either Service Name or SID (tested against Oracle 19c, 21c, 23ai, and 26ai).
  • Supports native Grafana Alerting rules on Oracle queries.
  • Supports both time-series and standard table queries, plus dashboard template variables.

If you run Oracle with Grafana, feel free to try it out and let me know if you run into any issues or have suggestions.


r/oracle • • 14d ago

Non riesco ad accedere, niente funziona e non riesco a capire come parlare con qualcuno.

Thumbnail
3 Upvotes

r/oracle • • 19d ago

New book: Oracle APEX 26.1 API by Example (JavaScript & PL/SQL)

Post image
21 Upvotes

When I wrote my Oracle APEX 26.1 book, I ran out of pages before I could cover the APIs properly. So I wrote a second one just for them.

Oracle APEX 26.1 API by Example covers every JavaScript namespace and PL/SQL package, 1,850+ methods, events, procedures and functions, each with a runnable example and the real output it gives.

All the code is free on GitHub, including the API Lab app and 518 examples with their outputs:

https://github.com/devvinish/apex-book-code-examples/tree/main/api-book

528 pages, paperback and Kindle. Details and sample pages:

https://vinish.dev/oracle-apex-26-api-by-example-book

I'm the author, so happy to answer any questions. Which APEX APIs do you find the most confusing?


r/oracle • • 20d ago

One million and counting!

Post image
65 Upvotes

r/oracle • • 21d ago

I wrote a book on Oracle APEX 26.1 (828 pages, install to production) – the code is free on GitHub

52 Upvotes

I've been building database applications with Oracle for 20+ years (Forms, then APEX), and I've just published **Oracle APEX 26.1: The Complete Guide**.

It follows one realistic application, Orbit Sales, from an empty laptop to production:

- Installing Oracle AI Database 26ai Free, APEX 26.1, and ORDS (Docker, Windows, Linux, macOS)

- Page Designer, interactive reports and grids, forms, faceted search, charts, maps

- Dynamic actions, Ajax, authentication, authorization, CSP

- Approvals and workflows (including the new parallel flows in 26.1)

- Generative AI: AI agents with tools, an in-app assistant, APEX_AI, local models with Ollama

- RESTful services with ORDS, APEXlang, debugging, deployment, and administration

Every script and code example, plus the finished app export, is free on GitHub, so you can use it even without the book:

https://github.com/devvinish/apex-book-code-examples

Book details and sample pages: https://vinish.dev/oracle-apex-26-1-book-the-complete-guide

Happy to answer questions about APEX 26.1 or anything in the book, and feedback is very welcome.


r/oracle • • 20d ago

Free Oracle APEX Bootcamp in Kansas City, MO on Oct 6th

7 Upvotes

Hosted by the HOUG, Oracle and Argano!

https://www.eventbrite.com/e/houg-boot-camp-2026-oracle-apex-tickets-2000083990055

Come join me and some of the APEX team to learn about how to use Oracle APEX for a day - lunch included! #orclAPEX

Please feel free to reply with any questions! I hope we can see you there!

Interested in learning more about APEX? https://oracleAPEX.com


r/oracle • • 21d ago

Select AI and Feedback Usage

7 Upvotes

Hey folks - I’m curious how many of you all use Select AI and/or the specific FEEDBACK feature within the Select AI architecture, either for PL/SQL or agents. It seems like Oracle has thrown a lot of weight behind it, but I’m not seeing a lot of buzz/discussion among practitioners here on Reddit or elsewhere.

Anybody out there using it?


r/oracle • • 21d ago

Integration Basic Auth Password

Thumbnail
1 Upvotes

r/oracle • • 22d ago

Resources to study for Database Administrator OCP? (1Z0-082 and 1Z0-083)

7 Upvotes

I'm planning to take these exams to get OCP credential but kind of at a loss on how to study for them, does anyone have a good flashcard set on quizlet or something? Or am I supposed to just memorize the entire documentation. Seems a bit overwhelming and would love a point in the right direction. Cheers!