You are now on my old blog. Please update your bookmarks to my new blog
http://laurentschneider.com




15 June 2006

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!

1 Comments:

Blogger Komanche said...

lsnrctl star - you can use it in Oracle 9 too, it's funny ;)

29/6/06 11:07  

Post a Comment

<< Home