All public logs

Combined display of all available logs of Dirty Cache Wiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 11:19, 13 June 2024 Bart talk contribs created page AWR Performance (Created page with "Category:DBCollect {{stub}} = Overview = Sometimes, generating AWR reports can be very slow. This article lists some potential remedies. * Solution 1 <syntaxhighlight lang=sql> alter session set "_push_join_predicate"=false; OR alter session set "_optimizer_push_pred_cost_based" = false; </syntaxhighlight>")
• 14:23, 28 May 2024 Bart talk contribs created page Template:Dbinfo (Created page with " ''dbinfo''")
• 14:22, 28 May 2024 Bart talk contribs created page DBCollect/DBInfo (Created page with " = Overview = {{dbinfo}}")
• 13:26, 28 May 2024 Bart talk contribs created page DBCollect/Usage (Created page with " = Verify correct install = <syntaxhighlight lang=bash> # Show version dbcollect -V # SHow usage dbcollect -h </syntaxhighlight>")
• 12:24, 24 May 2024 Bart talk contribs created page DBCollect/Updating (Created page with " = Overview = If the system has https access, {{dbcollect}} can update itself: <syntaxhighlight lang=bash> # Update dbcollect: dbcollect --update # Without root access, the new version will be saved as /tmp/dbcollect. # Move it manually to the required location. </syntaxhighlight>")
• 11:17, 24 May 2024 Bart talk contribs created page AWR Report (Created page with "{{stub}}") Tag: Visual edit: Switched
• 11:06, 24 May 2024 Bart talk contribs created page Category:DBCollect (Created blank page) Tag: Visual edit: Switched
• 11:05, 24 May 2024 Bart talk contribs created page Template:Dbcollect (Created page with " ''dbcollect''")
• 11:05, 24 May 2024 Bart talk contribs created page DBCollect/AWR Reports (Created page with " = Overview = By default, {{dbcollect}} tries to generate AWR reports for each detected and running database instance on the host. However, creating AWR reports require the Oracle Diagnostics Pack license. This page explains how {{dbcollect}} deals with this requirement. {{stub}}")
• 10:59, 24 May 2024 Bart talk contribs moved page DBCollect/Iinstall to DBCollect/Install without leaving a redirect
• 10:57, 24 May 2024 Bart talk contribs created page DBCollect (Created page with "TBD") Tag: Visual edit
• 10:56, 24 May 2024 Bart talk contribs moved page Dbcollect to DBCollect/Overview without leaving a redirect
• 10:52, 24 May 2024 Bart talk contribs moved page DBCollect install to DBCollect/Iinstall without leaving a redirect
• 10:51, 24 May 2024 Bart talk contribs moved page DBC:Ansible to DBCollect/Ansible without leaving a redirect
• 10:51, 24 May 2024 Bart talk contribs moved page DBC:Main page to DBC:Main Page without leaving a redirect
• 10:47, 24 May 2024 Bart talk contribs created page DBC:Main page (Created page with " {{subpages|DBC:}}")
• 10:40, 24 May 2024 Bart talk contribs created page DBC:Ansible (Created page with " = Overview = ''dbcollect'' can be run on multiple hosts in one go using Ansible. This document describe how to setup and run dbcollect using Ansible Playbooks.")
• 13:23, 15 May 2024 Bart talk contribs deleted page E001 (content was: "#REDIRECT E001_Generic_Error", and the only contributor was "Bart" (talk))
• 13:12, 15 May 2024 Bart talk contribs deleted page Category:Errors (content was: "Error help for DBCollect", and the only contributor was "Bart" (talk))
• 14:26, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-W006 (Created page with "{{ error | [DBC-W006] Reading DMI info failed (message) }} On Linux, DBCollect tries to retrieve platform information via virtual files (/sys/class/dmi/id). Some of these files cause OS errors when trying to read them. Solution: No action required, DBcollect will proceed normally.")
• 14:25, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-W005 (Created page with "{{ error | [DBC-W005] Executing <command> failed (message) }} The given command failed to execute. Possible reasons: * Command does not exist in $PATH * Command requires root privileges (dbcollect never runs as root) Solution: No action required, DBcollect will proceed normally, just skipping the problematic command")
• 14:24, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-W004 (Created page with "{{ error | [DBC-W004] Skipping <instance>: No prior AWR usage or Statspack detected (--ignore) }} DBCollect could not detect prior AWR usage on <instance> and skips AWR reports alltogether for this instance due to the ignore flag. Solution: No action required, DBcollect will proceed normally. Be informed that the DBCollect data will be incomplete and may not result in the correct assessment.")
• 14:23, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-W003 (Created page with "{{ error | [DBC-W003] Writing data to zip file failed: <file> (message) }} Saving some data in the DBCollect ZIPfile failed due to (message). Solution: No action required, DBcollect will proceed normally.")
• 14:23, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-W002 (Created page with "{{ error | [DBC-W002] <instance>: No prior AWR usage detected, continuing anyway (--force-awr) }} Informational message: DBCollect could not find prior usage of AWR reports, but the force flag was used so it continues genertating AWR reports anyway. Solution: No action required, DBcollect will proceed normally.")
• 14:22, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-W001 (Created page with "{{ error | [DBC-W001] Subprocess <subprocess> interrupted }} A subprocess was aborted due to a keyboard interrupt (CTRL-C). Solution: If dbcollect was aborted, restart it with the correct parameters.")
• 14:22, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E023 (Created page with "{{ error | [DBC-E023] Job generator failed, rc{{=}}returncode }} The job generator subprocess failed with the given returncode. Check the logfiles for any issues. If the problem remains, {{bugreport}}")
• 14:20, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E022 (Created page with "{{ error | [DBC-E022] Worker failed, rc{{=}}returncode }} A worker subprocess failed with the given returncode. Solution: {{bugreport}}")
• 14:20, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E021 (Created page with "{{ error | [DBC-E021] No AWR or Statspack detected for <instance> (try --force-awr or --ignore) }} DBCollect could not detect prior AWR usage and no statspack configuration for this instance. Solution: # Run dbcollect with <code>--force-awr</code> (if you are sure you have Diagnostics Pack license) # Setup Statspack, wait for at least a week to generate data and rerun (if you do not have the Diagnostics license) # Run dbcollect with <code>--ignore</code> to skip perfo...")
• 14:15, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E020 (Created page with "{{ error | [DBC-E020] Zipfile already exists: <zipfile> }} DBCollect tried to create a new zipfile but the file already exists. Solution: Run dbcollect with <code>--overwrite</code> or <code>-o</code> to overwrite the existing zipfile.")
• 14:15, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E019 (Created page with "{{ error | [DBC-E019] Failed to run SQLPlus (path): message }} DBCollect tried to run SQL*Plus but failed due an OS error (see <message>) Solution: Check if you can manually start SQLPlus from the same $ORACLE_HOME using the full path from the error message. <syntaxhighlight lang=bash> # Set environment (make sure it is the same as the one in the error message export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 export PATH=$PATH:$ORACLE_HOME/bin export ORACLE...")
• 14:09, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E018 (Created page with "{{ error | [DBC-E018] oratab not found or readable }} DBCollect failed to find or read oratab. This file is required to get a list of ORACLE_HOME directories. Solution: Check if either <code>/etc/oratab</code> or <code>/var/opt/oracle/oratab</code> exists and is readable to the oracle user.")
• 14:07, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E017 (Created page with "{{ error | [DBC-E017] inventory.xml not found or readable }} DBCollect failed to find or read inventory.xml. This file is required to get a list of ORACLE_HOME directories. Solution: The file <code>/etc/oraInst.loc</code> points to the location of the Oracle Inventory. In the inventory there should be a file named inventory.xml. Example: <syntaxhighlight lang=bash> # cat /etc/oraInst.loc inventory_loc=/u01/app/oraInventory inst_group=oinstall # ls -al /u01/app/or...")
• 14:03, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E016 (Created page with "{{ error | [DBC-E016] oraInst.loc not found or readable }} DBCollect failed to find or read oraInst.loc. This file is required to get a list of ORACLE_HOME directories. Solution: Check if the file <code>/etc/oraInst.loc</code> exists. If it is not there, Oracle is probably not properly installed. Further info: The oraInst.loc contains information on where the Oracle Inventory resides. Example: <syntaxhighlight lang=bash> # cat /etc/oraInst.loc inventory_loc=/u01...")
• 13:59, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E015 (Created page with "{{ error | [DBC-E015] Unknown error reading file <file> (error) }} DBCollect failed to read <file> as part of the set of OS files to be collected, due to an unexpected error (not a known I/O error - these are handled normally) Solution: Ignore this error and proceed.")
• 13:59, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E014 (Created page with "{{ error | [DBC-E014] Cannot create logfile <file> (message) }} Creating the DBCollect logfile (<code>/tmp/dbcollect.log</code>) failed. Solution: Check if the <code>/tmp</code> directory has free space. It could also be that a dbcollect.log file exists from another dbcollect run with a different user. Remove the logfile and retry.")
• 13:48, 14 May 2024 Bart talk contribs created page Template:Bugreport (Created page with "Submit a bugreport. See DBC:Errors/Reporting_bugs")
• 13:46, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E013 (Created page with "{{ error | [DBC-E013] Exception in <subprocess>: <message> }} An unexpected error caused a worker subprocess to abort. Solution: submit a bug report")
• 13:45, 14 May 2024 Bart talk contribs deleted page E001 Generic Error (content was: "Category:Errors Test page for Error help", and the only contributor was "Bart" (talk))
• 13:43, 14 May 2024 Bart talk contribs deleted page DBC-E002 (content was: "Stub 2", and the only contributor was "Bart" (talk))
• 13:43, 14 May 2024 Bart talk contribs deleted page DBC-Errors (content was: " = DBC-E001 = Stub = DBC-E002 = Stub 2", and the only contributor was "Bart" (talk))
• 13:42, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E012 (Created page with "{{ error | [DBC-E012] I/O error in <file>: message }} An I/O error happened reading/writing to <file> caused DBCollect to abort. Solution: Submit a bug report.")
• 13:42, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E011 (Created page with "{{ error | [DBC-E011] <instance>: Generator timeout (queue full, <seconds> seconds) }} The job generator timed out due to extremely slow generation of AWR reports. Solution: TBD")
• 13:27, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E010 (Created page with "{{ error | [DBC-E010] <instance>: Timeout (pid{{=}}<pid>, <seconds> seconds) running SQLPlus script <script> }} Running an SQL*Plus script resulted in a timeout. DBCollect will continue. Solution: This is most likely caused by known Oracle issues with the Recyclebin and/or DBA_FREE_SPACE. TBD...")
• 13:26, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E009 (Created page with "{{ error | [DBC-E009] <oracle_sid>: Terminated (pid{{=}}<pid>, rc{{=}}<returncode>) running SQLPlus script <script> }} Running an SQL*Plus script resulted in an error. DBCollect will continue. Solution: Continue processing, or file a bug report")
• 13:25, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E008 (Created page with "{{ error | Unknown platform <platform> }} The OS on which DBCollect is executing is not supported. Solution: Check if the platform you run on is supported. If you think it is, file a bug report.")
• 13:24, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E007 (Created page with "{{error | [DBC-E007] I/O error writing <file>: <message>}} DBCollect could not write a temporary HTML file after running AWR Strip. Solution: Maybe the temp directory is (almost) full. Try cleaning up space, use a different temp dir (<code>--tempdir</code> or find out why otherwise the files cannot be written.")
• 13:19, 14 May 2024 Bart talk contribs moved page DBC:Errors/Report Error to DBC:Errors/Reporting bugs without leaving a redirect
• 13:19, 14 May 2024 Bart talk contribs created page DBC:Errors/Report Error (Created page with " = Reporting errors when running DBCollect = If you run into critical errors running dbcollect, please submit a bug report along with the (partially completed) DBCollect ZIPfile (if it exists) or otherwise, the dbcollect logfile (<code>/tmp/dbcollect.log</code>) Upload procedure TBD...")
• 13:16, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E006 (Created page with "{{error | HTML Parsing error in <file>, not stripped }} DBCollect tried to strip the HTML (AWR) file from SQL sections, but encountered a HTML format error in the file (possibly the AWR report itself is corrupt or invalid). Solution: If this happens with one or a few files, it is safe to ignore. If it happens with lots of files, report the error.")
• 13:16, 14 May 2024 Bart talk contribs created page DBC:Errors/DBC-E005 (Created page with "{{error | [DBC-E005] IOerror retrieving <file>: <message>}} This happens if DBcollect cannot read a file as part of the collected data. It is related to [[{{NAMESPACE}}:{{BASEPAGENAME}}/DBC-E004]] depending on the Python version.")