Re: I can't find a SETUP.EXE in the SQL Plus Client ??

From: Dave <solomonsdad.w.marksandwhom_at_oracle.com>
Date: Wed, 21 Jun 2006 09:11:13 +0100
Message-ID: <ls7mg.14$oA2.52_at_news.oracle.com>


[Quoted] D. Patrick wrote:

[Quoted]  > b) I wanted the Windows client. I don't see that specifically on the  > downloads page we referenced.

Not sure if the downloads page referenced was this one: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

If it was, then you need "Instant Client - Basic" and "Instant Client Package - SQL*Plus"; that's all. At the bottom of the page are "Installation Steps"; mine is installed in c:\ora_ic.

> a) I have the IP address and server name. How do I build this into the
> username? I never got to enter an IP or anything.

That's insufficient for connecting to Oracle. Oracle stores data in schemas (similar to different user IDs on a computer), each of which has its own password, and this is the username and password you're being asked for. There is no installer with what you have downloaded; it is a manual install and it sounds like you've done that successfully.

There really is no other way than contacting someone responsible for the DB, and we're not being unhelpful by saying that - we just don't know what is setup on the machine. You're asking something akin here to "I've got this computer. What's the username and password".

Once you've installed Instant Client and SQL*Plus, you'll need to connect with three parameters in the format schema/password_at_alias. The schema name and password you get from your DBA (that really is as helpful as I can be, honest; there is no way of working it out), and the alias is something you setup yourself in the (possibly new) tnsnames.ora file in the instant client directory. Here's one from my system:

DB101 =

   (DESCRIPTION =

     (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = v101)
     )

   )

DB101 is my alias, so I would connect to Oracle with, for example, sqlplus user/pass_at_db101 (note that sqlplus user/pass will connect you to the local database, i.e. the one you have installed, and will fail if you haven't got one, so from what you've said you need to specify the alias). 127.0.0.1 replaces what I had previously and is the IP address of the computer; alternatively you can use a host name but that will delay as the Oracle client does a DNS lookup. Port is the port the listener is listening on for connections and you'll need to get that from the DBA; you could try 1521 which is the default, but if that doesn't work then you'll definitely need to ask the DBA. Service_name is also something you'll need to get from the DBA, and everything else will probably work.

So to summarise, here's what you need from the DBA (or the person who gave you the IP address, who by definition can't be completely non-techie):

Schema name
Schema password
Listener port
Service name

With this info you *should* be able to connect.

Dave. Received on Wed Jun 21 2006 - 10:11:13 CEST

Original text of this message