Laurent Schneider Blog

blue screen or how do a dba neglected backuping his own machine

2007-03-23T11:13:00.000+01:00

Early this week I was gently surfing on the Internet with my home PC when I got interrupted by a blue screen. Well, I was used to those in Windows 3.1 and Windows 95, but nowadays, I just waited that the machine reboot. But it did not come up. Even booting Linux from CD or using Windows Recovery CD did not help. So I think my disk or my controller crashed. At least when booting from Linux, the OS

New URL for my blog : http://schnedr.com

2007-02-27T12:00:00.000+01:00

I just added a domain pointing to my new blog :schnedr.comI also removed the ads from this blogger blog.

Oracle Magazine March 2007

2007-02-13T15:22:00.000+01:00

Check the latest issue on http://www.oracle.com/oramag

The newversion of blogger is ready... and it is no longer a beta release!

2006-12-20T12:30:00.000+01:00

I have tried to switch to beta for 3 monthes :blogger beta nightmare and lost all my post for half a day. Blogger support restored the original Blogger and I recovered my posts late in the evening.Today I noticed the new blogger is now released (the beta is dead!). I switched to the new blogger and it works fine! About 10 minutes downtime for my blog with hundreds of posts

10gr2 patchset 2 is out

2006-12-04T10:07:00.000+01:00

Please update your feeds to http://laurentschneider.com/feed

hello world

2006-11-30T12:34:00.000+01:00

I am setting a new blog at laurentschneider.comPlease update your feeds to point to http//laurentschneider.com/feed

Chinese Chess Swiss Champion 2006

2006-11-27T07:56:00.000+01:00

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

Restrict network access to listener

2006-11-22T10:18:00.000+01:00

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 = yesTCP.INVITED_NODES = (dbclient001,chltlxlsc1)chltlxlsc1 is my db server, I include it in the list, it is required to start the listener locally.From dbclient001, I can connect :$ sqlplus scott/tiger@

backup your blog!

2006-11-17T16:18:00.000+01:00

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 : answer=41447It let you change the formatting of your blog to have all your posts (max 999) and all your comments in one page. If you do not have your own ISP but use blogspot.com, then it will replace your blog by this not-fancy page. But just

pivot table

2006-11-15T11:49:00.000+01:00

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 UNPIVOTOk, back in 2003, I had a data model were all attributes were stored in same table (a miracle of java tools generating data models)select person.name, property.type, property.valuefrom

track comments

2006-11-10T10:36:00.000+01:00

This is a goodie : you can monitor comments on a blog article. Then all the new comments can be sent by mail or RSS feed.Check http://co.mments.com, you can then add a button to your browser to monitor an article for comments

How To Add The Domain Name Of The Host To Name Of The Agent

2006-11-09T11:48:00.000+01:00

I have been looking for this note for ages : Metalink note 295949.1Now 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/emdfind state upload recv agntstmp.txt lastupld.xml protocol.ini -type f -exec rm {} \;rm -r state/*to remove the agent in the grid col TARGET_TYPE for a17col

sqldeveloper 1.1 evaluation available for download

2006-11-08T10:56:00.000+01:00

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.

difference between two dates

2006-11-03T14:29:00.000+01:00

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-d1from t;D1 D2 D2-D1---------- ---------- ----------01.02.2000 23.01.2000 -9How can i get the difference in hours:minutes:seconds between two dates, d1 and d2 ?Use

alias oraver 2.0

2006-11-02T12:19:00.000+01:00

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 oraveroraver='echo '\''ORACLE_SID VERSION %CPU RSZ VSZ START_TIME'\'';awk -F: '\''/^[^ *#]/{print "printf \042%-9s %11s %5s %8s %8s %s\\n\042",$1,"$(ORACLE_HOME="$2,$2"/bin/sqlplus -v 2>/dev/null|

ps -ef |grep pmon alternative

2006-11-01T12:42:00.000+01:00

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 \042select \047+ "$1" \011\047||version from v\\$instance;\042|ORACLE_SID="$1" ORACLE_HOME="$2" "$2"/bin/sqlplus -s \042/ as sysdba\042 2>/dev/null|grep \042^+\042||echo

Unbreakable Linux

2006-10-29T14:19:00.000+01:00

Loïc + unbreakable linux Originally uploaded by laurentschneider. Is there any garantee for this one ?

London Airport

2006-10-28T13:49:00.000+02:00

I just arrived at London. I was in the same plane as Mark Rittman and now I have to wait for my flight to Zurich.On thursday after the Wrap's party I went to China Town with Henry, and I finally entered the very close american xiangqi federation. I signed up for a free account at www.chinagames.net. Not an easy task ! there is not a single word in english in this site, and yesterday I tried on my

rac automation

2006-10-27T19:06:00.000+02:00

Werner Puschitz talked yesterday about Automated Oracle Real Application Clusters Deployment: How Dell Does IT. The result of the automation is, install a 6 nodes cluster in 30 minutes. Which is quite impressive.Werner divided the automation in three RPM packages.1) configure the host: set up private and virtual interface (according to a naming convention, for example private is hostname-priv,

Long long long day

2006-10-26T16:27:00.000+02:00

Yesterday was terrible. I had sessions from 7:30am to 8:00pm. I just slept 10 hours in a row (I needed it), and now I have to hurry to Steven Feuerstein session.

Toad 9 is available

2006-10-26T16:23:00.000+02:00

In the Metreon Theater, Quest announced toad 9. Steven Feuerstein presented one feature : Unit Testing in TOAD. Go to http://www.toadworld.com, unless you are a vi man

Larry Ellison announced oracle support for redhat

2006-10-26T16:20:00.000+02:00

I like this one. It will really ease the migration to Linux. A very good news for me. Go to oracle.com/linux

11g new features part II

2006-10-26T16:00:00.000+02:00

I have been following 2 sessions with Juan Loaiza about new features.A very few of them here :SQL> create edition v1_0;SQL> alter session set edition=v1_0;You can create a versioning of your objects, so you will be able to have many versions of the same package at the same time. It is a bit similar to workspace, where you have many versions of the data at the same time. It is very profitable in

OOW 2K6 day 1

2006-10-24T16:47:00.000+02:00

I tried to watch the keynotes yesterday, but it is just to difficult to sit and not sleep for me... so I have seen only a few minutes of each one. The PL/SQL 11g session was excellent, I wrote an overview in a separate post.I started the afternoon with APC session, about the importance of testing and the power of the utPLSQL package. He presented that methodology and also the concept of testing.

winzip 11 beta

2006-10-24T16:42:00.000+02:00

a new major release of the famous compression utility for windows is available as a betahttp://www.winzip.com/betawz.cgiBetter compression, RAR+Bzip formats extraction and more

11g new features

2006-10-24T14:01:00.000+02:00

The presentation of Bryn Llewellyn was a good one! He talked about the 11g new features. Well, he said it is maybe not named 11g and maybe none of the features will be available. But since the beta is already available, I guess all of the features he talked will be available. It is very rich, and went fast, so I apologize for not relating all of them, or any mistakes that I include. The result

pictures

2006-10-23T02:04:00.000+02:00

Justin just posted a few pictures of OOW in otn blog. I also posted somes on the flickr group Eddie Awad created : http://www.flickr.com/groups/oow06/poolSince the group is public, feel free to join and post there too if you like.Here is one view of SF that make me feel in Germany :

not enough time to do all

2006-10-22T22:12:00.000+02:00

I updated my calendar for Oracle Open World. By rechecking the location, I figured out I did book to much. Unfortunately, I will not be able to go to steven feuerstein session S281918 on monday, because it starts at the same time as tom session ends.I had a difficult choice for tuesday :- S281213 (now full) Developing a Successful Database Backup and Recovery Strategy: Customer Experiences with

I am in!

2006-10-22T16:42:00.000+02:00

I just confirm my registration, got my badge and my bag. I also have my room at Fishermanns Wharf.Today I am going to China Town and in the evening to E&O -do not confuse with I/O- for the Ace dinner.

Arrived in SF

2006-10-22T08:16:00.000+02:00

After a long long flight via London I finally arrived to San Francisco. I though the journey was finished, but no, it was not. First, I took a supershuttle. The driver just confused the accelarator with the brake and damaged three vans. The motor started burning and the passagers, me included, had to exit asap. Hopefuly, nobody got injured, the baggage was safe and I found an other drive, which

apply CPUOct2006

2006-10-20T10:17:00.000+02:00

I downloaded the CPUOct2006 patch for 10.2.0.2 and applied it successfully to my database.SQL> select action,id,comments from dba_registry_history;ACTION ID COMMENTS------ ---------- ----------CPU 5490848 CPUOct2006in the logfile, apart from a few ignorable ORA-02303: cannot drop or replace a type with type or table dependents errors, everything went fine.Applying the security patch

edit search provider in IE7

2006-10-17T14:30:00.000+02:00

In about:config in firefox I wrote about editting the search engine in firefox, for example to have google.ch instead of google.com.This can be done in Microsoft Internet Explorer too, by regedit-ting HKEY_CURRENT_USER Software Microsoft Internet Explorer SearchScopes

using ovd as ldap proxy server

2006-10-10T12:30:00.000+02:00

Yesterday I posted about tnsnames in Sun Java System Direcotry Server. I have to solve one problem : sqlnet requires anonymous search capability on the ldap server. Which I cannot offer in production. So I created an Oracle Virtual Directory, which matches my anonymous request to an authenticated request to the Sun Directory.

Migration of tnsnames.ora to LDAP (Sun Java System Directory Server)

2006-10-09T14:54:00.000+02:00

In this post, I did show how easy it is to use OID to resolve your network service names. Apart OID, AD (Microsoft Active Directory) is also supported. However, I do not want to use such products, as my customer already have a Sun Java System Directory Server running.It is quite easy. Here are the steps with the SunOne Console.1) expand the schemalogin to the Directory Server as cn=directory

about:config in firefox

2006-10-07T09:23:00.000+02:00

I just discover about:config (type it in your location bar). It is a very simple configuration editor, with user settings in bold.For example I like to use a local google version to search (google.ch instead of google.com), so I configured browser.search.defaulturl

SOUG last week

2006-09-28T12:00:00.001+02:00

duplicate post of http://laurentschneider.blogspot.com/2006/09/soug-last-week.html

SOUG last week

2006-09-28T12:00:00.000+02:00

The documents from last SOUG special interest group with Tom Kyte are now available for downloadable on the soug.ch homepage (under history).The day started with Sven Vetter, who talked about SLA management pack for Enterprise Manager Grid Control 10gR2. We saw also how to define a custom shell script and let OEM generate a graphic over time. He talked about "beacons", a kind of interface to

Xiang-Qi

2006-09-27T13:39:00.000+02:00

Sunday, November 26th, 2006, I will defend my Title in the Chinese Chess Swiss Championship.It is free and open to anyone !

10gR2 solaris x86 is out

2006-09-26T16:07:00.000+02:00

Oracle Database 10g Release 2 (10.2.0.2)Enterprise/Standard Edition for Solaris Operating System (x86)

Camel

2006-09-24T11:19:00.000+02:00

Camel Originally uploaded by laurentschneider. Loïc is driving a camel

NLS_LANG=german_switzerland

2006-09-21T13:49:00.000+02:00

There is a bug about NLS_LANG and SWITZERLAND in 10g.This is because the tausend separator has changed from 9i (.) to 10g (').Check Note 4598613.8The workaround is to not use NLS_LANG=german_switzerland, but if you have different NLS parameters on the client and on the server, than you will have other problems, ex: questionable statistics by exp/imp.OK, here is the bug :$ export NLS_LANG=

OOW2006 Blogger Meetup : Tuesday 24th October, Thirsty Bear Brewing Company, 7pm

2006-09-21T11:43:00.000+02:00

blogger meetup organized by Mark Rittman

KEEP DENSE_RANK versus ROW_NUMBER()

2006-09-18T17:27:00.000+02:00

I often see questions like How do you get the row of each department with the highest salaryIn case you only want 1 row, you have two modern solutions :Analytics, which is trend, and KEEP, which is not very knownThe old fashion would be something like where s in (select max())Ok, let's start with analyticsSQL> select ename,deptno,sal 2 from (select ename,deptno,sal, 3 row_number() over (

Swiss Oracle User Group

2006-09-18T11:29:00.000+02:00

On wednesday, there is a DBA day in the SOUG community. DBA-SIG 06/4The highlight of this session will be Tom Kyte, speaking about Oracle System Architecture.Check the homepage of SOUG.CH for registration

_Workshop _be_informed_

2006-09-18T11:22:00.000+02:00

Tomorrow LC Systems is organizing an event about Identity Management in Zurich.The focus will be on Sun Java System Directory Server and Oracle Virtual Directory.

wget from otn

2006-09-15T17:02:00.000+02:00

wget is a well-known command line utility for downloading files from the internet/intranet.I like to use the limit-rate, so that my coworkers still can surf. Until today, I never succeeded to download from otn, because wgetting software required me to log in and accept the export restriction How to automate login is actually extremly easy :1) open your mozilla browser, go to the page, login,

generate dml

2006-09-15T14:15:00.000+02:00

I just discovered that cool new function in SQL/Developer just right click on the table and chose export sql insert-- INSERTING into EMPInsert into "EMP" ("EMPNO","ENAME","JOB","MGR","HIREDATE","SAL","COMM","DEPTNO") values (7369,'SMITH','CLERK',7902,to_date('1980-12-17','DD-MON-RR'),800,null,20);Insert into "EMP" ("EMPNO","ENAME","JOB","MGR","HIREDATE","SAL","COMM","DEPTNO") values (7499,'ALLEN'

children picture privacy

2006-09-13T10:14:00.000+02:00

Cannot you see the pictures anymore? Ask me to be your flickr friend !

Tom Kyte in France, Switzerland and Austria

2006-09-05T10:59:00.000+02:00

Register in Paris (18-19 sep), Zurich (21-22 sep) or Wien (25-26 sep) at oracle university for the tom kyte workshop.Lutz Hartmann wrote about this event in his blog

TUNED_UNDORETENTION

2006-08-30T14:33:00.000+02:00

How often I did meet ORA-01555: snapshot too old: rollback segment too small ? I cannot count. On one of the database I am currently administrating it is about once a day. Back to Oracle 7 and 8, the solution was usually to size the rollback segments properly. Using big rollback segments for big jobs, and many small segments for OLTP. Oracle 9i introduced the automatic undo management. When you

Linux 9.2.0.8 is out

2006-08-28T15:41:00.000+02:00

Linux x86

Solaris (Sparc) 9.2.0.8 is out

2006-08-24T13:20:00.000+02:00

Solaris Sparc 64bitsSolaris Sparc 32bits

9.2.0.8

2006-08-23T13:02:00.000+02:00

Patchset 9.2.0.8 is out for a few plateform. I am quite surprised it did not come out on Solaris 32bits first, as I expected, but rather on the followingMicrosoft Windows 32bitsMicrosoft Windows 64bitsLinux ItaniumLinux x86_64HP UX PA-RISCIBM AIX5LIBM z/OS (OS 390)This is the terminal release of 9iR2

Kindergarten

2006-08-22T12:25:00.000+02:00

IMG_2296 picture privacy Originally uploaded by laurentschneider. Dora started the kindergrten today. I was more anxious than for the OCM practicum ...

Lake of Geneva

2006-08-20T22:13:00.000+02:00

Lake of Genevapicture privacyOriginally uploaded by laurentschneider. Dora driving an electric boat !

oow2k6 sessions

2006-08-17T14:46:00.000+02:00

the sessions I registered with for oracle open world 2006 are the following :Monday 10:45 : Bryn LLewellyn, PLSQL Manager, will talk about PLSQL future in the next release (11g) : session S281172Monday 12:30 : Andrew Clarke, Oracle ACE, will talk about unit testing in PL/SQL : session 282112Monday 15:15 : Thomas Kyte, Oracle ACE and asktom owner, will talk about sql worst practice : session

blogger beta nightmare

2006-08-16T11:40:00.000+02:00

Do not switch to blogger beta. It failed, and everything is corrupted on my page, I cannot fix it yet (this message will probably only be readable as feed). Take care!

OpenWorld Connect Group Oracle Blogger

2006-08-15T13:40:00.000+02:00

I created a new group in OpenWorld Connect. In San Francisco I would like to meat other people writing and reading blogs.If you have not actived openworld connect yet, you can update your profile on http://www.cplan.com/oracleopenworld2006/leverageoptin, than join the Oracle Blogger group at Oracle Blogger

tablespace maintenance tasks

2006-08-14T14:12:00.000+02:00

I just had to guide one of our DBA this morning.How to get free of segments in SYSTEM tablespace : tables SQL> select owner, table_name from dba_tables where tablespace_name='SYSTEM' and owner not in ('SYS','SYSTEM','OUTLN');OWNER TABLE_NAME----- ----------SCOTT TSQL> alter table scott.t move tablespace users;Table altered.SQL> select owner, table_name from dba_tables where tablespace_name='

latest patchset

2006-08-10T16:49:00.000+02:00

Huge downtime on forums.oracle.com today. After landing on an Error-500 page, I discovered a quick and neat overview of oracle patchsets, accessible without metalink account :http://www.oracle.com/technology/support/patches.htmStill waiting for 9.2.0.8 Solaris by the way, announced for 2006Q3, whatever this mean

sqlnet.wallet_override=true

2006-08-10T11:18:00.000+02:00

I recently posted about Oracle Password Repository (OPR).I did get a comment from Andreas Piesk about something similar in Oracle, the wallet.Let's do a quick test.First, I create a .sqlnet.ora in my home directory (I do not want to mess up the system-wide sqlnet.ora).$ cat /home/lsc/.sqlnet.oraSQLNET.WALLET_OVERRIDE=TRUEWALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/home/lsc)))I

select last rows

2006-08-04T14:43:00.000+02:00

I just read about a query to retrieve last modification row of a dateSQL> SELECT ora_rowscn FROM tab_test;ORA_ROWSCN----------3517443517443517443517443517443517446 rows selected.SQL> UPDATE tab_test SET valeur=valeur*1.1 WHERE col_id=1;3 rows updated.SQL> commit;Commit completeSQL> SELECT ora_rowscn FROM tab_test:ORA_ROWSCN----------3517443517443517443714233714233714236 rows selected.conclusion

Oracle OpenWorld 2006

2006-08-03T19:22:00.000+02:00

I just registered to Oracle OpenWorld in October in San Francisco... Well, I know it is a long long long way to the west, but I will survive again, but this time I will avoid Delta Airlines, they refused to serve me a glass of wine last year in the plane! I am going to take maybe Lufthansa.As an ACE, I got the Oracle Develop for free this year too. I also took the gold pass, well, waiting hours

Swiss Day

2006-08-02T16:04:00.000+02:00

Yesterday was August 1st, and we celebrated the 715th anniversary of Switzerland. I recently moved to a new flat in Birmensdorf, which is a village close to Zurich. The village offered free Potatoes salad and Fleischkäse to the inhabitants, delicious :-) Due to the hot weather and lack of rain last weeks, they prohibit fireworks in canton Zurich. So in the night, we went to Canton Aargau, where I

OTN forums new release

2006-08-02T10:32:00.000+02:00

I read forums.oracle.com frequently. I have read and answered thousands of questions there. Those days, they launched a new release, I do not know what the improvements are, but it is fairly unstable. Well, it has been worst in the past, but I keep getting We're sorry, the server encountered an unexpected condition and timetouts occasionaly.Another nightmare for users was the blank-trimming

oas-console

2006-07-27T14:11:00.000+02:00

oas-console Originally uploaded by laurentschneider. I installed OAS 10.1.3 on my notebook. Why? well, just to test if it is installable... and to justify my need of 2Gb of memory to my boss ;-)Ok, SLES10 is not certified yet, Not even planned yet on metalink. But it will definitely be certified one day. The first step is to install the necessary packages 1) db1 : Berkeley DB Database

Novell SLES10 Oracle Database

2006-07-26T10:53:00.000+02:00

Novell SLES10 Oracle Database Originally uploaded by laurentschneider. The orarun package to be installed in SLES10

Oracle Password Repository

2006-07-25T13:33:00.000+02:00

I checked this tool today :http://sourceforge.net/projects/oprThis tool provide a simple way of not hardcoding passwords in shell scripts. Hardcoding passwords in shell scripts is a bad practice. The source code may be shared by many developers, may resides on unsecure servers (CVS), may be printed, etc... The passwords may change often too.This tool uses a simple file to stores the passwords

Installation Oracle on Suse Linux Enterprise 10

2006-07-25T09:33:00.000+02:00

How neat is Suse!I downloaded the DVD SLES10 on Novell.com. At the installation time, appart from Gnome, Development, X Window, there are a few new categories. One of them is called Oracle Database, and guess what, it installs all what I needed for Oracle. It creates an oracle account, with oinstall as primary group and dba as secondary group, it sets usefull things like ORACLE_HOME. Ok, let's

cpu july 2006

2006-07-21T12:38:00.000+02:00

I successfully applied patch 5225799 on my notebookSQL> select action,version,id,comments from dba_registry_history;ACTION VERSION ID COMMENTS------ ---------- -------- ----------CPU 10.2.0.2.0 5225799 CPUJul2006

indian readers

2006-07-19T15:15:00.000+02:00

I am aware indian and pakistan ISP did block access to blogspot blogs. There are some workaround available on google, for example to access my site from Pakistan, you may be able to use pkblogs http://www.pkblogs.com/laurentschneiderI am quite sad about this, I used to have a lot of access from India in the past (according to statcounter.com), and this is quite a limiting move for the indian

bughouse tournament

2006-07-19T15:11:00.000+02:00

I will be playing the The Geneva Bughouse Gathering 2006 tournament on Sat 19th August 2006. It is a variant of chess, very wild, played with four players in teams of two. The photo on my profile has been taken in the 2005 edition.

switzerland is out

2006-06-28T10:47:00.000+02:00

at least we got one record in the world cup 2006. We are the first team in world cup history that got eliminated without receiving one goal :-)

new oracle feed

2006-06-28T10:12:00.000+02:00

subscribe to blogs.oracle.com recent posts entries

sles10

2006-06-27T22:24:00.000+02:00

Download of the pre-release version of Suse Linux Entreprise 10 is now available http://www.novell.com/linux/prerelease.html?sourceid=prerelease1

oracle magazine

2006-06-22T08:46:00.000+02:00

I just received my Oracle Magazine yesterday. Blair Campbell from Oracle published my interview in the peer-to-peer columns. Go to otn.oracle.com/oramag

oracle partner workshop : database 10g

2006-06-15T14:31:00.000+02:00

Last month I had an application server seminar I blogged in SOA . Yesterday it was database 10g day.First we had exactly the same talk about EMEA marketing, vision, partner and blabla for one hour. I did not expect to hear this comparison between Oracle Database and the C: prompt (origin) and fusion and mswin (ultimative achievement)... I almost told him than the C: prompt was not the first

Germany we are coming

2006-06-13T21:07:00.000+02:00

Germany we are coming Originally uploaded by laurentschneider. this cow is funny, it is quite exceptional for Switzerland to play in the World Cup !

Loïc

2006-06-10T20:58:00.000+02:00

Loïc picture privacy Originally uploaded by laurentschneider. It is the first time we swim outside this year, and it is cool (16°C) !

exp/imp

2006-06-01T13:17:00.000+02:00

EXP / IMP has a quite a lot of bugs and limitations.Today I had a trouble with a function based index first, generating ORA-942 table does not exist on import. I also had an error with AQ.I have a few invalid objects too :before exp, on source system (tru64/9.2.0.4)SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*)---------- 54after imp, on target system (rh4/10.2.0.2

oracle 7 bin

2006-05-30T22:39:00.000+02:00

oracle 7 bin Originally uploaded by laurentschneider. end of life of oracle 7 reference, cd and documentation

Oracle 7 Apero

2006-05-30T18:22:00.000+02:00

Today we definitely shutdown our last productive Oracle7 database. Quite good news actually, I can now use set newp none, sqlplus "/ as sysdba" in all my scripts, svrmgrl is no longer needed (well, sometimes in 8i to do abort, but this is rare), and we garbage a hudge bin of reference manuals and cds!And it is a good atmosphere, we talk about the good old time and this long life with no support

mod_plsql

2006-05-23T14:23:00.000+02:00

mod_plsql is an oracle module for Apache. Let's do it from A to Z.I install HTTP server. In 10g, it is located on the companion cd and requires a separate oracle home.I copy my tnsnames.ora in COMPANIONHOME/network/adminThen, I configure COMPANIONHOME/Apache/modplsql/conf/dads.conf SetHandler pls_handler PlsqlDatabaseUsername scott PlsqlDatabasePassword

Michel Hascoët

2006-05-12T11:27:00.000+02:00

Michel Hascoët Originally uploaded by laurentschneider. Michel Hascoët is Principal Consultant in Oracle France and gives workshop for SOA integration

Dessert Buffet at Hilton Hotel

2006-05-12T11:25:00.000+02:00

Dessert Buffet at Hilton Hotel during the seminar Originally uploaded by laurentschneider. Taking energy for the second part of the seminar

SOA

2006-05-12T09:53:00.000+02:00

The seminar yesterday focused on SOA, Service Oriented Architecture. Teacher Michel Hascoët gave us an impressive demo with his notebook and JDeveloper; the SOA Workshop is usually taking four days, and for us he did it in one day.Ok, first ADF. With JDeveloper, he created with just a few clicks a connection to a database, dropped two screens, one for browsing customers, one for editing a

Technology Seminar Oracle Application Server 10gR2

2006-05-08T17:39:00.000+02:00

I will attend the following OraclePartner Event :Oracle Application Server 10gMai 11th, 2006Hotel Hilton Zurich Airport

No more wheels

2006-05-07T19:34:00.000+02:00

No more wheelspicture privacyOriginally uploaded by laurentschneider. A sunny sunday, a bike without training wheels, an unique experience :-)

set my ORACLE_HOME, PATH, ORACLE_SID

2006-05-03T11:01:00.000+02:00

I posted yesterday some of my aliases. My favorite (and most obfuscated) one is the following (for bash)eval $(awk -F: '/^[+a-zA-Z]/{l=tolower($1); sub("^+","",l); print "alias "l"=\047x="$2";PATH=${PATH//$ORACLE_HOME/$x}; ORACLE_HOME=$x; ORACLE_SID="$1"; echo ORACLE_SID="$1"; \047; "}' /etc/oratab 2>/dev/null)I am setting my path and a default sid/home in my .profile[ -z "$ORACLE_SID" ] &&

OCM preparation

2006-05-02T15:33:00.000+02:00

The OCM 10g Upgrade is currently under development, and the OCM 10g exam should be available in May.How will I prepare for the 10g OCM?Part I, get confident with the environment :According to http://education.oracle.com/certification, the exam will be on redhat AS3 with DB 10.1.0.4. RHAS3 is not free. If I had not RH in my company, I would then probably use WhiteBox Linux or a similar RedHat

Oracle Application Server

2006-04-28T12:19:00.000+02:00

One month ago, I attended an Oracle Application Server course in Geneva, Switzerland. We were a group of 3 students and the 5-days lesson has been extremly interesting and intense. Starting at 9am, we used to finish at 5:30pm or later.At LC Systems, we have a few customers using OAS, that is why I did jump into this non-database product cursus.As I experienced in the course, it is quite different

Ralph Bellinghausen

2006-04-28T12:13:00.000+02:00

Ralph Bellinghausen Originally uploaded by laurentschneider. Oracle Application Server 10gR2 course in Oracle University, Geneva

oracle secure backup is out

2006-04-27T12:07:00.000+02:00

Oracle Secure Backup is out. It enables the use encryption of backup on tapes, it can help you to save on media library costs (no need from a media manager any more).Well, I am curious how many customer will take the challenge to migrate from tivoli or netbackup to oracle secure backup...

dbms_sheduler jobs

2006-04-21T14:03:00.000+02:00

I read in blog from Pete Finnigan about the potential security hole in DBMS_SCHEDULER package.DBMS_SCHEDULER as a new alternative for DBMS_JOB by Patrick SinkeNote that on some OS, like AIX5L / oracle 10.2.0.2, the job runs as ORACLE, not as NOBODY

OCP Column

2006-04-21T13:39:00.000+02:00

There is a new INSIDE OCP column in the Oracle Magazine this month (May-June 2006 Edition). It is about the Application Server exam. In the magazine, it is referenced as 1Z1-311, but the beta phase ended half a year ago, so the exam is now production 1Z0-311. I could guess most answers, and I hope I can succeed at first try, which is no sure thing. Anyway, I will try it next Friday at Oracle

Ice Cake

2006-04-20T22:16:00.000+02:00

Ice Cakepicture privacyOriginally uploaded by laurentschneider. Dora at her fourth birthday

New PC

2006-04-20T21:52:00.000+02:00

I bought a new PC at Eastern. I have installed 100Gb partition for Linux and 100Gb for Windows. I tried Fedora Core 5 and OpenSuse 10.0, in 64bit mode. I currently spend most of my "free" time to prepare the OCA Application Server certification, next friday (28th). Tonight I borrowed a game from a friend : Unreal Tournament 2004. I haven't play such a game since a long time, and I must say, I

solaris x86-64 is out

2006-03-24T15:15:00.000+01:00

Oracle Release a solaris release for the intel/amd 64bits platform.This is the first release ever from oracle on solaris x86-64. Download Oracle Database 10g Release 2 (10.2.0.1.0) for Solaris Operating System (x86-64) now

isqlplus and sqlplusw desupport

2006-03-21T08:17:00.000+01:00

isqlplus and sqlplusw (gui sqlplus windows) will be desupported in 2010. Read Note 359855.1 and Note 359859.1 on Metalink.Oracle recommends migrating to Raptor (SQLDeveloper) or to Application Express (HTMLDB) or command line sqlplus.Oracle Support apparently does not know that Raptor changed name before going to production, well, names change so often, it is difficult to know them all!

dba workshop

2006-03-20T13:16:00.000+01:00

Last week I gave an internal 2-days dba course. All three students had good experience of filesystem backup and unix, but hardly any oracle experience.I figured out recovery is more complex than I thought! By explaining to other, how often do you realise do you do not know the answer yourself? It has been very educative to me too...First inconsistency I discovered :I tried to simulate a disaster