preload preload preload preload

Installer Oracle Instant Client sur Ubuntu


Le jeudi 06 novembre 2014 par madpellzo Oracle 8 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-12.1.0.2.0-1.x86_64.rpm
$ sudo alien -i oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
$ sudo alien -i oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
 
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/ld.so.conf.d/oracle.conf
 
Et y mettre
/usr/lib/oracle/12.1/client64/lib
 
Ensuite déclarer ce nouveau path au linker ld.so
$ 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:
TNS_ADMIN=/etc/oracle
 
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 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IP_de_votre_serveur)(PORT = port_d_ecoute))
    )
    (CONNECT_DATA =
      (SID = sid_de_votre_base)
    )
  )
 
On oubliera pas de se reconnecter pour profiter de la variable d'environnement "TNS_ADMIN".
 
Testons;
$ sqlplus64 login/password@un_nom_pour_votre_tnsname 
 
Et voilà !
 

Mots clés : oracle

  • Commentaires

  • Avatar Gravatar
     backlink
     #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 blogengine.net.
    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?
    Thanks!

  • Avatar Gravatar
     Bola168
     #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
     Http://Appadanatv.Net/
     #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?

  • Ecrire un commentaire








    Quelle est la troisième lettre du mot tqiv ?