Safety and administration
Oracle and ASM
Install Oracle Instant Client and manage Oracle from Qrulla: tablespaces, alert log, RMAN backups, jobs, PDBs, security, redo and ASM.
Instant Client
To connect to Oracle, Qrulla uses Oracle Instant Client, Oracle's official client. It isn't included: you download it once from Oracle's site. It's free and isn't part of your Qrulla license.
- Open Oracle's download page for your computer (Qrulla gives you the link when you try to connect).
- Download the Basic (or Basic Light) package of the latest version, 64-bit.
- Unzip it into a folder you won't delete, for example
Documents/Oracle. On a Mac, open the.dmgand copy theinstantclientfolder. On Linux it needs thelibaiolibrary (packagelibaio1orlibaio). - In Qrulla, click “Choose folder…” and pick that folder. Connect again.
You can change or forget the folder later in “Preferences → Oracle Instant Client”. On Linux, restart Qrulla after choosing it.
If Qrulla finds a 32-bit client from an old Oracle install, it tells you: there's no need to uninstall it, just pick the 64-bit Instant Client's folder.
Manage Oracle
Max plan. Right-click a connected Oracle connection → “Sessions and performance”. Besides sessions, locks and costly SQL, it has:
Tablespaces
Each tablespace with its contents, status, size, usage and how far it can grow, and its files. You can add a file, resize one or change its autoextend. Qrulla shows you the exact statement before running it; if Oracle can't do it (for example, shrinking below its data), it refuses without changing anything.
Health
| Section | What it shows |
|---|---|
| Alert log | The lines of the last days, with an errors-and-warnings filter and what repeats the most. |
| Backups | The database mode (ARCHIVELOG or not), the last RMAN backup of the database and of archivelogs, and a warning if more hours pass than you choose. |
| Jobs | The Scheduler's jobs: whether they're enabled, when they ran and run next, failures. You can run them now, enable or disable them. |
| Invalid | Invalid objects with their first error. You can recompile one or all of a schema's. |
| PDBs | The pluggable databases: open, open read-only, close and save their state at startup (connected to CDB$ROOT). |
| Security | Locked, expired or expiring accounts, to lock or unlock, and dangerous privileges held by your own users or PUBLIC. |
| Redo | Redo groups, log switches per hour with a size suggestion, and the recovery area (FRA) with a warning when it's nearly full. |
Each action shows the statement and asks you to confirm. “Include Oracle's” also shows what belongs to SYS, SYSTEM and their schemas.
ASM
Max plan. Create an Oracle connection to the ASM instance with Connect as: SYSASM. Right-click it → “Manage ASM” shows:
- each disk group with its usage, what's usable given its redundancy and whether it survives a disk failure;
- its growth: Qrulla records usage every hour the view is open and, with a day of readings, works out how fast it grows and when it fills up;
- its disks (state, size, free, read and write times, errors), files and attributes;
- the disks outside the groups and the databases that use ASM.
And you can create a group, add or drop disks, rebalance with the power you choose, cancel a drop or bring disks online. Before running, Qrulla shows the exact statement and how much data Oracle estimates the rebalance will move, which you then follow live.
Only free disks (CANDIDATE, PROVISIONED or FORMER) are offered, never one that already belongs to a group. When dropping disks, their data moves to the others first; meanwhile, the drop can be cancelled.
Something missing or unclear? Write to support@qrulla.com.