preload preload preload preload

Installer Oracle Instant Client sur Ubuntu

Le jeudi 06 novembre 2014 par madpellzo Oracle 13 commentaires

Oracle propose des packages Linux pour son client "Instant Client" mais uniquement au format RPM pour des distributions de type RedHat/Fedora/CentOS.

Voici comment installer Oracle Instant Client sur une distribution de type Debian, ici une Ubuntu Server 14.04 x64.
Télécharger les packages "basic" (librairies), "sqlplus" (le client) ainsi que "devel" (servira pour l'installation d'un module PHP Oracle OCi8 par exemple).
Les RPM n'étant pas supportés sous Ubuntu, nous allons utilisé la commande magique "alien" qui transformera nos RPM en DEB. Seuls les scripts de postinstall ne seront pas joués, nous aurons donc quelques manipulation manuelles post-installations à jouer.
Si ce n'est pas déjà fait, installer le package "alien"
$ sudo aptitude install alien
Ensuite, utilisons alien pour installer nos RPM
$ sudo alien -i oracle-instantclient12.1-basic-
$ sudo alien -i oracle-instantclient12.1-sqlplus-
$ sudo alien -i oracle-instantclient12.1-devel-
Installer la libaionécessaire à Oracle si vous ne l'avez pas déjà installé :
$ sudo aptitude install libaio1
Ajoutons le répertoire de librairies Oracle au library path de notre OS :
$ sudo vi /etc/
Et y mettre
Ensuite déclarer ce nouveau path au linker
$ sudo ldconfig -v
Créer le répertoire qui accueillera le fichier tnsnames.ora
$ sudo mkdir /etc/oracle
Déclarer ce nouveau répertoire dans votre environnement en éditant le fichier/etc/environmentet en y ajoutant cette ligne à la fin:
Créer votre fichier/etc/oracle/tnsnames.oraqui comportera le SID de votre base, le serveur ainsi que le port :
un_nom_pour_votre_tnsname =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IP_de_votre_serveur)(PORT = port_d_ecoute))
      (SID = sid_de_votre_base)
On oubliera pas de se reconnecter pour profiter de la variable d'environnement "TNS_ADMIN".
$ sqlplus64 login/password@un_nom_pour_votre_tnsname 
Et voilà !

Mots clés : oracle

  • Commentaires

  • Avatar Gravatar
     #1 Le 26 septembre 2017

    My programmer is trying to convince me to move to .net from PHP.
    I have always disliked the idea because of the costs. But he's tryiong none
    the less. I've been using WordPress on several websites for about a year and am nervous about switching to
    another platform. I have heard very good things about
    Is there a way I can transfer all my wordpress posts
    into it? Any kind of help would be really appreciated!

  • Avatar Gravatar
     Berita Aceh
     #2 Le 08 octobre 2017

    I every time used to study piece of writing in news papers but now as I am
    a user of net therefore from now I am using net for content,
    thanks to web.

  • Avatar Gravatar
     judi Casino Online
     #3 Le 23 octobre 2017

    Hey there! This is my first comment here so I just wanted to give a quick
    shout out and say I really enjoy reading your blog posts.

    Can you recommend any other blogs/websites/forums that cover the same topics?

  • Avatar Gravatar
     #4 Le 06 novembre 2017

    I have been exploring for a bit for any high-quality articles or blog posts in this kind of house .
    Exploring in Yahoo I finally stumbled upon this site.
    Studying this info So i'm satisfied to exhibit that I've an incredibly
    excellent uncanny feeling I came upon exactly what
    I needed. I such a lot for sure will make sure to don?t omit this website and give it
    a look regularly.

  • Avatar Gravatar
     agen judi online
     #5 Le 24 novembre 2017

    Keep on writing, great job!

  • Avatar Gravatar
     PIALADOMINOBET.COM Dominobet Qiu Qiu Poker Online BandarQ Online Terpercaya
     #6 Le 15 décembre 2017

    Wow, that's what I was searching for, what a stuff! present here at this blog, thanks admin of
    this site.

  • Avatar Gravatar
     #7 Le 06 janvier 2018

    We are a group of volunteers and starting a new scheme in our community.
    Your site offered us with valuable info to work on. You've done an impressive job and
    our whole community will be thankful to you.

  • Avatar Gravatar
     bandar bola
     #8 Le 07 janvier 2018

    Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point.

    You definitely know what youre talking about, why throw away
    your intelligence on just posting videos to your weblog when you could be
    giving us something informative to read?

  • Avatar Gravatar
     #9 Le 23 janvier 2018

    Today, while I was at work, my sister stole my iPad and tested to see if it can survive a forty foot drop, just so she can be
    a youtube sensation. My iPad is now broken and she has 83 views.

    I know this is completely off topic but I had to share it with someone!

  • Avatar Gravatar
     #10 Le 23 janvier 2018

    This text is worth everyone's attention.
    When can I find out more?

  • Avatar Gravatar
     #11 Le 28 janvier 2018

    I?m not that much of a online reader to be honest
    but your sites really nice, keep it up! I'll go ahead and bookmark
    your website to come back later on. All the best

  • Avatar Gravatar
     #12 Le 28 janvier 2018

    It's very straightforward to find out any topic
    on net as compared to books, as I found this piece of writing at this web page.

  • Avatar Gravatar
     Sewa bus pariwisata white Horse
     #13 Le 27 février 2018

    Hello there, You've done an excellent job. I will certainly digg it
    and personally suggest to my friends. I am confident they'll be benefited from this site.

  • Ecrire un commentaire

    Quelle est la première lettre du mot mmdbhr ?