Oracle Database
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 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 [...]
Oracle’s Certification Matrices
Because i didn’t find it quickly, i’d just want to publish this very useful link to publish this access to the Certify – Oracle’s Certification Matrices: http://www.oracle.com/technology/support/metalink/index.html —°°°— Une petite info pratique que je souhaite publié parce que je ne l’ai pas trouvé rapidemment. Voici le lien pour acceder aux matrices de compatibilté Oracle: [...]
List installed oracle components
If you want to know which components were installed on your server: $ORACLE_HOME/OPatch/opatch lsinventory -detail
Oracle start/stop init script
################################# # Oracle Start/Stop init script # # v1 – nuxora.com # ################################# case “$1″ in start) echo -n “Starting Oracle Databases: ” echo “—————————————————-” >> /var/log/oracle date +”! %T %a %D : Starting Oracle Databases as part of system up.” >> /var/log/oracle echo “—————————————————-” >> /var/log/oracle su – oracle -c dbstart >> /var/log/oracle echo [...]
