Many Oracle guides are written for DBAs or long-time developers, and as a newcomer it feels like you’re expected to already know the jargon. I started in the same place, learning the as I went, and I’m still learning each day.
If you’re considering using Oracle AI Database, I’m here to make this easy for you.
Prefer code samples over blogs? Try one of the 50+ Oracle AI Database sample applications I’ve written.
Get your own database up and running quickly
Don’t have docker or similar? Skip this and start in your browser at FreeSQL.com
The easiest way to get started is with a docker-compatible runtime. Start the oracle-free:23.26.1-slim-faststart image like so:
docker run --name oracledb -d -p 1521:1521 \
-e ORACLE_RANDOM_PASSWORD=y \
-e APP_USER=testuser \
-e APP_USER_PASSWORD=testpwd gvenzl/oracle-free:23.26.1-slim-faststartThen, connect using SQLcl, a CLI interface for Oracle AI Database. This will log you in as the app user testuser into the freepdb1 pluggable database (PDB):
sql testuser/testpwd@localhost:1521/freepdb1You should see output similar to the following, indicating a successful connection with a SQL prompt:
PDBs are basically logical databases within the overall “container database”. You can read more about PDBs here. The freepdb1 PDB is automatically created for the Oracle AI Database Free container image.
Must-have dev tools
SQL Developer extension for VS Code: top IDE extension for Oracle developers. Useful for connecting to databases, exploring DB features, and testing.
Free database distributions: (container, binary, cloud, VM) for development and testing.
SQLcl command line interface: connect to Oracle AI Database from the command line.
Database drivers for the language of your choice, like the JDBC driver. Thick drivers (like godror) may require the Oracle Instant Client.
Free and open resources to help you learn
- FreeSQL.com: Oracle AI Database right in your browser. Run SQL, learn from tutorials, and share code.
- LiveLabs.oracle.com: Hands-on database labs run right in your browser.
- Oracle DevGym: More hands-on resources to learn Oracle technology.
- Oracle Database blogs: official Oracle blogs on database technology.
- Oracle Developers publication on Medium/Oracle Developers on YouTube: high-quality technical content centered around Oracle AI Database.
- AskTom.com: Ask veteran DBAs anything about Oracle, and search curated answer sets.
- Official Oracle AI Database 26ai documentation
Mini-glossary of Oracle terms
This is by no means a comprehensive table, but you’ll see these terms (and others) peppered throughout the Oracle documentation. It’s helpful to know their basic definitions within the context of Oracle AI Database.
| Database Term | Definition |
| Container Database (CDB) | The “host” database in Oracle Multitenant architecture. A CDB can contain multiple pluggable databases (PDBs) plus system containers. |
| Pluggable Database (PDB) | A portable, self-contained database that lives inside a CDB. Apps usually connect to a specific PDB, not to the CDB root. |
| Service Name | The logical database service clients connect to (often maps to a specific PDB). Preferred over using SID in most modern setups. |
| System Identifier (SID) | Historically identified a database instance. Still appears in some configs, but service names are the norm for client connections. |
| Real Application Clusters (RAC) | Multiple instances on multiple servers accessing the same database for high availability and scale. Clients connect via services that can fail over. |
| Data Guard | Replication/standby technology for disaster recovery. Primary database ships redo to standby; can support failover/switchover. |
| Redo Log / Archived Redo (Archive Logs) | Redo logs record changes for recovery. Archived redo logs are persisted copies used for backup/recovery and Data Guard. |
| Tablespace | A logical storage container made of one or more datafiles. Objects (tables/indexes) are stored in tablespaces. |
| Schema | A namespace owned by a user; contains objects (tables, views, procedures). Many teams say “schema” when they mean “user”. |
| SYS / SYSTEM / ADMIN (ADB-S) | Powerful built-in administrative accounts. Typically not used for application work; access is tightly controlled. |
| PL/SQL | Oracle’s procedural extension to SQL (stored procedures, functions, packages, triggers). Runs inside the database. |
| SGA / PGA | Memory areas: SGA = shared memory (buffer cache, shared pool, etc.). PGA = per-process memory (sorts, hash joins, etc.). |
| tnsnames.ora file | Client-side naming file mapping a net service name (like MYDB) to a connect descriptor (host/port/service). |
| TNS_ADMIN env variable | An environment variable that points Oracle clients to the directory containing tnsnames.ora, sqlnet.ora, etc. Useful when you don’t use default locations. |
| Oracle Wallet | A secure store for credentials and certificates used by Oracle clients/tools. Common uses: TLS certificates, mTLS, stored DB credentials (Secure External Password Store). |
Final thoughts
Oracle AI Database is powerful, and it can feel complex at first. Oracle’s depth comes from decades of solving data problems at scale: from everyday OLTP to analytics, high availability, and security.
As you use it, you’ll continually pick up practical skills, new features, and integrations that make building and operating data-driven applications simpler and more reliable.
Leave a Reply