Oracle

Oracle

2023-03-02 2016-06-16
Oracle glossary
2021-01-13 2015-04-27
NLS_LANG
2021-01-08 2014-11-13
Oracle errors
ORA-
2020-12-11 2014-11-05
SQL*Plus
2020-11-27
V$PARAMETER
2020-11-27 2012-09-20
Oracle generic HowTo's
2020-06-26 2016-01-07
Oracle file tree
2016-10-05 2014-11-05
Oracle, passwords and orapw
2016-09-14 2014-11-04
Data Guard and FSFO
2016-09-14 2015-10-08
Some debug tips
2016-08-02 2015-08-27
What if the storage volume dedicated to the oraarch is full ?
2016-06-30 2015-01-23
tablespaces
2016-01-19
Triggers
2015-10-30
Oracle directories and aliases
2015-10-29 2014-11-04
Where is the alert log ?
alert.log
2015-10-26
Datapump : export / import
2015-06-29
The database startup script
2015-06-29 2015-06-25
Playing with Oracle
2015-01-26
What are the current username and schema ?
2014-11-05
Is the Oracle Database Vault enabled ?

Oracle generic HowTo's

2020-11-27
How to change parameters ?
alter session, alter system, v$parameter, v$system_parameter
2020-09-22 2015-06-25
How to configure a listener ?
2020-06-25
How to list Oracle database instances ?
2020-06-25 2015-08-19
How to get the status of an Oracle instance ?
2017-10-11 2015-02-02
How to start / stop Oracle processes ?
startup, mount, nomount, shutdown, immediate, abort
2016-07-05 2015-10-16
How to make sure I have the right SYS password ?
2016-06-06
How to list / kill active sessions ?
2016-05-04
How to delete an Oracle database ?
2015-10-26
How to list schemas ?
2015-10-13
How to grant / list / revoke user privileges ?
2015-10-13 2015-05-13
How to list tables and views of a schema ?
2015-09-28 2015-01-23
How to create / alter / drop / list users ?
locked
2015-06-29
How to register the database in /etc/oratab ?
2015-06-25
How to create a database ?
2015-06-25
How to generate the tnsnames.ora ?
2015-06-25 2014-11-07
How to start / stop listeners ?
2015-06-23
How to install Oracle 12c on Debian Jessie ?
2014-11-04
How to get an exact match to show parameter ?
2012-09-20
How to delete everything from an Oracle table ?
delete, purge, truncate

Data Guard and FSFO

2016-09-14 2014-11-19
How to debug primary to standby replication ?
2016-09-06 2016-01-27
How to setup FSFO ?
2016-09-06 2016-01-14
How to configure Data Guard primary/standby replication ?
2016-07-29 2014-11-04
How to check the primary and standby databases are synchronized ?
gap
2016-07-28 2014-11-04
How to check the primary and standby databases are synchronized ? (alternate methods)
gap
2016-03-25
What if a standby database is open ?
2016-03-10
How to change the sys password of a database running Data Guard and FSFO ?
2016-03-09 2016-02-03
How to disable FSFO ?
maintenance, reboot
2015-10-28
How to view the Data Guard configuration ?
2015-05-18
How to re-synchronize a Data Guard replication ?
2015-05-07 2014-11-04
How to get status / enable / disable the synchronization process ?

SQL*Plus

2020-12-11
@, @@ and start
2020-12-02
How to disable the paging of results ?
2020-11-25 2014-11-05
How to chain queries with SQL*Plus ?
2016-07-07 2015-01-06
A dummy query for tests with SQL*Plus
2016-07-05
How to disable SQL*Plus copyright / connected / disconnected / ... messages ?
2015-08-05
How to connect to Oracle with SQL*Plus ?
2015-06-30
SQL*Plus command hacks
2014-11-19
How to format the resultset returned by SQL*Plus ?

Tablespaces

2016-06-30
How to resize a tablespace ?
2016-06-29
How to detect whether a tablespace is a smallfile or a bigfile tablespace ?
2015-01-23
How to create a tablespace ?
2015-01-23
How to list existing tablespaces ?
2015-01-23
How to delete a tablespace ?
drop

Oracle errors

2021-01-08
ORA-00904: invalid identifier
2016-10-05 2016-07-13
ORA-16175: cannot shut down database when media recovery is active
2016-10-05 2014-11-13
ORA-28000: the account is locked
unlock
2016-09-22 2016-04-05
ORA-16651: requirements not met for enabling fast-start failover
2016-09-14
ORA-00205: error in identifying control file, check alert log for more info
2016-09-14 2015-02-02
ORA-01034: ORACLE not available
2016-09-06 2016-09-02
ORA-12578: TNS:wallet open failed
2016-08-31
ORA-16532: Data Guard broker configuration does not exist
2016-07-29
ORA-16541: database is not enabled
2016-07-28
Message 5150 not found; product=rdbms; facility=DGM, Message 5151 not found; product=rdbms; facility=DGM
2016-07-27
ORA-16820: fast-start failover observer is no longer observing this database
2016-07-27
ORA-16569: Data Guard configuration is not enabled
2016-07-27
ORA-16525: the Data Guard broker is not yet available
2016-07-21
ORA-16775: target standby database in broker operation has potential data loss
2016-07-21
ORA-00119: invalid specification for system parameter LOCAL_LISTENER + ORA-00132: syntax error or unresolved network name 'LISTENER_FOOBAR'
2016-07-21
WARNING: Subscription for node down event still pending
2016-07-12 2016-05-04
ORA-09925: Unable to create audit trail file
audit_file_dest
2016-03-29 2015-04-27
ORA-01033: ORACLE initialization or shutdown in progress
2016-03-09
ORA-16824 and ORA-16825: multiple errors or warnings, including fast-start failover-related errors or warnings, detected for the database
2016-03-01 2016-02-05
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
2016-02-03
ORA-12154: TNS:could not resolve the connect identifier specified
2015-05-07
Error 1031 received logging on to the standby
2015-05-05 2014-11-03
Connected to an idle instance.
2015-02-03
ARCH: I/O error 19502 archiving log 3 to '/path/to/DBNAME/oraarch/SID_xxxxxxxxx_yy_z.arc'
2015-02-03
ORA-03113: end-of-file on communication channel
2015-02-02
ORA-27101: shared memory realm does not exist
2015-01-14 2014-11-07
ORA-12162 TNS:net service name is incorrectly specified