NuxOra - Linux and Oracle IT website

A short post to update my CV link, which was refreshed because i’m back in north of France in Lille.
Please, read my CV and feel free to contact me.

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

Je vous souhaite une bonne et heureuse année 2008, santé bonheur et réussite.

Le site a été en pause pendant deux mois, comme mes autres sites d’ailleurs. J’espere reprendre un meilleure rythme et bien rester axé sur Linux et Oracle avec des nouveaux posts dédiés à RAC.

L’autre news de ce post est la mise à jour du cv

A tres bientot

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]

La derniere version de Fedora est sortie le 8 novembre. Originalité de cette version, en plus de la version “full” traditionnelle, elle se présente sous trois angles différents:

- Fedora Games Spin : un Live DVD rempli de jeux 2D et 3D (Nexuiz, Quake, Freeciv, Nethack …)
- Fedora Developer Spin : un Live DVD qui contient seulement des programmes de développement (Eclipse, Anjuta, git, cvs, lynx, emacs, éditeur hexadécimal … )
- Fedora Electronics Lab : cette version est destinée aux personnes qui souhaitent utiliser des programmes de simulation de systèmes électroniques

La petite particularite qui m’interesse personnellement et l’amalioration de la prise en charge du wifi. NetworkManager 0.7 a été réécrit pour gagner en stabilité et en flexibilité. Celui-ci devrait assurer une plus grande rapidité de connexion, une meilleure intégration grâce à l’API Dbus et au WPA pour le wifi. (il était temps)

If you’d like to log the result from a sql script, just prepare your sql script like that:spool result.log
SET SERVEROUTPUT ON
select * from dual;
spool off
exit

Then from a command line or a script shell execute the following command:
# sqlplus user/pwd@db_name @script.sql


Of course you’be been using google for a while… but instead of reading the results, it would also be interesting to see it and see the related websites to yours or see the most relevant websites (linked to each others) dealing with a word or an expression.

For exemple, here is the result for nuxora.com :

Try it: TouchGraph

I’ve tried to use Nagios 3.0 b2 but there was a problem with the mail, this was corrected with a new beta release. You should download it if you were using the beta 2 version

Donwload Nagios