NuxOra - Linux and Oracle IT website

NuxOra a marqué une petite pause durant fin Avril et le mois de Mai et sera de nouveau actif des le debut du mois de Juin.

Les projets en cours:

• La documentation Jboss
• Une documentation OAS d’administration
• Quelques notes sur la 10g RAC peut-etre
• L’avancée du projet NuxOra.net et mes scripts de déploiement automatique Linux, Oracle, Apache, TSM, ….

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)

Here is a very simple script to save an Oracle database with a full export script.
It’s a very basic example, because there is no log and no option (only a full export)
Ina few days i’ll post a more detailled export script.

#!/bin/bash
#—————————#
# Oracle Full export script #
# Nuxora v1.0 #
#—————————#

# set env
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export ORACLE_SID=$1
when=`date +”%d%m”`

# export
exp expimp/$2 file=”$ORACLE_BACKUP”/admin/exp/full/$ORACLE_SID/exp”$when”_”$ORACLE_SID”_”FULL”.dmp FULL=Y ROWS=Y

# keep only 7 days
for file in `find “$ORACLE_BACKUP/admin/exp/full/$ORACLE_SID” -name “exp*.dmp” -mtime +7 -print`
do
echo $file
rm $file
done

I’ll try to write a tutorial on TAF, it seems to be very efficient but i’ve never really used it in real condition, just test. If you want to connect to TAFTEST, first it will try ton connect to NUXORA01, if something’s wrong it will try to connect to NUXORA02

DBPROD =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NUXORA01)(PORT = 1521))
(CONNECT_DATA =
(SID = ORADB01)
)
)

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NUXORA02)(PORT = 1521))
(CONNECT_DATA =
(SID = ORADB02)
)
)
)

Oracle Application Server (latest version 10g) also called OAS 10g is a very huge box. OAS is gathering various products: Oracle Portals, Oracle Reports, Oracle Forms,…. all of these running with the “kernel” of OAS: the OC4J container which belongs to the Application Server 10g instances. It is the main component of OAS. Using it, we got a Three-tier model architecture.

Three-tier is a client-server architecture in which the user interface, functional process logic (”business rules”), data storage and data access are completely independent. There are developed and maintained as independent objects. A fundamental rule in a three tier architecture is that the Client tier never communicates directly with the Data tier; in a three-tier or three-layer model all communications go through the second-tier: the Middleware tier.

The different layers in an Oracle application server 10g architecture:

> Client tier
Contains the web browsers for end users

> OAS tier
Contains the OAS (especially the OC4 container), the OHS (Oracle HTTP server) and the webcache (optional) (and sometimes other modules)

> Database tier
Contains the Database (Oracle one or another one)

Considering different aspects: business impacts, criticism, number of users…. and depending on “how much you have for your server architecture”, the Oracle application server 10g architecture can be considered as a Four-tier model.

If you firm was big enough, the OAS tier would be divided into two parts, and you would get this kind of architecture:

> Client tier
Contains the web browsers for end users

> OHS tier
the OHS (Oracle HTTP server) and the webcache (optional)

> OAS tier (or app. server tier)
Contains the OAS (especially the OC4 container) and the other OAS modules

> Database tier
Contains the Database (Oracle one or another one)

Why doing that ?

For security, flexibility, reliability… usually you don’t have only one server for each tier. At least you would have two servers for each tier. Therefore you can easily maintain the servers, you can shutdown one OHS and the application will still be available - of course it would mean that you have got a load-balancer, in front of the OHS

You can have a very scalable architecture depending on your needs and the evolution of your activities during the year.

OAS 10g is not a simple J2EE application server, it is full of optional modules/components, such as:

Middle tier:

J2EE & web services:
Oracle HTTP Server
Oracle AS Containers for J2EE(OC4J)
Oracle AS toplink
Oracle Business Components for Java (BC4J)
Oracle AS web services
Oracle XML developer Kit
Oracle PL/SQL
Oracle AS Map/viewer

Datamining:
Oracle Reports Server
A component which helps a lot for reports or spreadsheets filled with oracle database data.

Oracle Forms Server
format, and render end-user presentation pages, based on data in an Oracle Database.

Oracle Discoverer

Oracle Personalization
personalised webspace (url history customize data content)

Portal:
Oracle Portal
A component to create content-based web site.

Oracle Portal Developer Kit

Wireless:
Oracle AS wireless

Web Cache:
Oracle AS web Cache

‘interconnection’:
Oracle AS InterConnect
Oracle As ProcessConnect

Infrastructure:

Oracle Internet Directory (OID)
It is the oracle LDAP, to store all the user information

Single Sign-On (SSO)
authentication modules for all the oracle modules and many others which can base their system on it.

Oracle Certificate Authority

Metadata repository (or Infrastructure)
It stores Application Server 10g metadata and it manages multiple oracle components through a unique interface

This post explains how to perform an Oracle Enterprise Linux, using the graphical, mouse-based installation program (from the CD-ROM)

Lire la suite de “Enterprise Linux - Graphic Install”

L’export constitue une méthode simple pour sauvegarder une base ou pour la deplacer, il faut toutefois garder à l’esprit que l’export doit etre consistant, il n’y doit pas y avoir demodifications sur la base au cours d’un export.

Pour le réaliser, il faut d’abord créer un utilisateur nommé import ou export ou impexp

Puis lancer un script sql, sous le compte SYS.

pour une 9.2

pour une 10g

SQL > quit

à partie de la, on peut realiser un import ou un export: