Troubleshooting
Title URL Name What-files-are-in-a-CDP-NSS-V7-X-ray Questions & Answers Q: What files are in a CDP/NSS X-ray? A: Refer to the table below for CDP/NSS v7 X-ray files. Files in blue, are commonly used by Tech Support for preliminary troubleshooting. Files in green are used for further investigation. CDP/NSS
backup
幫同事把壞軌的系統硬碟復制到新的硬碟上，其本上有二種方法我都有試過 1. 不使用原機內壞軌硬碟擔心有必要檔案毀損，所以另外找一台同樣是T420的Windows 7 x64主機，安裝啟用Lenovo recovery and rescure tool將作業系統基礎備份到USB外接碟或經由eSATA接到第二顆硬碟，記得用進階模式才有比較可以用的選項好設定，這個方法很方便也都可以成功從備份好的硬碟直接開機寫回新的硬碟。 2. 使用原機內壞軌硬碟作為復原來源，使用DOS模式的ghost 11搭配參數 /IB，過程中匆略有壞軌區域並持續完成復制，完成後用Windows 7 x64 安裝光碟修理開機程序。這裡有幾個地方要注意，比如我是用卡碟機燒Windows7 x64 安裝光蹀來作修復，他會把開機磁碟用在卡碟機記憶卡的空間，另外還遇到BIOS設定開機模式有利用Both mode表示開機方式同時支援EFI和MBR，這會使Windows 7開機修理程式出錯 " The system partation was not fount". 必需將BIOS內開機模式指定成Legacy也就是MBR開機，
database
Find Oracle sid and Linux pid 標籤： Oracle Oracle sid and Linux pid Sometimes we found Oracle process that has been running too long using top command on Linux. We know it has PID. But how to know the SID of the process? Here is the script: select substr(a.
database
ORA-01555 :：snapshot too old Error Message 標籤： Oracle ORA-01555 Error Message 出現ORA-01555錯誤，通常有下列情況： SQL語句執行時間太長，或者UNDO表空間過小，或者事務量過大，或者過於頻繁的提交，導致執行SQL過程中進行一致性讀時，SQL執行後修改的前鏡像（即UNDO資料）在UNDO表空間中已經被覆蓋，不能構造一致性讀塊（CR blocks）。 這種情況最多。 解決的辦法： （1）增加UNDO表空間大小 （2）增加undo_retention 時間，默認只有15分鐘 （3）優化出錯的SQL，減少查詢的時間，首選方法 （4）避免頻繁的提交 ORA-01555 caused by SQL statement below (SQL ID: 52ssczq4j3vp6, Query Duration=
configuration
ORA-00060: Deadlock Detected 標籤： Oracle ORA-00060: Deadlock Detected 關於資料庫鎖死的檢查方法 一、 資料庫鎖死的現象 程式在執行的過程中，點擊確定或保存按鈕，程式沒有回應，也沒有出現報錯。 二、鎖死的原理 當對於資料庫某個表的某一列做更新或刪除等操作，執行完畢後該條語句不提 交，另一條對於這一列資料做更新操作的語句在執行的時候就會處於等待狀態， 此時的現象是這條語句一直在執行，但一直沒有執行成功，也沒有報錯。 三、鎖死的定位方法 通過檢查資料庫表，能夠檢查出是哪一條語句被鎖死，產生鎖死的機器是哪一台。 當從alter log發現ORA-00060，代表Deadlock已經解除Detected. Alter log:發生Deadlock，查看此檔案 Wed Nov 6 10:10:04 2013 ORA-00060: Deadlock detected. More info in file
database
查詢誰Lock住Oracle 標籤： Oracle Oracle sid and Linux pid 為什麼會Lock呢？因為user在update table的時候，沒有做commit的動作，ORACLE就會把它Lock，而在一次在更改的時候，就會形成Wait狀態。 Sometimes we found Oracle process that has been running too long using top command on Linux. We know it has PID. But how to know the SID of the process? Here is the script: 查詢Oracle誰Locks住Table:
backup
建立Recovery Catalog的步驟&RMAN指令 標籤： Oracle 建立Recovery Catalog的步驟(11gAW2_Chapter3,4) 1.選擇reocvery catalog所在的database 2.建立獨立使用的tablespace(建議) 3.建立獨立的user(建議) 4.授權recovery_catalog_owner角色給step 3所建立的user 5.建立recovery catalog 6.註冊target database到recovery catalog(僅需一次) 7.RMAN常用指令 1.連結到Recovery catalog [oracle@oracleDB ~]$ sqlplus sys/oracle@192.168.56.1:1521/orcl as
backup
Problem Steps to remove NetBackup Media Server Deduplication Pool (MSDP) configuration from a NetBackup environment Solution Warning: These steps will expire all images associated with the MSDP that is to be removed! Note: For NetBackup version 7.0.1, the script in step 13 is only available with the latest
backup
The Linux client backup process log /var/log/commvault/Log_Files/clBackupChild.log The error log like this: 21020 521c 07/28 17:28:31 11 CFileReader::isLocked(682) – fcntl(/mnt/nfs/build/EZStart-USB-Silver/development/USB_Silver_Images/FDR/OEL_6SP3-V8.20/gUSB3650MB-Install-6.4.181-FDR-8.20-9309-OEL6U5.img.zip, F_GETLK)
Java
VM Host custom Java Control Panel offers graphing of basic JVM parameters. You need to enable 'monitor' attribute in your JCP and wait a 5 minutes before graphs fill with data. On `'tats' page you can select different graphing periods. See example graph below. To closer
Have a look in /var/lib/roundcube/config/defaults.inc.php (in Ubuntu 16.04.1) if the following lines exist and are correct ——————————————————————————————————— // store draft message is this mailbox // leave blank if draft messages should not be stored // NOTE: Use folder names with namespace prefix (INBOX. on Courier-IMAP) $config[
Troubleshooting
Question As I don't know the openssl command's arguments by heart, I am used to referring to the same SO answer whenever I need to create self-signed certificates (for testing environments). The command looks like: openssl req -x509 -nodes -newkey rsa:2048 -keyout mysite.key -out