switzerland is out

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

subscribe to blogs.oracle.com recent posts entries

sles10

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

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

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 think to appear in MSDOS, but the A: prompt, well, if I will say it next time ;-)

The workshop appeared to be 100% pure Dormicum™. We heared about partitioning, parallel query, real application cluster, flashback database, undo management, in about 250 powerpoint slides and not a single line of sql in the whole presentation. Well, not willing to blame the teacher, I just felt losing my time listening to this superficial presentation of oracle database.

About the things I found interesting :
- Using the listener as http server. Especially interesting is to use lsnrctl star to start the listener (just joking).


listener.ora
HTTP= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=chltlxlsc1) (PORT=8080)) (presentation=http) (session=raw))

$ lsnrctl star http
LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 15-JUN-2006 15:05:30

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /app/oracle/oracle/product/10.2.0/db_2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.2.0 - Production
System parameter file is /app/oracle/oracle/product/10.2.0/db_2/network/admin/listener.ora
Log messages written to /app/oracle/oracle/product/10.2.0/db_2/network/log/http.log
Listening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=chltlxlsc1.lcsys.ch) (PORT=8080)) (presentation=http) (session=raw))



than I should be able with the package DBMS_EPG to administer the website

- An Excel plugin : well, if your marketing department is hooked on excel, there is a plugin which enable you some connectivity within your spreadsheet. You can download it on otn for free on BI Spreadsheet Addin. I did not try it yet, but it did look sexy.

- As last month, the pause has been enjoyable. Fine starters, great cat fish, delicious dessert, No wine at lunch time, I had to wait until at 5pm!

Germany we are coming

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

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

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(*)
----------
54


after imp, on target system (rh4/10.2.0.2)
SQL> select count(*) from dba_objects where status='INVALID';

COUNT(*)
----------
142240


let's recompile
SQL> @?/rdbms/admin/utlrp

SQL> select count(*) from dba_objects where status='INVALID';

COUNT(*)
----------
2699


... better, but still too much !

I probably did hit bug 3169196 too. The workaround is delicious :

manually clean the data dictionary

Well, I am going to drop the destination database and try again...