Re: can't logon! says: no interface driver connected!

On 19 Jan 99 05:15:13 GMT, suisum_at_ecn.ab.ca () wrote:

>You may have more than 2 SQL*NET versions running. Are you using Oracle 8
>and Oracle 7.3 altogether?
>
>Connor McDonald (mcdonald.connor.cs_at_bhp.com.au) wrote:
>: James wrote:
>: >
>: > BRW-15387: Login failed
>: > ----
>: > ORA-03121: no interface driver connected - function not performed

        Though I'm *only* a student, I could contribute here based on my experience with the same error message.

        I got this message repeatedly while trying to run P.O. 8 and DEV. trial versions on my home P.C.(Basic Pentium/WIN95 set-up). Connor's call on the SQL*NET is correct- but the fix seemed to vary amongst my other friends with the same problem, and myself. Here's my fix (remember, feel free to play with it yourself):

1. Forget Oracle Support, they didn't understand AT ALL.
2. Wipe every file on your box that contains anything Oracle. Installer won't de-install itself, do it from Explorer.
3. Install Dev. 1st, full install, then kill all SQL*NET files.
4. Then install P.O.8, BUT accept the NET files. Weird!?!

Now, some of my friends succeded without that install order; But basically, you'll have to play around with order of install discs and which NET files to kill, which to keep. Some are needed,some not.

        My best theory on why this is needed is that Oracle is looking for a network, but finds only your *workstation* and feels kinda lost (Boo, hoo, hoo). : - )

                        Cathexis
>: >
>: > any help would be great.
>
>: Sounds to me like one of :
>
>: SQL Net not installed at all
>: SQL Net not installed correctly (with appropriate protocol adapater)
>: Connect string not correct
Received on Tue Jan 19 1999 - 18:17:17 CST