Month: November 2006

I was honored to receive this trophy yesterday : More results under http://www.sxv.ch/news_2006.php

If I have a limited number of db clients which are authorized to access my listener, I can restrict access to my listener by setting only two parameters in sqlnet.ora. TCP.VALIDNODE_CHECKING = yes TCP.INVITED_NODES = (dbclient001,chltlxlsc1) chltlxlsc1 is my db server, I include it in the list, it is required to start the listener locally. […]

You surely have not missed the “Amazing November 2006 Blog Catastrophe” of Mark Rittman. I use blogger and by typing “backup blogger” in google, I found [edit]something that has been removed in the meantime (and I do not use blogger anymore) [/edit, janv 2011]. It let you change the formatting of your blog to have […]

First I apologize for the confusion with previous post of mines, where I defined row generators as pivot table. Here I talking about transposing rows into columns PIVOT and transposing columns into rows UNPIVOT Ok, back in 2003, I had a data model were all attributes were stored in same table (a miracle of java […]

I have been looking for this note for ages : Metalink note 295949.1 Now I know how to rename my targets in Grid Control! the trick is to stop the agent AH/emctl stop agent to remove the upload and state files/subdirectories cd AH/sysman/emd find state upload recv agntstmp.txt lastupld.xml protocol.ini -type f -exec rm {} […]

check Oracle SQL Developer 1.1 Evaluation Release is Now Available! PS: there is now a RPM for Linux, which I installed on my SLES 10 notebook with SUN JDK 1.6.

How can i get the difference in days between two dates, d1 and d2 ? – for example : with t as (select to_date(‘2000-02-01′,’YYYY-MM-DD’) d1, to_date(‘2000-01-23′,’YYYY-MM-DD’) d2 from dual) select d1,d2,d2-d1 from t; D1 D2 D2-D1 ———- ———- ———- 01.02.2000 23.01.2000 -9 How can i get the difference in hours:minutes:seconds between two dates, d1 and […]

Thanks to an anonymous comment in my post yesterday, I can now provide a more flexible version of my alias, which do not require the database to be running nor the sysdba privilege $ alias oraver oraver=’echo ‘\”ORACLE_SID VERSION %CPU RSZ VSZ START_TIME’\”;awk -F: ‘\”/^[^ *#]/{print “printf 42%-9s %11s %5s %8s %8s %s\\n42″,$1,”$(ORACLE_HOME=”$2,$2″/bin/sqlplus -v 2>/dev/null|cut […]

I just wrote a new alias to check if the databases are up and running. I added the version and a dash for non-running database. Needed is /etc/oratab + sysdba access to the database. Here it is : awk -F: ‘/^[^*# ]/{system(“echo 42select 47+ “$1″ 1147||version from v\\$instance;42|ORACLE_SID=”$1″ ORACLE_HOME=”$2” “$2″/bin/sqlplus -s 42/ as sysdba42 2>/dev/null|grep […]