Re: connect failure

Sven,

Check the versions of the products that you have installed on your MS Windows NT server and any MS Windows 95/NT clients. You need to have SQLNet installed on both the server AND client(s).

I don't know what products you have installed or what your network layout is with respect to SQLNet versions, but here are some things to check. . .

Verify that your HOSTS file (on both the server and clients) includes your SERVER's ip address along with a host alias (e.g., 123.456.789.123 myserver). I'm not familiar with using a loopback for the connect string. The HOSTS file should be at \WINNT35\SYSTEM32\DRIVERS\ETC. Depending on your SQLNet nodes. . .

. . .if you have a single community with only SQLNet V1 nodes: - Install SQLNet V1 on your server
(e.g., SQLNet TCP/IP Server V1.1.6.9.0). - Install SQLNet V1 on all of your clients (e.g., SQLNet TCP/IP Client V1.1.6.9.0).

. . .if you have a single community with only SQLNet V2 nodes: - Install SQLNet V2 on your server and all of your clients.

. . .if you have a single community with mixed SQLNet V1 and V2: - Install SQLNet V1 and V2 on your server. - Install SQLNet V1 and/or V2 on all of your clients as appropriate.

You can take a look at your SQLNet Administrator's Guide (Version 2) for more information. Depending on what you have installed, the Oracle Network Products Messages Manual may also be helpful.

I hope this helps.

-William / <mailto:whuang_at_earthlink.net>

svena_at_netzservice.de wrote:
>
> Hi!
>
> I just installed the Oracle Server Release 7.2.2.4.0 on Windows NT
> Server Release 3.51 (Service Pack 3 installed). There are
> some problems connecting Oracle using SQL PLUS.
>
> Using no connect-string or :2 I may log in but using the string
> t:127.0.0.1:ORCL I retrieve the error ORA 03121. I'm sure
> that TCP/IP is properly installed...
>
> So I do not mind that I get the error ORA 03121 using a Windows 95
> Client in the net, too.
>
> Hope one of you can help.
>
> Greetings,
>
> Sven Arndt
Received on Wed Mar 27 1996 - 00:00:00 CET