oracle-dba-provisioning-installation-configurationlisted

USE THIS SKILL WHENEVER the user mentions provisioning or installing Oracle, an RDBMS or Grid Infrastructure (GI) binary install, runInstaller / gridSetup / root.sh, ASM disk groups / CREATE DISKGROUP / +ASM, creating a database (DBCA silent/template or custom CREATE DATABASE), multitenant CDB creation, PDB creation / CREATE PLUGGABLE DATABASE, listeners / listener.ora / lsnrctl, tnsnames.ora / sqlnet.ora / tnsping, init or spfile parameters / ALTER SYSTEM SET / pfile, a parameter baseline or fleet standardization, character set / NLS / AL32UTF8, database links / CREATE DATABASE LINK, directory objects / CREATE DIRECTORY, default or temp tablespace configuration, or block size / storage standards — EVEN IF they do not name the exact task. Covers Oracle 19c and 23ai, EE, single_instance and Data Guard, on-prem. Follows the oracle-dba-common contracts: SQLcl MCP saved connection dba_ai_conn, Oracle Wallet secrets (never plaintext, never SYS/SYSTEM unless a runbook needs SYSDBA), --dry-run defaults on T2, and ti
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · AI & Automation · score 62

Install: claude install-skill Shreyas70773/oracle-dba-agentic-skills

# Oracle DBA - Provisioning, Installation & Configuration Standing up and configuring Oracle databases for 19c and 23ai (EE; single_instance and Data Guard; on-prem): software/Grid installs, ASM disk groups, CDB/PDB creation, Oracle Net (listener / tnsnames / sqlnet), init/spfile parameters and fleet baselines, NLS / character set, database links, directory objects, default tablespaces, and block-size / storage standards. Everything self-executing is **T1 (observe)** or **T2 (reversible, dry-run-default)**. Architecture/design and from-scratch/destructive operations (**binary installs, custom CREATE DATABASE, character-set change, block-size design, ASM disk add/drop/drop-group, DROP DATABASE/PDB, fixed-user link passwords**) are **T3** and live only in `references/runbooks.md` — they print exact commands for a human and never self-execute. ## Scope & risk map | Task | Level | Tier | Mechanism (script / sql / runbook path) | Idempotent? | |------|-------|------|------------------------------------------|-------------| | Oracle RDBMS binary installation | L3 | **T3** | `references/runbooks.md#rdbms-install` | n/a — host install; verify via opatch lpinventory | | Grid Infrastructure installation | L3 | **T3** | `references/runbooks.md#grid-install` | n/a — host install; verify via crsctl/srvctl | | ASM disk group creation | L3 | T2 | `scripts/asm_diskgroup.sh create` / `.ps1` -> `sql/asm_diskgroup_create.sql` (+ `sql/asm_status.sql`) | yes — mounted DG of same name -> noop |