Re: Troubles with SQL*Net...no connect...
Date: 10 Jul 92 17:25:23 GMT
Message-ID: <4577_at_unixhub.SLAC.Stanford.EDU>
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:
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:25:23 CEST