Re: Unable to connect to Oracle 8

Cheat to make it work ! Hard code all IP address instead of host-names. Later on you can fix the name server problems when you are not in crisis mode.

Rock.

In article <807qo7$soh$1_at_nnrp1.deja.com>,   davbuell_at_my-deja.com wrote:
> Thanks for the information! I have almost the identical problem:
>
> 1] New install of 8i on NT server
> 2] New install of 8i on NT clients
> 3] I can connect on the server specifying the service name (_at_DEV),
> or not specifying the service (I presume that not referencing
> the service, while on the server, will connect you to the instance
> on the same machine, with the SID identical to some environment
> variable).
> 4] Copied the tnsnames.ora, sqlnet.ora from the server to a client
> machine.
> 5] From the client, I can ping the server.
> 6] From the client, I can tnsping the server! Doesn't this mean that
> the server's listener can hear me?????
>
> But -
>
> I can't connect from the client to the server, using SQLPLUS or
> server manager... (ora-12545). The trace file shows secondary
> error code: 12560, nt main errcode: 515, TNS-00515, nt secondary
> error code: 1001, nt OS err code: 0.
>
> We've tried various configurations of the client software, on the
> client - all 8i products, but different combinations of options
> in the install. We've tried various options on the client side,
> with the NET8 assistant. We've tried mucking about with the
> OS authentication stuff, on the server side. We're most in the
dark
> with the NT environment server-side stuff, as I'm coming from an
> HP-Unix background (although my colleague has a strong NT
> background).
>
> This kind of stuff is annoying, as it seems that oftentimes the
> solution is not in the documentation, or relates to a bug, etc...
> Any help would be GREATLY appreciated!!!!!!!!!!!!!!!!
>
> Thanks,
>
> Dave Buell
> davbuell_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 10 1999 - 19:27:12 CET