Oracle
Resume – IT Manager
My “French CV” is now translated and available in English. If you’d like to have my English resume please visit: http://cv.nuxora.com or download the word resume or pdf resume.
Lister et arreter un job Oracle
Un petite question posée par mail il y a peu: Pour lister les jobs SQL> connect system/xxx SQL> select job, schema_user, next_date, what from dba_jobs; JOB SCHEMA_USER NEXT_DATE WHAT —— ————– ——— ——————– 1 SYSMAN 19-OCT-08 EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); 100 CRM 19-OCT-08 CRM_PROCS(); 101 STAT 19-OCT-08 STAT_JOB_PROCS(); Pour supprimer un job SQL> exec dbms_job.remove(215); PL/SQL procedure successfully [...]
Générer un rapport AWR
J’ai recu une demande pour savoir comment générer un rapport AWR sous Oracle. Voici un petit exemple pour se connecter à la base et générer un AWR en mode test [root@nuxora01 ~]# su – oracle [oracle@nuxora01 ~]$ export ORACLE_SID=nuxodb [oracle@nuxora01 ~]$ sqlplus system@nuxodb SQL*Plus: Release 10.2.0.1.0 – Production on Sun Aug 31 08:40:22 2008 Copyright [...]
Startup and Shutdown Options
When everything is ok, you should do like that: startup STARTUP OPEN PFILE=%ORACLE_BASE%\admin\nuxoradb\pfile\init.ora shutdown CONNECT system/manager@nuxoradb AS SYSDBA SHUTDOWN NORMAL The OPEN option starts the instance, reads the control file, attaches the database, and then opens it. The OPEN option is the default option, it is not mandatory to write it. The NORMAL option will [...]
Oracle got a Wiki
All is said in the post title, Oracle has launched a wiki. This official public oracle wiki will permit to share content, information dealing with oracle technologies, with a very collaboratively tool, just try it [Oracle's WiKi]
Oracle Database 11g Launch
Oracle is going to launch today Oracle Database 11g On Oracle website you can join a live webcast about this new version. it will be at 10 a.m. ET We had to wait 4 long years to have these 482 new features with data compression for example or hot patching (that sounds great) or new [...]
Oracle 11g will be launched the 11 July
It’s now official, Oracle has announced the release of Oracle 11g on 11th July 2007. Since last October and the OpenWorld conference, Oracle was anouncing this new version. A lots of new features will be avalaible in this 11g version. That will be detailed on a future post. Of course i’m sure you notice that [...]
Information Request
You’d like to have a post or a tutorial about linux (redhat, fedora) Oracle (database, 10g, RAC or OAS – oracle application suite), Nagios, Cacti,… Feel free to ask and i’ll try to answer to your question. Leave a comment with your question.
