User contributions for Bart

5 November 2024

• 14:3414:34, 5 November 2024 diff hist +1‎ DBC:Errors/DBC-E041 ‎No edit summary
• 14:3014:30, 5 November 2024 diff hist +347‎ N DBC:Errors/DBC-E041 ‎ Created page with "Category:DBCollect {{error|[DBC-E041] <sid>: SQLPlus query failed, returncode=<rc> (see logfile)}} An SQL query used to retrieve metadata failed for some reason (logfile <code>dbcollect.log</code> should show more details) Solution: Diagnose the error or send the output of the logfile. {{PrevNext|DBC:Errors/DBC-E040|DBC:Errors/DBC-E041}}"
• 14:2714:27, 5 November 2024 diff hist 0‎ DBC:Errors/DBC-E040 ‎No edit summary current
• 14:2614:26, 5 November 2024 diff hist +498‎ N DBC:Errors/DBC-E040 ‎ Created page with "Category:DBCollect {{error|[DBC-E040] <sid>: [%s] Cannot execute AWR generation procedure [ORA-???:<message>]}} Creating AWR reports failed with the given Oracle message. More debug info should be in the <code>dbcollect.log</code> file. The most likely cause is not having <code>EXECUTE</code> privileges on the <code>DBMS_WORKLOAD_REPOSITORY</code> procedures. Solution: <code>GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <user></code> {{PrevNext|DBC:Errors/DBC-E03..."
• 14:2214:22, 5 November 2024 diff hist +355‎ N DBC:Errors/DBC-E039 ‎ Created page with "Category:DBCollect {{error|[DBC-E039] <sid>: Incomplete set of workload reports (failed workers)}} Some worker processes failed (either due to timeouts or due to AWR generation issues. Solution: If there are timeout messages, diagnose AWR timeouts. For other errors, please provide the logfile. {{PrevNext|DBC:Errors/DBC-E038|DBC:Errors/DBC-E040}}" current
• 14:1914:19, 5 November 2024 diff hist 0‎ DBC:Errors/DBC-E035 ‎No edit summary current
• 14:1914:19, 5 November 2024 diff hist 0‎ DBC:Errors/DBC-E036 ‎No edit summary current
• 14:1914:19, 5 November 2024 diff hist 0‎ DBC:Errors/DBC-E037 ‎No edit summary current
• 14:1814:18, 5 November 2024 diff hist +1‎ DBC:Errors/DBC-E038 ‎No edit summary current
• 14:1714:17, 5 November 2024 diff hist +393‎ N DBC:Errors/DBC-E038 ‎ Created page with "Category:DBCollect {{error|[DBC-E038] <sid>: Insufficient privileges on V$ tables (ORA-???:<Oracle message>)}} The connection to instance <sid> failed because the user has no privileges to read <code>V$<code> or <code>DBA_*</code> tables. Solution: Grant <code>SELECT ANY DICTIONARY</code> to the user listed in the credentials file {{PrevNext|DBC:Errors/DBC-E037|DBC:Errors/DBC-E039}}"
• 14:1614:16, 5 November 2024 diff hist +348‎ N DBC:Errors/DBC-E037 ‎ Created page with "Category:DBCollect {{error|[DBC-E034] <sid>: Insufficient privileges (ORA-???:<Oracle message>)}} The connection to instance <sid> failed because the user has no <code>CREATE SESSION</code> privileges Solution: Grant <code>CREATE SESSION</code> to the user listed in the credentials file {{PrevNext|DBC:Errors/DBC-E036|DBC:Errors/DBC-E038}}"
• 14:1314:13, 5 November 2024 diff hist +429‎ N DBC:Errors/DBC-E036 ‎ Created page with "Category:DBCollect {{error|[DBC-E034] <sid>: TNS connection issue (ORA-???:<Oracle message>)}} An SQL*Plus error occured related to TNS networking - the <code>dbcollect.log</code> file should show the full output of the error message Solution: Diagnose the connection problem (try manually connecting using SQL*Plus and the given connect url from the credentials file) {{PrevNext|DBC:Errors/DBC-E035|DBC:Errors/DBC-E037}}"
• 14:1114:11, 5 November 2024 diff hist +351‎ N DBC:Errors/DBC-E035 ‎ Created page with "Category:DBCollect {{error|[DBC-E034] <sid>: Unknown Oracle error, see logfile (ORA-???:<Oracle message>)}} An unknown SQL*Plus error occured - the <code>dbcollect.log</code> file should show the full output of the error message Solution: Unknown, please provide the contents of the logfile {{PrevNext|DBC:Errors/DBC-E034|DBC:Errors/DBC-E036}}"
• 14:0914:09, 5 November 2024 diff hist +296‎ N DBC:Errors/DBC-E034 ‎ Created page with "Category:DBCollect {{error|[DBC-E034] <sid>: Invalid credentials provided (ORA-???:<Oracle message>)}} Invalid username/password provided in the credentials file for the given instance Solution: Update the entry to the credentials file {{PrevNext|DBC:Errors/DBC-E033|DBC:Errors/DBC-E035}}" current
• 14:0814:08, 5 November 2024 diff hist +10‎ DBC:Errors/DBC-E033 ‎No edit summary current
• 14:0714:07, 5 November 2024 diff hist +613‎ N DBC:Errors/DBC-E033 ‎ Created page with "Category:DBCollect {{error|[DBC-E033] <sid>: Instance not available (ORA-???:<Oracle message>)}} The instance <sid> is not in OPEN mode, so {{dbcollect}} cannot connect to it using TNS connection string. The instance may be in MOUNTED mode (Standby database) or in STARTED mode. Solution: * Skip the instance using an <code>N</code> in the 2nd field of the credentials file. * Open the database (if it should be opened) * Run {{dbcollect}} as oracle user without cred..."
• 14:0314:03, 5 November 2024 diff hist +358‎ N DBC:Errors/DBC-E032 ‎ Created page with "Category:DBCollect {{error|[DBC-E032] Cannot read credentials file <file>}} A running Oracle instance has been detected, a credentials file is specified but it cannot be read by {{dbcollect}} Solution: Check permissions of the credentials file. The user {{dbcollect}} runs as, may not have access. {{PrevNext|DBC:Errors/DBC-E031|DBC:Errors/DBC-E033}}" current
• 14:0214:02, 5 November 2024 diff hist +445‎ N DBC:Errors/DBC-E031 ‎ Created page with "Category:DBCollect {{error|[DBC-E031] <sid>: No valid ORACLE_HOME provided (try --orahome)}} A running Oracle instance has been detected, but no ORACLE_HOME is detected to use with the instance. Potential cause: No entry in <code>/etc/oratab</code> or the permissions do not allow the user to read this file. Solution: Verify contents and permissions of the <code>oratab</code> file. {{PrevNext|DBC:Errors/DBC-E030|DBC:Errors/DBC-E032}}" current
• 14:0014:00, 5 November 2024 diff hist +307‎ N DBC:Errors/DBC-E030 ‎ Created page with "Category:DBCollect {{error|[DBC-E030] <sid>: Timeout connecting to instance}} {{dbcollect}} could not connect with the instance <sid> within the given timeout (currently 2 seconds). Solution: Figure out why connecting using SQL*Plus takes so long {{PrevNext|DBC:Errors/DBC-E029|DBC:Errors/DBC-E031}}" current
• 13:5813:58, 5 November 2024 diff hist +300‎ N DBC:Errors/DBC-E029 ‎ Created page with "Category:DBCollect {{error|[DBC-E029] <sid>: No credentials provided)}} A running Oracle instance has been detected, a credentials file is specified but it has no entry for the given instance. Solution: Add an entry to the credentials file {{PrevNext|DBC:Errors/DBC-E028|DBC:Errors/DBC-E030}}" current
• 13:5313:53, 5 November 2024 diff hist +229‎ N DBC:Errors/DBC-E028 ‎ Created page with "Category:DBCollect {{error|"[DBC-E028] Cannot obtain oracle base directory (<file>)}} The orabasetab file cannot be opened. Solution: Check the permissions on this file {{PrevNext|DBC:Errors/DBC-E027|DBC:Errors/DBC-E029}}" current
• 13:5013:50, 5 November 2024 diff hist +368‎ N DBC:Errors/DBC-E027 ‎ Created page with "Category:DBCollect {{error| [DBC-E027] <sid>: No valid connection (check credentials?) }} {{dbcollect}} could not make a valid connection to Oracle instance <sid>. Solution: Try again with different credentials (if using a credentials file) or specify an alternative ORACLE_HOME using <code>--orahome</code> {{PrevNext|DBC:Errors/DBC-E026|DBC:Errors/DBC-E028}}" current
• 13:4713:47, 5 November 2024 diff hist +237‎ N DBC:Errors/DBC-E026 ‎ Created page with "Category:DBCollect {{error|[DBC-E026] <sid>: Parsing instance info failed}} Retrieving metadata for instance <sid> failed. Solution: Unknown, submit the logfile for debugging. {{PrevNext|DBC:Errors/DBC-E025|DBC:Errors/DBC-E027}}" current
• 13:4513:45, 5 November 2024 diff hist +11‎ DBC:Errors/DBC-E025 ‎No edit summary current
• 13:4513:45, 5 November 2024 diff hist +214‎ N DBC:Errors/DBC-E025 ‎ Created page with "Category:DBCollect {{error|Not a valid NMON file: <file>}} The file listed is not a valid NMON file. Solution: Unknown, submit the logfile for debugging. {{PrevNext|DBC:Errors/DBC-E024|DBC:Errors/DBC-E026}}"
• 13:4313:43, 5 November 2024 diff hist 0‎ DBC:Errors/DBC-E024 ‎No edit summary current Tag: Manual revert
• 13:4313:43, 5 November 2024 diff hist 0‎ DBC:Errors/DBC-E024 ‎No edit summary Tag: Reverted
• 13:4113:41, 5 November 2024 diff hist +4‎ DBC:Errors/DBC-W009 ‎No edit summary current
• 13:4113:41, 5 November 2024 diff hist 0‎ m DBC:Errors/DBC-W009 ‎ Bart moved page DBC:Errors/W009 to DBC:Errors/DBC-W009 without leaving a redirect
• 13:4113:41, 5 November 2024 diff hist +8‎ DBC:Errors/DBC-W008 ‎No edit summary current Tag: Manual revert
• 13:4013:40, 5 November 2024 diff hist 0‎ m DBC:Errors/DBC-W008 ‎ Bart moved page DBC:Errors/W008 to DBC:Errors/DBC-W008 without leaving a redirect
• 13:4013:40, 5 November 2024 diff hist −8‎ DBC:Errors/DBC-W008 ‎No edit summary Tags: Manual revert Reverted
• 13:3913:39, 5 November 2024 diff hist +8‎ DBC:Errors/DBC-W007 ‎No edit summary current
• 13:3913:39, 5 November 2024 diff hist +8‎ DBC:Errors/DBC-W008 ‎No edit summary Tag: Reverted
• 13:3813:38, 5 November 2024 diff hist 0‎ DBC:Errors/DBC-W009 ‎No edit summary
• 13:3813:38, 5 November 2024 diff hist +425‎ N DBC:Errors/DBC-W009 ‎ Created page with "Category:DBCollect {{ error | [DBC-W009] sysstat timer not active, not collecting OS performance data }} The sysstat timer is not enabled. Sysstat is used to retrieve OS performance statistics. Solution: Enable the sysstat timer. <syntaxhighlight lang=bash> # as root # Enable (newer, systemctl based distro's): systemctl enable --now sysstat-collect.timer </syntaxhighlight> {{PrevNext|DBC:Errors/W007|DBC:Errors}}"
• 13:3513:35, 5 November 2024 diff hist +559‎ N DBC:Errors/DBC-W008 ‎ Created page with "Category:DBCollect {{ error | [DBC-W008] sysstat not installed, not collecting OS performance data }} The sysstat RPM package is not installed. Sysstat is used to retrieve OS performance statistics. Solution: install (and enable where needed) the sysstat package. <syntaxhighlight lang=bash> # as root yum install -y sysstat # or (newer RHEL and compatibles) dnf install -y sysstat # or (SuSE) zypper in sysstat # Enable (newer, systemctl based distro's): systemctl e..."
• 13:3113:31, 5 November 2024 diff hist +5‎ DBC:Errors/DBC-W007 ‎No edit summary
• 13:3113:31, 5 November 2024 diff hist +4‎ DBC:Errors/DBC-W002 ‎No edit summary current
• 13:3113:31, 5 November 2024 diff hist +4‎ DBC:Errors/DBC-W003 ‎No edit summary current
• 13:3013:30, 5 November 2024 diff hist +4‎ DBC:Errors/DBC-W004 ‎No edit summary current
• 13:3013:30, 5 November 2024 diff hist +4‎ DBC:Errors/DBC-W005 ‎No edit summary current
• 13:3013:30, 5 November 2024 diff hist +8‎ DBC:Errors/DBC-W006 ‎No edit summary current
• 13:2913:29, 5 November 2024 diff hist +5‎ DBC:Errors/DBC-W006 ‎No edit summary Tag: Manual revert
• 13:2813:28, 5 November 2024 diff hist −5‎ DBC:Errors/DBC-W006 ‎No edit summary Tags: Manual revert Reverted
• 13:2813:28, 5 November 2024 diff hist +5‎ DBC:Errors/DBC-W006 ‎No edit summary Tag: Reverted
• 13:2713:27, 5 November 2024 diff hist +400‎ N DBC:Errors/DBC-W007 ‎ Created page with "Category:DBCollect {{ error | [DBC-W007] Skipping %s: disabled in credentials file }} A detected instance is not processed because a credentials file is used and the "enabled" field in the credentials file is set to "N". This is needed to avoid trying to connect to a MOUNTED (Standby DB instance) or STARTED instance, resulting in all kinds of errors. {{PrevNext|DBC:Errors/W006|DBC:Errors}}"

10 October 2024

• 16:0516:05, 10 October 2024 diff hist +5‎ DBCollect/Security ‎ →‎Safety current
• 16:0516:05, 10 October 2024 diff hist +13‎ DBCollect/Security ‎ →‎Copyright and disclaimer
• 16:0416:04, 10 October 2024 diff hist +140‎ DBCollect/Security ‎ →‎Safety