5.6.2 Administration

5 entries match these filters

• 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
• 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