UUptime Architect·12h agoORA-00054 Resource Busy: Find the Session, and Know Which DDL Will WaitFind 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
SShomil Bansal·21h agoMoving Oracle Internet Directory from MD5 to SSHA512: How to Validate a Password Verifier ChangeA practical test matrix for password storage, LDAP binds, provisioning and upgrade readiness.5 min read·shomilbansal.hashnode.dev
JJohn Ethan·1d agoHow to Build a Focused Study Strategy for the Oracle 1Z0-808 ExamTo 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 logi2 min read·freeexamquestion.hashnode.dev
UUptime Architect·3d agoORA-03113 After the Connection Sat Idle: The Firewall Forgot ItWhy 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.dev1
JJohn Scott·4d agoGenerate Word, Excel and PowerPoint from Oracle SQLclIntegrate ETCH with Oracle SQLcl to generate Word, Excel and PowerPoint documents from your Oracle Database9 min read·jes-dev.hashnode.dev
MMichael·4d agoOracle download using wget.shLast 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 autoupgrad2 min read·mmuehlbeyer.hashnode.dev
LLouis Moreaux·5d agoOracle APEX: Reusable Queries Using SQL Macros onlyParameterized views, shared predicates and one report for many tables, without a single line of PL/SQL8 min read·lmoreaux.hashnode.dev
EEjaz Arain·4d agoA cast to five bytes and a two-character wordFirst 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 f3 min read·rutba.hashnode.dev
UUptime Architect·6d agoORA-01000 Maximum Open Cursors Exceeded: Don't Raise the Limit, Find the LeakORA-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
TTonare Labs·Nov 10OIC REST Adapter: Fix Empty JSON Sample ArraysFix 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