Re: Troubles with SQL*Net...no connect...

From: Ian A. MacGregor <ian_at_jupiter.SLAC.Stanford.EDU>
Date: 10 Jul 92 17:57:59 GMT
Message-ID: <4578_at_unixhub.SLAC.Stanford.EDU>


In article <4577_at_unixhub.SLAC.Stanford.EDU>, ian_at_jupiter.SLAC.Stanford.EDU (Ian A. MacGregor) writes:
|> In article <eickler.710612953_at_hathi>, eickler_at_hathi.informatik.rwth-aachen.de (Andre Eickler) writes:
|> |> Hi there!
|> |>
|> |> I am currently working with Oracle V6 for Sun 3. We want to use
|> |> one machine as server and the others as clients with SQL*Net (via TCP).
|> |> The problem is, that SQL*Plus does not connect to the server giving
|> |> an error message "2729".
|> |> I looked in the manuals but did not find it (and I did not find all
|> |> the manuals additionally :) ).
|> |> This problem appears no matter what hoststring I set.
|> |> tcputl tells me "server is running" and the tcputl runs are logged
|> |> at my server machine. The unsuccessful connects of SQL*Plus are
|> |> not logged.
|> |> Does anyone have an idea what the problem could be?
|> |>
|> |> Thanks in advance,
|> |> Andre
|> |>
|> |> P.S.: Btw. we want to start a course in oracle after next week, so
|> |> a quick response would be very nice.
|>
|> Issuing the command
|>
|> oerr ora 2729 gives
|> ================================================================================
|> ian_at_tethys $ oerr ora 2729
|>
|> Oerr: Version 6.0.31.0.1 - Production on Fri Jul 10 10:11:46 1992
|>
|> Copyright (c) Oracle Corporation 1989. All rights reserved.
|>
|> 02729, 00000, "osncon: driver not in osntab"
|> // *Cause: The driver you have specified is not supported.
|> // *Action: Check with your database administrator which drivers are supported.
|> ================================================================================
|> Your sqlplus command should look similar to
|>
|> sqlplus username/password_at_t:node:sid:

 Whoops that command should be

                  sqlplus username/password_at_t:mode:sid

|>
|> Where "t" is the driver. In this case tcp. Note you set the TWO_TASK environment
|> variable to
|> t:node:sid:

Again that should be

                          t:node:sid

|>
|> After that you need only tpye
|>
|> sqlplus username/password
|>
|> to make the connection.
|>
|>
|> Ian MacGregor
|> Stanford Linear Accelerator Center
|> IAN_at_SLAC.STANFORD.EDU (415)926-3528
Received on Fri Jul 10 1992 - 19:57:59 CEST

Original text of this message