Post reply

Which Oracle Client features are needed?

  • November 12, 2008 at 2:24 am

    #202617

    Hi all

    I already configured many linked server connections (sql2005 > oracle 10g).

    Now I want to know which things of Oracle Clinet I have to install that everything works fine (including transactions 🙂 )?

    Till now I installed the whole software, but now I want only the necessary objects....

    Any help is appreciated....

    Thanks...

  • November 12, 2008 at 4:14 am

    #897415

    I would do a standard Oracle client installation.

    Trying to trim the client software looks to me like a attempt to get into troubles.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • November 13, 2008 at 4:38 am

    #897977

    As far as I remember till Oracle 9i there were Runtime and Administrator preset types of client installation.

    For basic SQL Net connection you need Runtime.

    For exp/imp, SQLLoader utilities or Management Console you need Administrator.

    For OLE DB you have to go to Custom installation and check the Windows Interfaces (or something like that) manually.

    Maybe it's the best solution to start with Runtime and add additional components you need running the installation one more time and choosing Custom method.

    It seems that from 10g there is Instant type, too. Which is basically smaller version of Runtime, but some sites are not recommending using this type. I have never used it, so if you need smallest footprint maybe you could try.

    Check these sites:

    http://www-wnt.gsi.de/oragsi/PCclient.htm

    http://download.oracle.com/docs/cd/B28359_01/install.111/b32077/install_overview.htm#CHDGGDGJ – AIX Doc’s but it’s a windows client

    http://www.oracle.com/technology/tech/oci/instantclient/index.html

  • November 13, 2008 at 5:01 am

    #897990

    thanks very much for your help and links....

    solution..

    first of all i will install the runtime component and after that the other components (with connection tests between the installations)...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply