OEM Generic service

I want to monitor the output of one script in OEM. Let’s say my script is that easy : #!/bin/ksh echo $RANDOM So I go to OEM 10gR2 Grid Control All Targets Add Generic Service – Go Name : random Select System : EM Website System Define availability based on: Service Test Test Type: custom […]


I am in the process in installing Oracle 10gR2 patch 2 with response file. There is no plenty of disk available, but installing a patch does not require as much space as specified by the runInstaller. when I start in silent mode, I get : $ ./runInstaller -responseFile /home/oracle/10202.rsp -silent Starting Oracle Universal Installer… —————————————————————————– […]


What is the length of an empty string? According to Oracle documentation, Oracle Database currently treats a character value with a length of zero as null. However, this may not continue to be true in future releases, and Oracle recommends that you do not treat empty strings the same as nulls And therefore the length […]

search for a string in all tables of a schema

this is often asked on the forums. I also needed this a while ago while reverse engineering a database model. Here is my today solution: 1) select * and extract the first column found per table with regexp (10g) SQL> select table_name,column_name from (select rownum,table_name, regexp_substr(dbms_xmlgen.getxml(‘select * from “‘||table_name||’”‘),'<[^>]*>&string</[^<]*>’) column_name from user_tables) where length(column_name)!=0; Enter […]

Oracle 9iR2 desupport

How long is Oracle 9iR2/10g going to be supported? Infinitely! Metalink updated the upcoming desupport advisory. For 8iR3, you had something like : Error Correction Support (ECS): 31-DEC-2004 Extended Support (ES): 31-DEC-2007 Extended Maintenance Support (EMS): 31-DEC-2006 Now for 9iR2, 10gR1, 10gR2, you have this : Release GA Date Premier Extended Sustaining Support Support Support […]

su in sqlplus

How to switch user in Oracle ? One approach is to change the password : SQL> connect / as sysdba Connected. SQL> select password from dba_users where username=’SCOTT’; PASSWORD —————————— F894844C34402B67 SQL> alter user scott identified by abc123; User altered. SQL> connect scott/abc123 Connected. SQL> create table t… SQL> connect / as sysdba Connected. SQL> […]

Set up ovid to use tns with your ldap server

I had a question in my mailbox today about using TNS resolution with an unsupported LDAP Server like Sun Java System Directory Server. Supported in 9i and above are only Microsoft Active Directory and Oracle Internet Directory. In 8i also Novell. So I have done this once with OVID. 1) download Oracle Virtual Directory 2) […]

Oracle Magazine January-February 2007

Check the oracle magazine on otn.oracle.com/oramag In the peer-to-peer, you can read more about 3 Oracle Aces, Steve Karam, Nicolas Gasparotto, Dave Moore. In the technology columns, three more aces talk about Oracle technlogies. Steven Feuerstein about The Right Place for PL/SQL, Arup Nanda about Recover in a Flash, and Tom Kyte about On Top-n […]

Welcome to the Oracle Database 11g Release 1 Beta Program!

Today is a good day, I have been accepted to the beta program and will be able to download 11gR1 beta 4 shortly. There is a Confidential Disclosure Agreement, so do not expect to read more on 11g here before the production release. My blog articles about 11g in OpenWorld 2006: 11g New Features 11g […]

I successfully installed 10gR2 patchset 2 on my notebook : SQL> select ACTION,VERSION,COMMENTS from registry$history; ACTION VERSION COMMENTS ——- ———- —————————— CPU CPUOct2006 UPGRADE Upgraded from SQL> select COMP_NAME,VERSION,STATUS from dba_registry; COMP_NAME VERSION STATUS ———————————– ———- ———– Oracle Expression Filter VALID Oracle Database Catalog Views VALID Oracle Database Packages and […]

How Much Is My Blog Worth?

Inspired by How Much Is My Blog Worth? My old blog, laurentschneider.blogspot.com, is worth $14,678.04 My new blog, laurentschneider.com, is worth $564.54 This is all the pain by changing domain, bye bye top position in google, bye bye backlinks… My old blog is still active, and I hope to get equivalent ranking until end of […]