NuxOra - Linux and Oracle IT website

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 wait for users to log out and then it will close the database and shutdown the instance.

Oracle logs, such as alert log file are very useful and give a good status about the databse and can explain many things, and help you to choose between different options.

Depending your needs, the situation you are facing, many options are available to start a database:

startup MOUNT
CONNECT system/manager@nuxoradb AS SYSDBA
STARTUP MOUNT PFILE=%ORACLE_BASE%\admin\nuxoradb\pfile\init.ora

The MOUNT option, starts the instance, reads the control file, and attaches the database, but does not open it.

To open and use the database:

ALTER DATABASE OPEN;

You have to do that because MOUNT option does’nt open your database

startup NOMOUNT
CONNECT system/manager@nuxoradb AS SYSDBA
STARTUP NOMOUNT PFILE=%ORACLE_BASE%\admin\nuxoradb\pfile\init.ora

The NOMOUNT option starts the instance without mounting the database. It means that only the memory structure and background processes are set up.

To open and use the database, you’ll have then to MOUNT it and OPEN it:

ALTER DATABASE MOUNT;
ALTER DATABASE OPEN;

startup READONLY
CONNECT system/manager@nuxoradb AS SYSDBA
STARTUP OPEN READ ONLY PFILE=%ORACLE_BASE%\admin\nuxoradb\pfile\init.ora

In the READ ONLY mode, You can only read, and no modification is possible, insert, update, or delete, create, later or drop are impossible to use.

And off course many options to shutdown oracle:

shutdown IMMEDIATE
CONNECT system/manager@nuxoradb AS SYSDBA
SHUTDOWN IMMEDIATE

The IMMEDIATE option won’t wait a user’s logoff either uncommitted rollback, it will shutdown the instance and close the database immediatly.

shutdown TRANSACTIONAL
SHUTDOWN TRANSACTIONAL
CONNECT system/manager@nuxoradb AS SYSDBA

The TRANSACTIONAL option tells oracle not to wait for a user to log off, but wait for the client to end the transaction that is in progress, then shut down the instance and close the database.

shutdown ABORT
CONNECT system/manager@nuxoradb AS sysdba
SHUTDOWN ABORT

The ABORT option shutdown the instance (no roll back, user sessions are killed).

And then you have a special option, in case of emergency:

shutdown ans startup FORCE
CONNECT system/manager@nuxoradb AS sysdba
STARTUP FORCE PFILE=%ORACLE_BASE%\admin\nuxoradb\pfile\init.ora

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 RAC possibilities:

Oracle11g High Availability & RAC new features

Oracle continues to enhanced Real Application Clusters in Oracle11g and we see some exciting new features in RAC manageability and enhanced performance:

• Oracle 11g RAC parallel upgrades - Oracle 11g promises to have a rolling upgrade features whereby RAC database can be upgraded without any downtime. Ellison first promised this feature in 2002, and it is a very challenging and complex 11g new feature.
  

• Oracle RAC load balancing advisor - Starting in 10gr2 we see a RAC load balancing advisor utility. Oracle says that the 11g RAC load balancing advisor is only available with clients which use .NET, ODBC, or the Oracle Call Interface (OCI).
  

• ADDM for RAC - Oracle will incorporate RAC into the automatic database diagnostic monitor, for cross-node advisories.
  

• Optimized RAC cache fusion protocols - moves on from the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized. Source: Mark Rittman
  

• Oracle 11g RAC Grid provisioning - The Oracle grid control provisioning pack allows you to “blow-out” a RAC node without the time-consuming install, using a pre-installed “footprint”. Oracle 11g OEM has have easy server blade installs where a binary footprint is tar’ed to the server blade and configured, without a cumbersome install process.
  

• Hot patching - Zero downtime patch application.
  

• Data Guard - Standby snapshot - The new standby snapshot feature allows you to encapsulate a snapshot for regression testing. You can collect a standby snapshot and move it into your QA database, ensuring that your regression test uses real production data.
  

• Quick Fault Resolution - Automatic capture of diagnostics (dumps) for a fault.

Don’t miss the live webcast -> Click here to view the live Webcast on July 11, 2007.

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 11g will be launched 11 july (and “g” is the 7th letter of the alphabet and july the 7th month of the year) Oracle 11g should be a lucky version even if it will not be launched th 7th July (07/07/07)

>> www.oracle.com

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:
http://www.oracle.com/technology/support/metalink/index.html

If you want to know which components were installed on your server:

$ORACLE_HOME/OPatch/opatch lsinventory -detail

#################################
# 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 “Done.”
echo -n “Starting Oracle Listeners: ”
su - oracle -c “lsnrctl start” >> /var/log/oracle
echo “Done.”
echo “”
echo “—————————————————-” >> /var/log/oracle
date +”! %T %a %D : Finished.” >> /var/log/oracle
echo “—————————————————-” >> /var/log/oracle
touch /var/lock/subsys/oracle
;;
stop)
echo -n “Shutting Down Oracle Listeners: ”
echo “—————————————————-” >> /var/log/oracle
date +”! %T %a %D : Shutting Down Oracle Databases as part of system down.” >> /var/log/oracle
echo “—————————————————-” >> /var/log/oracle
su - oracle -c “lsnrctl stop” >> /var/log/oracle
echo “Done.”
rm -f /var/lock/subsys/oracle
echo -n “Shutting Down Oracle Databases: ”
su - oracle -c dbshut >> /var/log/oracle
echo “Done.”
echo “”
echo “—————————————————-” >> /var/log/oracle
date +”! %T %a %D : Finished.” >> /var/log/oracle
echo “—————————————————-” >> /var/log/oracle
;;
restart)
echo -n “Restarting Oracle Databases: ”
echo “—————————————————-” >> /var/log/oracle
date +”! %T %a %D : Restarting Oracle Databases as part of system up.” >> /var/log/oracle
echo “—————————————————-” >> /var/log/oracle
su - oracle -c dbstop >> /var/log/oracle
su - oracle -c dbstart >> /var/log/oracle
echo “Done.”
echo -n “Restarting Oracle Listeners: ”
su - oracle -c “lsnrctl stop” >> /var/log/oracle
su - oracle -c “lsnrctl start” >> /var/log/oracle
echo “Done.”
echo “”
echo “—————————————————-” >> /var/log/oracle
date +”! %T %a %D : Finished.” >> /var/log/oracle
echo “—————————————————-” >> /var/log/oracle
touch /var/lock/subsys/oracle
;;
*)
echo “Usage: oracle {start|stop|restart}”
exit 1
esac

Je suis actuellement à la recherche d’un poste en region Rhône-alpes, à Grenoble.
Ma mission actuelle se termine le 30 Mars. Je suis disponible à partir du 2 Avril.

Je recherche parmi les types de postes ci dessous:
Architecte technique
Chef de projet technique
Administrateur Systeme Linux et/ou DBA Oracle

L’environnement technique du poste pourrait etre basé sur Linux, Oracle (base de données et serveur J2EE), le monde open-source (serveur d’application J2EE jboss, supervision avec Nagios/Cacti)
Le poste serait donc idéalement axé sur de fortes compétences techniques, pour un rôle d’expertise, de gestion de projet, ou d’administration (je ne souhaite plus m’orienter vers du développement)

N’hesitez pas à me contacter par mail ou par téléphone:

Formulaire de contact mail.

Mon CV (en français)

If you’d like to know how big your DB is:

select 	FILE_NAME,
d.TABLESPACE_NAME,
d.BYTES datafile_size,
nvl(sum(e.BYTES),0) bytes_used,
round(nvl(sum(e.BYTES),0) / (d.BYTES), 4) * 100 percent_used,
d.BYTES - nvl(sum(e.BYTES),0) bytes_free
from 	DBA_EXTENTS e,
DBA_DATA_FILES d
where  	d.FILE_ID = e.FILE_ID (+)
group  	by FILE_NAME,d.TABLESPACE_NAME, d.FILE_ID, d.BYTES, STATUS
order  	by d.TABLESPACE_NAME,d.FILE_ID