---
title: "#oracle articles | Hashnode"
description: "Oracle Corporation is an American multinational computer technology corporation, headquartered in Redwood Shores, California."
url: "https://hashnode.com/tag/oracle"
---

Tag

# #oracle

1,600 posts · 2,380 followers

[Uptime Architect](https://hashnode.com/@uptimearchitect) · [13h ago](https://hashnode.com/posts/ora-00054-resource-busy-find-the-session-and-know-which-ddl-will-wait/6afc686b1077fdff1dba87f9)

### [ORA-00054 Resource Busy: Find the Session, and Know Which DDL Will Wait](https://uptimearchitect.hashnode.dev/ora-00054-resource-busy-find-the-session-and-know-which-ddl-will-wait?utm_source=hashnode&utm_medium=feed)

Find the idle session behind ORA-00054, see which DDL waits instead of failing, and why DDL\_LOCK\_TIMEOUT stalls every writer. With a free lab.

14 min read · [uptimearchitect.hashnode.dev](https://uptimearchitect.hashnode.dev/ora-00054-resource-busy-find-the-session-and-know-which-ddl-will-wait?utm_source=hashnode&utm_medium=feed)

[Shomil Bansal](https://hashnode.com/@shomil) · [21h ago](https://hashnode.com/posts/moving-oracle-internet-directory-from-md5-to-ssha512-how-to-validate-a-password-verifier-change/6afbf2b12b4ab38e3c2de82a)

### [Moving Oracle Internet Directory from MD5 to SSHA512: How to Validate a Password Verifier Change](https://shomilbansal.hashnode.dev/moving-oracle-internet-directory-from-md5-to-ssha512-how-to-validate-a-password-verifier-change?utm_source=hashnode&utm_medium=feed)

A practical test matrix for password storage, LDAP binds, provisioning and upgrade readiness.

5 min read · [shomilbansal.hashnode.dev](https://shomilbansal.hashnode.dev/moving-oracle-internet-directory-from-md5-to-ssha512-how-to-validate-a-password-verifier-change?utm_source=hashnode&utm_medium=feed)

[John Ethan](https://hashnode.com/@johnethaneva) · [1d ago](https://hashnode.com/posts/how-to-build-a-focused-study-strategy-for-the-oracle-1z0-808-exam/6afadf3f74395d0b2ff98e53)

### [How to Build a Focused Study Strategy for the Oracle 1Z0-808 Exam](https://freeexamquestion.hashnode.dev/how-to-build-a-focused-study-strategy-for-the-oracle-1z0-808-exam?utm_source=hashnode&utm_medium=feed)

To earn the Oracle Certified Associate Java SE 8 Programmer credential, you must pass the 1Z0-808 exam. Because this assessment tests intricate code behavior, compiler errors, and object-oriented logi

2 min read · [freeexamquestion.hashnode.dev](https://freeexamquestion.hashnode.dev/how-to-build-a-focused-study-strategy-for-the-oracle-1z0-808-exam?utm_source=hashnode&utm_medium=feed)

[Uptime Architect](https://hashnode.com/@uptimearchitect) · [3d ago](https://hashnode.com/posts/ora-03113-after-the-connection-sat-idle-the-firewall-forgot-it/6af878095d514f5227f9ebb5)

### [ORA-03113 After the Connection Sat Idle: The Firewall Forgot It](https://uptimearchitect.hashnode.dev/ora-03113-after-the-connection-sat-idle-the-firewall-forgot-it?utm_source=hashnode&utm_medium=feed)

Why idle pooled Oracle connections fail with ORA-03113 or ORA-03135 behind a firewall or load balancer, and the SQLNET.EXPIRE\_TIME fix.

14 min read · [uptimearchitect.hashnode.dev](https://uptimearchitect.hashnode.dev/ora-03113-after-the-connection-sat-idle-the-firewall-forgot-it?utm_source=hashnode&utm_medium=feed)

[John Scott](https://hashnode.com/@jes-dev) · [4d ago](https://hashnode.com/posts/generate-word-excel-and-powerpoint-from-oracle-sqlcl/6af735705584757c61ffb192)

### [Generate Word, Excel and PowerPoint from Oracle SQLcl](https://jes-dev.hashnode.dev/generate-word-excel-and-powerpoint-from-oracle-sqlcl?utm_source=hashnode&utm_medium=feed)

Integrate ETCH with Oracle SQLcl to generate Word, Excel and PowerPoint documents from your Oracle Database

9 min read · [jes-dev.hashnode.dev](https://jes-dev.hashnode.dev/generate-word-excel-and-powerpoint-from-oracle-sqlcl?utm_source=hashnode&utm_medium=feed)

[Michael](https://hashnode.com/@mmuehlbeyer) · [4d ago](https://hashnode.com/posts/oracle-download-using-wget-sh/6af7779deac02774201340f9)

### [Oracle download using wget.sh](https://mmuehlbeyer.hashnode.dev/oracle-download-using-wget-sh?utm_source=hashnode&utm_medium=feed)

Last week I've stumbled over an unforeseen issue while trying to download a patch via MyOracleSupport(MOS) provided (dynamicscaling to be complete but that's another story) As I tend to use autoupgrad

2 min read · [mmuehlbeyer.hashnode.dev](https://mmuehlbeyer.hashnode.dev/oracle-download-using-wget-sh?utm_source=hashnode&utm_medium=feed)

[Louis Moreaux](https://hashnode.com/@lmoreaux) · [5d ago](https://hashnode.com/posts/oracle-apex-reusable-queries-using-sql-macros-only/6af5ce0624ec1bbe0493cd49)

### [Oracle APEX: Reusable Queries Using SQL Macros only](https://lmoreaux.hashnode.dev/oracle-apex-reusable-queries-using-sql-macros-only?utm_source=hashnode&utm_medium=feed)

Parameterized views, shared predicates and one report for many tables, without a single line of PL/SQL

8 min read · [lmoreaux.hashnode.dev](https://lmoreaux.hashnode.dev/oracle-apex-reusable-queries-using-sql-macros-only?utm_source=hashnode&utm_medium=feed)

[Ejaz Arain](https://hashnode.com/@ejazarain) · [4d ago](https://hashnode.com/posts/a-cast-to-five-bytes-and-a-two-character-word/6af6d3bbe9abe11193821938)

### [A cast to five bytes and a two-character word](https://rutba.hashnode.dev/a-cast-to-five-bytes-and-a-two-character-word?utm_source=hashnode&utm_medium=feed)

First published on the Tech Style blog. CAST('中文' AS VARCHAR2(5)) asks for five bytes of a value that takes six. Each of the two characters is three bytes long in a UTF-8 database, so the fifth byte f

3 min read · [rutba.hashnode.dev](https://rutba.hashnode.dev/a-cast-to-five-bytes-and-a-two-character-word?utm_source=hashnode&utm_medium=feed)

[Uptime Architect](https://hashnode.com/@uptimearchitect) · [6d ago](https://hashnode.com/posts/ora-01000-maximum-open-cursors-exceeded-don-t-raise-the-limit-find-the-leak/6af4a7f6fe352d7842e53720)

### [ORA-01000 Maximum Open Cursors Exceeded: Don't Raise the Limit, Find the Leak](https://uptimearchitect.hashnode.dev/ora-01000-maximum-open-cursors-exceeded-don-t-raise-the-limit-find-the-leak?utm_source=hashnode&utm_medium=feed)

ORA-01000 is a per-session cursor leak, not a low limit. Find the session and the statement, skip the cached-cursor trap, and see why a raise fails.

14 min read · [uptimearchitect.hashnode.dev](https://uptimearchitect.hashnode.dev/ora-01000-maximum-open-cursors-exceeded-don-t-raise-the-limit-find-the-leak?utm_source=hashnode&utm_medium=feed)

[Tonare Labs](https://hashnode.com/@tonarelabs) · [Nov 10](https://hashnode.com/posts/oic-rest-adapter-fix-empty-json-sample-arrays/6af30e04144ad9168d0cca4b)

### [OIC REST Adapter: Fix Empty JSON Sample Arrays](https://tonarelabs.hashnode.dev/oic-rest-adapter-fix-empty-json-sample-arrays?utm_source=hashnode&utm_medium=feed)

Fix empty-array schema errors in Oracle Integration 3 REST Adapter samples without confusing design-time samples with runtime payloads.

3 min read · [tonarelabs.hashnode.dev](https://tonarelabs.hashnode.dev/oic-rest-adapter-fix-empty-json-sample-arrays?utm_source=hashnode&utm_medium=feed)
