Oracle Client: When, How and Why?

[Tinho]

Gentlemen,

Forgive me the ignorance, however I am a layman in the installation and configuration part "advanced" as well as in the administrative part of the bank.

When I hear from a Client application, I imagine that this application is installed on each workstation to communicate with a server.

But when I install version XE on a local machine, do I necessarily need to install Oracle Client? I do not think so, but I just would like to be sure.

Now in case you have a virtual machine installed where my host machine is the server and the virtual machine is the client, in this case I would need to install the client application, correct?

Who can help me, thank you.

Att.,

[dr_gori]

That's it!
The client has all the libraries to connect to Bank Oracle.
You can also connect to the Bank using JDBC, which is no longer a client, but only is a Java library.

Example:
* To use PLSQL Developer you need to have Client Oracle installed.
* To use the SQL Developer (from Oracle herself), no weight, because the connection is done in Java via JDBC! So you just have the .jar and ready.

: -O

[Tinho]

Dr_Gori, thank you.

So in case of a local installation, anyway I need to install the client?

Att.,

[stcoutinho]

Hi Tinho,

How Dr_Gori explained, the Oracle Client installation on your workstation will depend on what you will do in this station or the product you intend to use to access the bank.

If you will only use a product like Oracle SQL Developer (Oracle Free Developer Tool), in this case there would be no need to install Oracle Client, since Developer allows connections to Bank via JDBC (you only need a jar file to connect to the bank), dispensing the need to install an Oracle Client.

The same would be valeria if you were to work with Oracle Apex. The development platform is situated in the browser (Chrome, Firefox and / or iexplorer), and there is no need to use an Oracle Client.

But the thing changes if you pretend to use products such as SQL * Plus, PL / SQL Developer, Toad, SQL Navigator, DBARTISAN, SQL * loader or other development tool. These products require the installation and configuration of an Oracle Client.

I for example I usually have the Oracle client installed on my machine, as I usually perform some maintenance procedures, using for this SQL * plus, SQL * loader, exp, imp, etc. I also have Oracle Xe installed because I have a local XE base to do some environment monitoring, develop small applications in Oracle Apex, test maintenance scripts, etc.

Oracle XE already comes with the bank and all the tools required to operate the Bank (SQL * Plus, IMP, EXPDP, EXPDP, IMPDP, Oracle Client, SQL * Loader, SQL * Plus , etc).

Hugs,

Sergio Coutinho

[Tinho]

So every time you have to use a third-party tool like PL / SQL Developer, Ca-Erwin I Should I Install the Client? So it is preferable to install because the use of these and other tools is frequent and common.

Maybe that's why it's making an error when trying to the database with Erwin! : Shock:

I can only install the client through command line? Does anyone have any tutorial or tip?

grateful.

[stcoutinho]

Tinho,

for Erwin, if you want to make a reverse engineering from the bank, you will need to install and set up an Oracle Client.

Now on installation procedures, it is a very easy information to meet. Below, follow some links for you to search:
[[0] [[1] [[2] [[3]
Hugs,


Sergio Coutinho

[Tinho]

Among so many download options I am in doubt?

Can I install a superior version of the database or should it be the same?

I downloaded one of these versions, however does not have the setup file to make the installation.

On one of the links in the informed articles, the version is different from all below and I was surprised because I found the file excessively for download.

Select all

Version 12.1.0.1.0  
       
  Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications  
 
Download instantclient-basic-nt-12.1.0.1.0.zip (60,582,453 bytes) (cksum - 788170417)  
 
*Instant Client Package - Basic Lite: Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support  
 
Download instantclient-basiclite-nt-12.1.0.1.0.zip (28,704,352 bytes) (cksum - 3256522486)  
 
*Instant Client Package - JDBC Supplement: Additional support for XA, Internationalization, and RowSet operations under JDBC  
 
Download instantclient-jdbc-nt-12.1.0.1.0.zip (1,573,285 bytes) (cksum - 3429252533)   
 
*Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client  
Download instantclient-sqlplus-nt-12.1.0.1.0.zip (805,618 bytes) (cksum - 4077647640)   
 
*Instant Client Package - SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client  
Download instantclient-sdk-nt-12.1.0.1.0.zip (1,774,685 bytes) (cksum - 1986485890)   
 
*Instant Client Package - ODBC: Additional libraries for enabling ODBC applications  
Download instantclient-odbc-nt-12.1.0.1.0.zip (526,039 bytes) (cksum - 2929402511)  
 
*Instant Client Package - WRC: Workload Replay Client used to replay workload for RAT's DB Replay Feature  
Download instantclient-tools-nt-12.1.0.1.0.zip (15,374 bytes) (cksum - 766304178 )  
 
*Instant Client Package - Precompiler:  Additional files for "proc" binary and related files to precompile a Pro*C application and demo 

grateful.

[Tinho]

How do I know if I have the customer installed? By default the same is not installed in the Wizard of Oracle XE right? Because despite thinking that I have not installed, unlike the passed information my PL / SQL Developer is working.

grateful.

[stcoutinho]

Tinho,

I discovered a link to download the Windows Oracle Client, version 11g.
http://www.oracle.com/technetwork/datab ... 98987.html

Instant Client is a "Light" version, which can be used as an alternative to the default Oracle Client.

But if your desire is to learn more than database, maybe it was a good to install Oracle Client from the link above. Or if you want to learn a bit of the DBA activity, you can install Oracle XE, which allows you to install a local database.

After installing Oracle Client or Oracle XE (see on the NTN or YouTube website, for example), you must configure the tnsnames.ora file to point to the desired database.

This is done, install your PL / SQL Developer and try to connect to the base.

Tinho, I recognize that the instructions are very on top, but I can not get you a complete and detailed script. You would need to go searching a little about the themes (Oracle Client Installation, Configuration TNSNAMES.ORA).

Try to first install Oracle Client or Oracle XE. For the next steps, you can ask more questions, but it would only be productive I answer you if you follow the option to install one of the two products. I do not know the intant client if you choose to install this product.

Hugs,

Sergio Coutinho

[Tinho]

Coutinho thank you all the information that are very valid and helped me a lot.

I downloaded the first recommended version and tried to follow the wizard step by the client installation, but at any time I am receiving the following error:

[ quote]

In step: Configuration -> Oracle Net Configuration Wizard;

INS-20802 Oracle Net Configuration Wizard failed

[/quote]

In the generated log file I have the following information:

Info: Error: Error detected in the environment: Oracle Home set to "C: \ Windows \ System32" In the environment is different from Oracle Home installed by the Oracle Net Configuration Wizard.
Info: Verify that the Oracle_Home environment variable or the registry definition is set to the correct value and restart the Oracle Net Configuration Wizard .
Info:

Info: The Oracle Net Services Configuration failed. The output code is 1

Warning:
Info:
Info: Completed Plugin Named: Oracle Net Configuration Assistant

I was going to open a topic to know how to treat or create Oracle environment variables, but I found it for best to use this topic. Do I need to change anything on TNSNAME or SQLNET?

I do not even know what it is and what it serves this "Oracle Net".

I already have the bank installed. Do I need to install the Client first?

grateful.

[stcoutinho]

Hi Tinho,

First things first.

What do you have installed on your work computer? Did you already have ORACLE XE installed on it? The bank to which you refer .. where is located? In your work computer or on a separate server? Which product you are trying to install on your work computer and it is giving error? It is the ORACLE CLIENT STANDARD you that I spent the last link or ORACLE CLIENT INSTANT whose download links yourself posted?

Hugs,

Sergio Coutinho

[Tinho]

I'm on my local machine, studies, and any jobs, where I have Oracle Xe 11 installed and I'm trying to install the recommended client. But at the moment that I will install gives the error informed.

grateful.

[stcoutinho]

Hi Tinho,

with Oracle Xe installed, you already have everything you need. It has the database and the client together.

You do not need to install Oracle Client Pattern or Oracle Instant Client.

Let's then focus on the connection problem of your tool with the XE database, okay?

A list of questions, before we continue:

a) What the operating system of your machine? Is Linux or Windows?
B) The Bank of Oracle Xe is in the air? Can you explain how you found that he is in the air?
c) Being it in the air, can you connect in the same via SQL * Plus?
D) Managing to connect to XE, do you already have your work tool installed?
e) What is the full name of the tool trying to use? (EX: Oracle SQL Developer, DBARTISAN)
f) Having the tool installed, did you try to connect with it? If you gave an error, what is the full message of error you encountered?

Try to answer the above questions to the point you performed (ex: I only installed the xe, but it seems that it is not in the air). Knowing at what point stopped, I believe I can help you continue the next steps.

Hugs,

Sergio Coutinho

[Tinho]

Coutinho once again thank you for helping.

but returning to the main focus of the topic, in fact I am not having any connection problem with the bank directly or indirectly through third-party tool, my doubt was from when and why install Oracle Client.

Other opportunity had opened a topic for some connectivity problems through CA-Erwin. But as I had understood that some third-party tools need to have the customer installed, I'll do some tests with Erwin to see if it solved the problem.

However, when I installed Oracle Xe 11, no additional tools such as SQL Plus or any other management and / or maintenance tool. These tools I realized after installing the client. But at the time of the installation of Oracle Client, in the pitch quoted, the error reported !!! Even so (with the error), the client was successfully installed.

grateful and regards.

[Tinho]

Now after installing Oracle Client, when trying to connect to the bank through the PL / SQL Developer, I am receiving the following error of TNS:


ORA-12154 TNS: Could not resolve the specified connection identifier
[/quote]

I uninstalled Oracle XE 11 from my machine, deletes the OrClex folder and restarted the machine when trying to reinstall the Oracle Xe 11 Again I am receiving the message that Port 1522 is already being used.

So, from what I understood from previous information, as I do not need to install Oracle Client at a local installation, would it be more obvious to uninstall the client, correct? For I suspect it is a problem of competition from another service that is using the same door.

grateful.