Ludovic DESSEMON's Oracle Blog

World Malaria Day 2008

http://www.mobilising4malaria.org/pages/en/world_malaria_day_2008.html

Oracle Metalink, web 2.0 release

I discovered a web 2.0 release of Metalink, the Oracle support website.
Actually you are using the current URL : htt://metalink.oracle.com
If you want to use the web 2.0 release, you must connect to https://csm.oracle.com/CSP/ui/index.html

Create the Database Control Repository

[oracle@myserver ~]$ emctl status dbconsole
TZ set to Europe/Paris
OC4J Configuration issue. /oracle/product/10.2.0/PCSLBL/oc4j/j2ee/OC4J_DBConsole_myserver_PCSLBL not found.

=> Here the processus to configure the DBConsole

[oracle@myserver ~]$ emca -repos create

STARTED EMCA at Apr 11, 2008 4:38:17 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: PCSLBL
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: Y
Apr 11, 2008 4:38:32 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/product/10.2.0/PCSLBL/cfgtoollogs/emca/PCSLBL/emca_2008-04-11_04-38-16-PM.log.
Apr 11, 2008 4:38:33 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 11, 2008 5:06:41 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 11, 2008 5:06:41 PM
You have new mail in /var/spool/mail/oracle

[oracle@apsrv004 ~]$ emca -config dbcontrol db

STARTED EMCA at Apr 11, 2008 5:10:35 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: PCSLBL
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional): ludovic.dessemon@xxxxxxxx.com
Outgoing Mail (SMTP) server for notifications (optional): xxx.xxx.xxx.xxx
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /oracle/product/10.2.0/PCSLBL

Database hostname ................ myserver
Listener port number ................ 1521
Database SID ................ PCSLBL
Email address for notifications ............... ludovic.dessemon@xxxxxx.com
Outgoing Mail (SMTP) server for notifications ............... xxx.xxx.xxx.xxx

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Apr 11, 2008 5:11:29 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/product/10.2.0/PCSLBL/cfgtoollogs/emca/PCSLBL/emca_2008-04-11_05-10-35-PM.log.
Apr 11, 2008 5:11:59 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for myserver
Apr 11, 2008 5:12:00 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 11, 2008 5:13:35 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 11, 2008 5:13:35 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://myserver:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 11, 2008 5:13:35 PM

Software Investment Guide

If you want to understand Oracle's licensing and pricing practices, Oracle has introduced a Software Investment Guide to help you optimize your software investment.
Lien: Software Investment Guide.

Did you know ?

Oracle DBAs can use, among others, 2 Oracle utilies to monitor and find performance problems : Statspack and AWR.
Statspack has been available since Oracle 8.1.6 and will probably obsolete in futur releases. This tool is free.
AWR (Automatic Workload Repository) is a 10g new feature, the next generation of the Statspack tool. Did you know that the AWR Report require additional licensing ? you must license the Oracle Diagnostic pack to access the AWR dictionnary views necessary for the AWR Report.
Oracle gives us a note for disabling AWR : note Metalink 436386.1
Here an extract of this note : "The Automatic Workload Repository (AWR) is an integral
part of the Oracle Database 10g Diagnostic Pack.
AWR is enabled by default because many database features that are not
part of the Diagnostic Pack such as Automatic Segment Advisor and Undo Advisor
need information captured in AWR. Use of these features, which implicitly
access some AWR views, does not require Diagnostic Pack license. What is not
permitted without the Diagnostic Pack license is direct access by customers of
AWR views and reports. Oracle, therefore, recommends that all customers,
with or without Diagnostic Pack license, leave AWR enabled so that the can
benefit from features that do not require pack license but implicitly use AWR."

Tablespaces usage

select tn.name "Tablespace",round(TABLESPACE_USEDSIZE*8/1024,2) "Used space (Mb)",
       round((tablespace_size*8-TABLESPACE_USEDSIZE*8)/1024,2) "Free space (Mb)",
       round((TABLESPACE_USEDSIZE*100/tablespace_size),2) "% used"
from DBA_HIST_TBSPC_SPACE_USAGE t, (select max(snap_id) maxid from DBA_HIST_TBSPC_SPACE_USAGE) tm, v$tablespace tn
where t.tablespace_id=tn.ts# and t.snap_id=tm.maxid;

AWR Report

In this post I will demonstrate a 10g feature : Automatic Workload Repository (AWR)
For more information about this feature I recommand an Oracle article.

1/ to manually make a snapshot :
execute DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT;

2/ to make an AWR Report :
@?/rdbms/admin/awrrpt.sql

How to monitor the flash recovery area usage ?

select sum(percent_space_used) from V$FLASH_RECOVERY_AREA_USAGE;

SUM(PERCENT_SPACE_USED)
-----------------------
                  23.55

If we flush the flash recovery area :
rm -rf /oracle/flash_recovery_area/ORCL/archivelog/*

export ORACLE_HOME=/oracle/product/10.2.0/ORCL
export ORACLE_SID=ORCL
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/network/lib:$ORACLE_HOME/lib

rman target=sys/xxxxx nocatalog << __EOF__
crosscheck archivelog all;
delete noprompt expired archivelog all;
__EOF__

select sum(percent_space_used) from V$FLASH_RECOVERY_AREA_USAGE;

SUM(PERCENT_SPACE_USED)
-----------------------
                      0

BI Publihser : Inserting Images

According to the Documentation i'm trying to insert a dynamic image (URL referenced in my XML file) in my template without success. I'm just discover a solution to my issue, here is the solution :

Element Reference from XML File

   

1. Insert a dummy image in your template.

    

2. In Microsoft Word's Format Picture dialog box select the Web tab. Enter the following syntax in the Alternative text region to reference the image URL:

   url:{IMAGE_LOCATION}
   url:{.//IMAGE_LOCATION}

3. where IMAGE_LOCATION is an element from your XML file that holds the full URL to the image.

Compile error in hidden module: Module_starter

If you are experiencing the following error when trying to load an XML sample file when building a template  under MSWord with the Oracle BI Publisher Template Builder :
    Compile error in hidden module: Module_starter

Workaround

Oracle MIX

My colleague Laurent has posted yesterday a post on Oracle Mix. I thank him for giving me cited in his note.

Oracle VM Now Available for Download

Download

Oracle VM

November 12, 2007 : Oracle announced Oracle VM, server virtualization software which supports both Oracle and non-Oracle applications.

"...Oracle VM is based on the open source Xen(TM) hypervisor technology. Oracle VM will be available for free download beginning Wednesday, November 14, 2007 at: http://www.oracle.com/virtualization ..." (source)

Real Application Cluster

I have just created a new contribution on Oracle Wiki about Real Application Cluster.
http://wiki.oracle.com/page/Real+Application+Cluster

Wiki Oracle

Un Wiki Oracle est accessible via cette URL. Je viens de me créer un compte.
Ce wiki repose sur la solution Wiki de Wetpaint.

Technorati Profile

Technorati Profile

Oracle Database 11g New Features Overview

Learn more by reading the Oracle Database 11g New Features Overview

Oracle Business Intelligence Standard Edition One

Oracle BI SE One is available since 2 days (25-JUN-2007).
This is a component of Oracle Fusion Middleware.
Target : small to medium-sized organizations.
Price : available for deployments of five to 50 users at $1,000 per user.

More information on Oracle Website.

TED Ideas worth spreading

I discovered this site this morning by reading one of my favorite blog : MacAndPhoto.
This site offers many videos, released under a Creative Commons license, so they can be freely shared and reposted.
The goal of this site is to foster the spread of great ideas.

Here a video where the speaker is Al Gore :

Oracle Coherence

Oracle Coherence is an in-memory distributed data grid solution for clustered applications and application servers, JCache-compliant.
Provides scalability for Java applications.
Oracle Coherence is more known as Tangosol Data Grid Solution. Tangosol was acquired by Oracle (March 2007).
This product belongs to Oracle Fusion Middleware family, in the Grid Infrastructure group.
Link : http://www.oracle.com/technology/products/coherence/index.html