Oracle x Client

Este forum é destinado a perguntas relacionadas a Oracle, mas que não se enquadram nos forums acima. Aqui serão tratadas também sobre outras tecnologias da oracle, como o Workflow, BPEL, Spatial, OCS, etc.
Post Reply
informatica@cofina.com.br
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 31
Joined: Mon, 08 Feb 2010 10:59 am
Location: BOM JESUS DOS PERDÕES - SP

I installed Oracle 10g Server on my server and it's working beleza, via browser (apex) I can also access other machines.
Now I did the client version installation on another machine, again confirm that via browser (apex) I can access however via sqlplus I can not.
How to make the client connect with the server?
In it should not there be the TNSNAMES file.
In what folder?

Thanks
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

The file does not always come, but inside the client_1 \ network \ admin \ admin, there is another directory called samples, there you find a tnsnames.ora for example, move it to the previous directory, and then set the parameters from your base inside it .
informatica@cofina.com.br
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 31
Joined: Mon, 08 Feb 2010 10:59 am
Location: BOM JESUS DOS PERDÕES - SP

I looked for the file in the client and does not exist anywhere and tb I can not get the file on the server because I do not know where folder it needs to be in the client
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

The folder that needs to be is the one I said,

../ Network / admin /

Look, you can use the graphical tool too to do This ...

is called Net Manager, comes along with the customer, depending on the type of installation you have chosen,

picks up another machine and Play in this directory that is simpler,
informatica@cofina.com.br
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 31
Joined: Mon, 08 Feb 2010 10:59 am
Location: BOM JESUS DOS PERDÕES - SP

In the client I do not have this Admin \ Network folder as in the server.
During client installation I can not configure anything.
I picked up this client directly from the Oracle website (oraclexeclient.exe).
I'm almost delivering the points. As one thing as simple as it can be so "complicated."
Can someone give me a link for me to download another client?

Thanks for the help
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

http://download.oracle.com/otn/nt/oracl ... client.zip
Then when running the installer, install the "Administrator" option, this option behind a toolbar, TNSNAMES, SQLPLUS, etc.
informatica@cofina.com.br
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 31
Joined: Mon, 08 Feb 2010 10:59 am
Location: BOM JESUS DOS PERDÕES - SP

no problem my oracle server be 10g and client 11g?
I will not be illegal?

More I will try

Thanks
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

No problem, install 10g, even, there is everything in the same version,
face, there is a scheme called Instant Client, it is simple to set up, just put unzip the directory to a location on the machine, put this Directory in the variable of environment path, and then create a variable environment called tns_admin, pointing to the directory where you go for your tnnames.ora file, which could be even the same director of the instant client,

99] is 48megas, against 500 and both complete client, =]
informatica@cofina.com.br
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 31
Joined: Mon, 08 Feb 2010 10:59 am
Location: BOM JESUS DOS PERDÕES - SP

With his precious help I got it.
and very good when we entered a forum where people are worried about helping the investment of repeating our questions to appear as an answer to earn points.

Thank you
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

Installed which one?
informatica@cofina.com.br
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 31
Joined: Mon, 08 Feb 2010 10:59 am
Location: BOM JESUS DOS PERDÕES - SP

Instant Client
informatica@cofina.com.br
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 31
Joined: Mon, 08 Feb 2010 10:59 am
Location: BOM JESUS DOS PERDÕES - SP

Where can I find the Oracle 10G Client for Windows 98?

Thanks
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

Vish dude, I think in this case I would have to get the 8i client, I do not know if there is huh ...

= /
informatica@cofina.com.br
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 31
Joined: Mon, 08 Feb 2010 10:59 am
Location: BOM JESUS DOS PERDÕES - SP

Client 8i and free
danilo_zg
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 14
Joined: Thu, 04 Mar 2010 9:30 am
Location: Jundiaí - SP

If I am not mistaken all the clients are free, only the DB is that there is a license ...
danilo_zg
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 14
Joined: Thu, 04 Mar 2010 9:30 am
Location: Jundiaí - SP

Select all

\oracle\product\10.2.0\client_1\NETWORK\ADMIN\
Here the path of tnnames.ora is this ...
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 16 guests