Pages
Categories
Apex Audit Book review Bugs Character sets Database links Dataguard Email General musings Grid control Installs Linux Materialized views Old Oracle forms Performance tuning PL/SQL RAC Rman Scripts Security Sharepoint Space Spfile SQL*Net SQL Developer SQL server Stats Uncategorized Windows WordpressCategories
- Apex (1)
- Audit (1)
- Book review (2)
- Bugs (6)
- Character sets (6)
- Database links (1)
- Dataguard (1)
- Email (3)
- General musings (6)
- Grid control (2)
- Installs (10)
- Linux (16)
- Materialized views (2)
- Old (1)
- Oracle forms (4)
- Performance tuning (17)
- PL/SQL (4)
- RAC (6)
- Rman (10)
- Scripts (28)
- Security (2)
- Sharepoint (1)
- Space (6)
- Spfile (1)
- SQL Developer (1)
- SQL server (5)
- SQL*Net (4)
- Stats (4)
- Uncategorized (6)
- Windows (7)
- Wordpress (3)
Archives
- December 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- April 2009
- March 2009
- November 2008
- January 2008
- November 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
Recent Comments
- xnnc on Oracle Forms Dropdown List Item values populated from database table
- kelloggsville on ORA-38029 Object Statistics Are Locked – due to import with rows=n
- pawan on Cron fix for ulimit: max user processes: cannot modify limit:operation not permitted
- Adex on Fix for Oracle XE 1608: unable to create InstallDriver instance, return code -2147221164
- Shivaswamy on Oracle Data Guard Overview
Category Archives: Linux
sed change entire line
Here I use sed to replace the entire 2nd line in a lot of files with a new 2nd line. The shell script: for fle in `ls *.msg` do # copy file first so as can keep permissions and ownership … Continue reading
Posted in Linux, Scripts
Leave a comment
RAID internal hard disks linux
Useful commands to show RAID level of internal hard disks. On HP blade servers: /usr/sbin/hpacucli controller all show status /usr/sbin/hpacucli controller slot=0 logicaldrive all show On other servers: cat /proc/mdstat
Posted in Linux
Leave a comment
Cron during British Summer Time / Daylight Saving Time
For older versions of unix/linux, crons running at 01.* (anything from 01:00 to 01:59) do not run during the Spring Sunday time change. Those sames crons will run twice during the Autumn time change. So it is important to not … Continue reading
Posted in Linux
Leave a comment
Check if you work on a virtual/physical machine in Linux
http://www.spotht.com/2010/11/check-if-you-work-on-virtualphysical.html
FTP 421 service not available tcp wrapper hosts.allow
Files /etc/hosts.allow and /etc/hosts.deny control tcp wrapper permissions for incoming requests to linux servers. Ftp access is normally controlled by the ‘vsftpd’ line, e.g.: vsftpd: 138.134.116. 138.134.117. That would allow ftp connections from IP addresses like 138.134.116.x and 138.134.117.x. If … Continue reading
Posted in Linux
Leave a comment
IBM Tivoli restores using dsmc
As root dsmc or, for more complex configurations, specify an optfile: dsmc -optfile=/opt/tivoli/tsm/client/ba/bin/dsm-ora.opt List backup files: tsm> q backup “/oracle/*” -subdir=yes -inactive Restore: tsm> restore “/oracle/mydb/*” /oracle/ -subdir=yes -pick Note how the second mention of directory path ommits the lowest … Continue reading
Posted in Linux, Rman
Leave a comment
Server age with dmidecode|grep Date
BIOS build date should correspond to approximate manufacture date for a server, is given with (as root): dmidecode | egrep -i ‘date|product’
Posted in Linux
Leave a comment
Find delete old files
# Delete files older than 15 minutes find /ORA_DISK/redoarch/ -name ‘arch_*.dbf’ -mmin +15 -delete #Delete files older than 2 days 50 8 * * * find /ORA_DISK/redoarch/ -name ‘arch_*.dbf’ -mtime +2 -delete Old versions of unix find do not have … Continue reading
Posted in Linux, Rman, Scripts
Leave a comment
Tivoli Storage Manager simple restore
Sample restore from command line Tivoli Storage Manager. Run as root. ps -ef | grep dsm #here look to see if ‘optfile’ is set cd /mydir dsmc -optfile=/opt/tivoli/tsm/client/ba/bin/dsm-ora.opt tsm> restore /mydir/*.dbf -inactive -pick tsm> 1 #here choose which file number … Continue reading
Posted in Linux, Rman
Leave a comment
du -sk to identify space usage unix
Find out what directories are using up disk space in unix with this command: du -sk * | sort -n I often put it into a function so I can call it quickly: g () { du -sk * | … Continue reading
Posted in Linux, Space
Leave a comment