5.6.2 Administration
Every entry filed under Administration and its subtopics.
Level
- Beginner 0
- Intermediate 5
- Advanced 1
Kind
- Tutorial 0
- Concept 0
- How-to 3
- Reference 1
- Fix 2
6 entries
- 0222 Connecting to Oracle: SQL*Plus, SQLcl, EZConnect, tnsnames.ora and the listener Clients reach an Oracle database through the listener, using an Easy Connect string or a tnsnames.ora alias. Here are the formats, the… Intermediate · Reference · Linux, macOS, Windows Article Administration · Concepts & tools 15 Oct 2026
- 0223 Oracle users, roles and tablespaces: setup script and usage report (SQL) A SQL*Plus/SQLcl script that creates a tablespace, a role and an application user inside a PDB, then reports tablespace usage from the… Intermediate · How-to · Any system Script Administration · Security & access 15 Oct 2026
- 0224 RMAN backup basics: ARCHIVELOG mode, a nightly backup script and restore Enable ARCHIVELOG mode, set an RMAN retention policy, run a nightly full backup with archived logs from cron, and learn the restore… Advanced · How-to · Linux Script Administration · Backup with RMAN 15 Oct 2026
- 0225 Oracle Data Pump: export and import schemas with expdp and impdp Data Pump moves schemas, tables or whole databases between Oracle databases as dump files. Set up a directory object, export with expdp… Intermediate · How-to · Linux, Windows Article Administration · Backup with RMAN 15 Oct 2026
- 0226 Fix: ORA-12541: TNS:no listener The client reached the host but nothing was listening on that port. Start or fix the Oracle listener, or correct the host… Intermediate · Fix · Linux, Windows Article Administration · Concepts & tools 15 Oct 2026
- 0227 Fix: ORA-01017: invalid username/password; logon denied Oracle rejected the login. Check the password (case-sensitive), that you connect to the right PDB service, and whether the account is locked… Intermediate · Fix · Any system Article Administration · Security & access 15 Oct 2026