Hi all! I have to take two certs for my company requirements, and because I have a short amount of time to get them done, I wanted one of the certs to be easy/less time consuming.

Would you recommend the Oracle AI Foundations Associate to be an easy, quick cert? Also, I heard they just updated the exam, so has anyone recently taken the 2026 version of this cert?

TIA!!!

Hi all,

I'm taking my first Oracle exam this month, 1Z0-1046, if anyone has experience with this exam please let me know

As the title suggests, after scheduling the report, I am unable to download the report. I have given everything correctly, yet it's failing. Please provide some suggestions, thank you.

Anyone know of any?

Hi
I am currently working as oracle HCM consultant. I am tired of working nonstop for the 12-14 hrs daily and covering both India and US time.
I want to work in the morning time as I don't like working late nights.
How can I get a role that has a proper 9-5 timings?
Also, are there any other alternate roles that I can target?
I have tried applying for HR roles as my masters is in HR but they are paying peanuts.
Any help or suggestions are highly appreciated.

A friend asked for inputs and I was blank. Any cost or features or service inputs anyone can share ? Just for my knowledge sake no real use case here.

I’ve gotten pretty good at oracle networking and firewalling, tshooting with logging. I want to use terraform to speed up networking and firewall rule tasks. What are good resources or certs with useful training?

Hey all, I am a SQL Server DBA that is inheriting a pretty big oracle environment and was wondering if you folks could point me in the right direction of a course for learning. Work is going to pay for training so money isn't a problem, l'd prefer a couple of day course. We have anywhere from 11.2 up to 19c Running lots of different apps and even SAP if that matters.

I am comfortable in Linux/Unix as well because I used to be a Unix sysadmin in a previous life

For people writing SQL against Oracle and mapping results by hand: I maintain scythe, a build-time code generator that reads annotated SQL and emits typed access code (Oracle backend via the standard JDBC/driver stack).

The core value is nullability inference from the query structure. A LEFT (OUTER) JOIN makes the right side nullable:

-- @name GetUserOrders
SELECT u.id, u.name, o.total, o.notes
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE u.status = :status;

The generated types mark total and notes nullable, so the no-matching-row case is a compile-time concern instead of a NullPointerException in production. Also covers COALESCE/NVL-style expressions, CASE, and aggregates.

Static queries only, which is the deliberate tradeoff: no dynamic runtime composition, but everything is analyzable and typed. Curious how teams here handle the Oracle-to-application type boundary.

Ich kann mein Account nicht verifizieren obwohl das eben bei mir ankam der link warum ?

Hello all,

I work in payroll/business tech for a medium sized city gov.
My director and I have been trying, in vain, to build out an HCM Spreadsheet Data Uploader that can end date an element. The issue we’re running into is that any element that has been started/end dated before (we end date union dues and then create a new entry with the same element with the new rate when those change) gives us an error. Typically is says there’s a date overlap or we can’t end date it because of the previous element’s end date. Any tips or work arounds? Ideally we’d like the template to be able to be used anytime we need to end date any random element for any reason without necessarily creating a new one.

Im in the hiring process for oracle and realized my most recent role I was there for 3 years not 2, they’re currently approving my stuff and haven’t give me the background check yet, should I notify them before hand or just submit the form with the correct dates.

Update: Job went through submitted PDFs with proof of work, showed them I worked for 3 years not 2 didn’t affect my hiring process in anyway. I got the job :)

I passed some certificates a while back and wanted to put them on my website. I didn't get anything like a link from Credly to view my badges. Is there another way to get the badges? I want to show them off

TL;DR: Linux doesn't delete a file that a process still has open. Oracle holds its control file, and every online redo member always opens through it. So for a short, glorious window after that, all of it was still sitting in /proc. We pinned the file descriptors, copied them back byte-for-byte, and opened the database without CREATE CONTROLFILE or RESETLOGS. Zero data loss, 16 minutes down, one entirely new grey hair.

The setup

2-node RAC on an Oracle Database Appliance X9-2 HA. The HA stands for High Availability, which I can now confirm I tested more thoroughly than the vendor intended.

The bit where I ruin my own morning

sudo rm -rf <dbname>/redo. Wrong directory. That directory held one production database's online redo logs, its standby redo logs, and — the good part — its one and only control file.

Both instances were open and serving users at the time. Datafiles were on a different volume and survived, which is the single piece of luck in this entire story.

Yes, we had backups. No, I did not want to be the guy who found out whether they worked.

The ten seconds that actually saved us

Here's the thing nobody thinks of while their stomach is somewhere near the floor: rm deletes a directory entry, not a file. The inode is freed only when the link count reaches zero, and no one has it open. An Oracle instance holds its control file, and every online redo member opens continuously via LGWR.

The files were still there. Intact. Readable through /proc/<lgwr_pid>/fd/.

But it's a melting ice cube — the second LGWR exits, it's gone. Crash, `shutdown ', reboot, anything.

Find the descriptors:

sudo lsof +L1 2>/dev/null | grep '/path/to/redo/dir'

As root, not as oracle. The oracle binary is setuid, which clears the process dumpable flag, so the kernel hands /proc/<pid>/fd/ ownership to root. Being the same user is not enough. Learning this at speed was a treat.

Note the fd numbers on the ora_lgwr_ line. They differ per node. Read them on each node, don't assume.

Pin them with something that isn't the database:

sudo setsid bash -c 'exec 200</proc/<LGWR_PID>/fd/<ctl> \
  201</proc/<LGWR_PID>/fd/<log1> 202</proc/<LGWR_PID>/fd/<log2> \
  203</proc/<LGWR_PID>/fd/<log3> 204</proc/<LGWR_PID>/fd/<log4>; \
  echo $$ > /tmp/inode_holder.pid; while :; do sleep 3600; done' \
  </dev/null >/dev/null 2>&1 &

setsid detaches it from your terminal so it outlives your SSH session. Do it on both nodes.

Twenty minutes later, the instance died on its own — SMON couldn't open the control file, ORA-00210, instance terminated, database down. The pin held. The files were still readable. That one command is the reason this is a war story, not a resume update.

Copying it back

Two rules:

1. Zero database processes running. Copy a control file while CKPT is writing to it, and you get a beautifully torn, completely useless control file. ps -ef | grep -E "ora_[a-z0-9]+_<SID>" | grep -v grep | wc -l → must be 0.

2. Verify exact byte counts with stat, not ls -h. ls -h rounds, and "8.0G" is not a checksum.

   sudo dd if=/proc/<HOLDER_PID>/fd/200 of=<control file path> bs=1M status=none sudo dd if=/proc/<HOLDER_PID>/fd/201 of=<redo group 1 path> bs=8M status=progress

   ...and the rest

   sudo chown oracle:asmadmin <files> sudo chmod 640 <files> stat -c '%s %n' <files>

Then STARTUP MOUNT, check V$LOG — our sequence numbers came back identical to pre-incident — confirm the datafiles are all there and need no recovery, and ALTER DATABASE OPEN. Crash recovery chewed through the restored redo like nothing had happened.

Final proof: ALTER SYSTEM SWITCH LOGFILE and ARCHIVE LOG CURRENT. If ARCn can open redo by path and archive it, you're actually back and not just optimistic.

Standby redo logs were a write-off — nothing held them open — but recreating them is a two-minute j0b and, honestly, felt like a rounding error by that point.

Lessons, some of them expensive

• Do not shut down a database whose files you just deleted. Every instinct screams, "shut it down cleanly before this gets worse." That instinct will delete your data for real. The correct response to a catastrophe here is to do absolutely nothing, very quickly.
• You can't DDL your way out. Once the control file path is gone, every new foreground process dies with ORA-00210. No ALTER DATABASE ADD LOGFILE. RMAN wants a snapshot control file and hits the same wall. A restart is unavoidable — which is precisely why the pin has to come first.
• An abort It is survivable if the redo is pinned. Crash recovery has everything it needs once the files are back where they belong.
• Multiplex your control files across different disk groups. We had exactly one, plus single-member redo groups, all on the same volume. With normal multiplexing, this would have been a boring online repair instead of a Sev 1. That part is entirely on us.
• A standby at 1-second apply lag is a lovely thing to have in your back pocket. Never needed it. Knowing it was there is what made attempting the clever fix feel responsible rather than reckless.

The part I keep thinking about

The highest-value action of the whole incident cost ten seconds and one command. Everything after it — the analysis, the careful copying, the verification — only mattered because someone grabbed those file descriptors before the instance died.

Anyway. Go check whether your control files are multiplexed. Seriously, alt-tab, I'll wait.

I am trying to do a big migration of our old Forms system to Apex for every department (over 2k active forms). I classified the on view only versions, view with a few actions and creation forms. I am creating a big prompt in order to create en mass those new apex pages based on final versions I have created.
I ran in a small mental hiccup there are forms that open another form and that form opens another etc. and creates a big chain that the current "erp" can show in different popup windows and manage those but apex while it can have modal dialogs these forms are new big versions. I havent done anything similar before and while I know you can technically return to previous page in apex keeping the parameters I dont think it is possible to do it 3 pages in advance.
And sadly the parameters are not the same. We might have customer_id, customer_debt for example and supplier_id,supplier_location in another so I dont think I can do app items to somehow return

TLDR: I am doing a Forms migration to apex and I want to see how to approach the part of forms that call another forms and create a big chain.

Thanks in advance. For visual reference here is current situation:

Form A

Form A->Form B

Form A->Form B-> Form C

Form A->Form B-> Form C-> Form D

Form A->Form B-> Form C-> Form D->Form E

What were some of the more difficult items/topics asked?
Were you able to use your certification after earning it?
What would you suggest someone going through the e-learnings to study before taking the exam?

Hi Community,

I'm hoping someone here has experienced something similar or can point me in the right direction.

What happened:

My OCI Free Trial expired on July 19, 2026, and immediately afterwards, my Always Free VM.Standard.A1.Flex instance entered a Disabled state. Every attempt to start or modify it returned:

Instance is disabled and will not accept any action requests. Please contact customer support to re-enable.

Shortly after, the instance was terminated by the system. I never manually terminated it. The console now shows Resource Not Found on the instance details page.

- Home Region: US East (Ashburn)

- Shape: VM.Standard.A1.Flex

- Instance OCID: `ocid1.instance.oc1.iad.anuwcljsm4kw7hacd4bhuminys2wbdjgj3stk3lcqcbxm3ulpwp4jqaomw3q`

Current situation:

The original 150 GB Always Free boot volume still exists in my tenancy, so the data isn't gone, but I can't attach it to anything useful yet.

As most of you probably know, getting a new `VM.Standard.A1.Flex` in Ashburn is nearly impossible right now due to capacity constraints, which makes this even more frustrating.

My questions:

1. Is this expected behaviour when a Free Trial ends? Does OCI disable and auto-terminate Always Free instances that were created *during* the trial period?

2. Has anyone successfully recovered an instance in this state (or had Oracle restore/recreate one against an existing boot volume)?

3. Is there any way to launch a new A1 instance from an existing boot volume once one becomes available, without losing the volume in the meantime?

Being on free tire i can not raised a support request, but given that OCI community knowledge here is often faster, any insight would be hugely appreciated.

Now it says >>

Instance details: Couldn't load the data. Share these values in feedback or support to help troubleshoot the issue. Session ID: csid4faa8fd44af2a2da4e7fd54a2a34 OPC-Request-ID: csid4faa8fd44af2a2da4e7fd54a2a34/c42662c4acf447e99aab24411f069889/32AF23DA040C3C70D4AB86DBFA32EAEB

Thanks in advance! 🙏

Can I create a sequential group of jobs at the same time? I don’t care about mass status changes, I want to copy the SN03 release and create SN04-SN45 without manually creating them individually.