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

D. Patrick wrote:

> 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@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@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.
.

Relevant Pages

  • ANN: Tftpy 0.4.3
    ... Only downloads are supported at this time. ... This release adds variable block sizes, and general option support, ... Currently the sample client works, supporting RFC 1350. ...
    (comp.lang.python)
  • Re: Issuing client certificates
    ... type the URL for the file into the address bar and it downloads just fine... ... >>the box never goes away and I can not submit my client ... > cert request. ... >>I can request and issue site certs and they work just ...
    (microsoft.public.inetserver.iis.security)
  • Re: Issuing client certificates
    ... > type the URL for the file into the address bar and it downloads just ... >>>the box never goes away and I can not submit my client ... >> cert request. ... >>>I can request and issue site certs and they work just ...
    (microsoft.public.inetserver.iis.security)
  • Question about ActiveX Controls and ActiveX DLLs.
    ... When is it best to use/create an OCX project versus an ActiveX DLL? ... this because I have a project that uploads and downloads files ... want to automatically download the components to the client via the browser. ...
    (microsoft.public.vb.controls)
  • Re: Win Mob email downloads all message headers every time??
    ... It's only with IMAP accounts that it downloads all the headers, ... If you don't like this behaviour, get an alternate mailer client. ... However, when I run Windows Mobile 2002 email client on my iPAQ, & ...
    (microsoft.public.pocketpc)