SAN: hba qlogic
Driver Name: qlc
Symantec Veritas HA Cluster
Location of VCS log files On all cluster nodes, look at the following log files for any errors or status messages:
Oracle Database: Reset User Password and disable passowrd expiration.
SQL> select resource_name,limit from dba_profiles where profile=’DEFAULT’ and RESOURCE_NAME=’PASSWORD_LIFE_TIME’; RESOURCE_NAME LIMIT ——————————– —————————————- PASSWORD_LIFE_TIME 180 alter profile DEFAULT limit password_life_time UNLIMITED; alter user oblicore identified by oblicore;
mySQL overcome time type range from ‘-838:59:59’ to ‘838:59:59’ limitation
EC_TO_TIME() returns a TIME, is constrained to the range of the TIME data type, and a warning occurs for arguments resulting in values outside of that range 1. Solution DROP FUNCTION IF EXISTS BIGTIMEDIFF; DELIMITER $$ CREATE FUNCTION `test`.`BIGTIMEDIFF` (end_time…
Bash: wget recursively download website
Recursively download website wget -r –no-parent –reject “index.html*”
Find all Hard links to file
find / -xdev -samefile file1 Second Method $ ls -li file1 2655341 -rw-r–r– 3 peter peter 0 2008-09-02 19:09 file1 find /home -xdev -inum 2655341
Windows: How to clear Cached Credentials in windows
1. Open Run Window by clicking Start -> Run or click ‘Windows key’+‘R’. 2. In the text box, type the command rundll32.exe keymgr.dll, KRShowKeyMgr and click OK. Note:You can also type and run this command through Command Prompt. control…
Oracle Database check PFILE or SPFILE usage
SQL> SELECT DECODE(value, NULL, ‘PFILE’, ‘SPFILE’) “Init File Type” FROM sys.v_$parameter WHERE name = ‘spfile’; Init File Type ——————————– SPFILE SQL> SELECT DECODE(value, NULL, ‘PFILE’, ‘SPFILE’) “Init File Type” FROM sys.v_$parameter WHERE name = ‘spfile’; Init F ——…
CentOS vncserver installation
packages: yum install pixman pixman-devel libXfont