Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 (@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 - 12:27:12 CST