Laurent Schneider

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

subscribe to blogs.oracle.com recent posts entries

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

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

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

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 

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

Starting .../bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.2.0 - Production
System parameter file is .../network/admin/listener.ora
Log messages written to .../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

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
picture privacy

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

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 :

<b>manually clean the data dictionary</b>

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