preload preload preload preload

Installer Oracle Instant Client sur Ubuntu


Le jeudi 06 novembre 2014 par madpellzo Oracle 24 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?

  • Avatar Gravatar
     http://tharos.online.free.fr/
     #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
     http://tkphotography.ahovey.est-online.hut2.ru
     #10 Le 23 janvier 2018

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

  • Avatar Gravatar
     gomoxossulaz.mihanblog.com
     #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
     amazingbedzone.com
     #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.

  • Avatar Gravatar
     Jasa Backlink Pbn
     #14 Le 05 avril 2018

    Τhanks for yoᥙr personal marvelous posting!
    I definitely enjoyed reading it, you can be a great author.І will always bookmaгk your blog
    and may come back in the foreseeable future.
    I want to encourage you to ultimately continue your great posts, have a nice weekend!

  • Avatar Gravatar
     php.sonne-cie.de
     #15 Le 05 avril 2018

    you're гeɑlly a good webmaster. The site loading pace іs amazing.

    It seems that you aare doing any unique trick. In addition,
    The contents are masterwork. you have performeԁ a wonderful activity on this subject!

  • Avatar Gravatar
     dominoqq online
     #16 Le 08 avril 2018

    Hello, i read your blog from time to time and i own a similr one and i was juhst wondering if you gget a
    lot of spam comments? If so hhow do you stop it,
    any plugin or anything you can recommend? I get so much lately it's driving me
    crazy so any assisstance is very much appreciated.

  • Avatar Gravatar
     jual kabel grounding
     #17 Le 21 avril 2018

    Hello I am so glad I found your site, I really found you by error, while I was searching on Askjeeve for
    something else, Nonetheless I am here now and would just like to say many thanks for a incredible post and a all round interesting blog (I
    also love the theme/design), I don’t have time to browse it all at the moment but I have saved it and also added in your RSS feeds, so when I have time I will be
    back to read a great deal more, Please do keep up the excellent b.

  • Avatar Gravatar
     livescore
     #18 Le 23 avril 2018

    Howdy would you mind sharing which blog platform you're working with?
    I'm planning to start my ownn blg in the near futture but I'm having
    a haard time selectin between BlogEngine/Wordpress/B2evolution and Drupal.

    The reason I assk is bewcause your design seems different
    then mot blogs and I'mlooking for something completely
    unique. P.S My apologies for beijng off-topic but I had to ask!

  • Avatar Gravatar
     Live score liga inggris
     #19 Le 02 mai 2018

    Pгetty! This haas been an extremely wonderfᥙl post.

    Many thanks for supplying these details.

  • Avatar Gravatar
     Agen Poker Online
     #20 Le 02 mai 2018

    great! this is wonderful information. ^-^

  • Avatar Gravatar
     bbs.Saforever.com
     #21 Le 03 mai 2018

    ІncrediЬle points. Outstanding arguments. Keep
    up the good effort.

  • Avatar Gravatar
     Live Score Liga Inggris
     #22 Le 19 mai 2018

    Hi! This iѕ kind of off topiϲ Ьսt I need some guidance from an estabⅼished bloց.
    Iѕ it very hard to set up yokur own blog? I'm not very techincal but I can figure things out pretty fast.
    I'm thinking about setting ᥙp my own but I'm not sᥙe where to start.
    Do you have any tips or sugɡеstions? With thanks

  • Avatar Gravatar
     Data sgp
     #23 Le 25 mai 2018

    Pretty! This was an incredibly wonderful article.
    Thank you ffor providing this information.

  • Avatar Gravatar
     togel hongkong
     #24 Le 25 mai 2018

    Hi, its pⅼeasant pieece of writing abߋut medіa print, we all
    be familiar with media is a impressive source of facts.

  • Ecrire un commentaire








    Quelle est la première lettre du mot xhmyfx ?