Tips and tricks
Log SQL results
If you’d like to log the result from a sql script, just prepare your sql script like that:spool result.log SET SERVEROUTPUT ON select * from dual; spool off exit Then from a command line or a script shell execute the following command: # sqlplus user/pwd@db_name @script.sql
Information Request
You’d like to have a post or a tutorial about linux (redhat, fedora) Oracle (database, 10g, RAC or OAS – oracle application suite), Nagios, Cacti,… Feel free to ask and i’ll try to answer to your question. Leave a comment with your question.
Oracle’s Certification Matrices
Because i didn’t find it quickly, i’d just want to publish this very useful link to publish this access to the Certify – Oracle’s Certification Matrices: http://www.oracle.com/technology/support/metalink/index.html —°°°— Une petite info pratique que je souhaite publié parce que je ne l’ai pas trouvé rapidemment. Voici le lien pour acceder aux matrices de compatibilté Oracle: [...]
List installed oracle components
If you want to know which components were installed on your server: $ORACLE_HOME/OPatch/opatch lsinventory -detail
The Deployment scanner – jboss
Start The conf/jboss-service.xml file is full of options. One of these ones is about the deployment scanner. If you make any change in a jboss config file then you’ll have to restart the server. Open the conf/jboss-service.xml in vi or some text editor capable of saving in plain text. Scroll near the bottom to the [...]
Lister un répertoire de manière sélective
Le plus souvent on utilisera grep $ ls -l backup/2007 | grep Feb mais parfois il peut s’aveer plus utile d’utliser awk $ ls -l backup/2007 | awk ‘$6 == “Feb”‘
create a directory tree
If you want to quick, don’t forget to use the ‘-p’ option wrong way: [john@host john]$ mkdir dev [john@host john]$ cd dev [john@host dev]$ mkdir first [john@host dev]$ cd first [john@host first]$ mkdir alpha [john@host dev]$ mkdir second [john@host dev]$ ll [john@host dev]$ cd .. [john@host john]$ mkdir prod [john@host john]$ cd prod [john@host prod]$ [...]
How to extract files from a tar.gz
usually people do: $ cd backup/2007/02 $ tar -zxvf data.tar.gz you can simply do: tar -zxvf -C backup/2007/02 data.tar.gz or even do it better: cd backup/2007/02 && tar -zxvf data.tar.gz the best way: cd backup/2007/02 || mkdir -p backup/2007/02 && tar -zxvf data.tar.gz
