Re: Need Help in getting DOS SQL*Net to work -- Willing to PAY!

Dean Dashwood wrote:
>
> Hi Steve!
>
> Not much information here, but here's two possible starting points:
>
> 1) Have you got Sql*Net Server configured properly? If you can access
> your database from a client using TCP/IP from any other platform, Sql*Net
> is configured ok. Otherwise, check the following. (My server is running
> on HP-UX - I hope the file names, etc. are similar enough that you can
> find the files I'm refering to!): a) Make sure
> $ORACLE_HOME/network/admin/listener.ora on your server contains details
> of your database b) Make sure the listener is started. On HP-UX, do this
> by logging on to Unix as the Oracle user, and typing
>
> lsnrctl start
>
> 2) Have you got Sql*Net Client configured? Check the file
> $ORACLE_HOME\network\admin\tnsnames.ora - it should contain details of
> the database's TCP/IP address and SID.
>
> Hope that helps - I found that configuring Sql*Net was the most difficult
> part of setting up a database, but once you actually understand what's
> going on, it's not all that hard!
>
> In article <3415DAD5.EDF2AB76_at_bigfoot.com>,
> Steve Harvancik <harvancik_at_bigfoot.com> wrote:
> >
> > Heelllpppp;
> >
> > Will pay handsomely anyone who can help us get our DOS SQL*Net working.
> > We have all the pieces and are unable to get this working. Please help
> > us. We are trying to get Oracle SQL*Net TCP/IP Version 1.x with or
> > without V2Lite Patch working with Unixware Oracle version 7.x with
> > version 1.x or 2.x of listener.
> >
> > --
> > Steve Harvancik
> > Systems Analyst
> > ICA Insurance
> > sharvancik_at_icaebc.com
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Steve,

I guess that Deans's recommendation are not working in your case, since they apply to sqlnet V2 and your are working with sqlnetV1. These two versions are not compatible. You should start a listener process by using the command tcputl. This will start the v1 listener. This listener does not use tnsnames.ora or listener.ora. On your PC, it is important that you load the drivers at the correct sequence. Something like:

dostcp-driver
sqlpme
sqltcp

Make sure you have modified the hosts and services file. You can logon to the database as follows:

sqlplus username/password_at_T:host:database

I can not give you details, since I do not use it anymore.

Kees Huismans DBA Xerox Venray

Note: my views, not necessarily my employers etc. Received on Mon Sep 15 1997 - 00:00:00 CEST