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