Re: ORA-03121

In article <4e8u1h$9rg_at_nntp.novia.net>, rick_at_novia.net says...
>
>
>I just installed Oracle Workgroup Server on a Windows NT box. I am a
>first time Oracle user. The install went fine, however, I am getting
>this pesky error ( ORA-03121 : NO INTERFACE DRIVER CONNECTED)
>What does this mean? Thanks in advance.
>

It is indicating a problem with SQL*NET or your choice of protocol in your connect string. It could be that you did not install the SQL*NET adapter that you are trying to use or you have not started the Windows NT Services that correspond to the SQL*NET products.

Check the following:

1. Runnning ORAINST.EXE will show you what SQL*NET network protocols you installed on the server. Make sure that the protocol you are using is listed on both the server and client side (ie. If you use SQL*NET TCP/IP V1 on the client side, the server needs to have the SQL*NET TCP/IP V1 software installed.)
2. From Program Manager: Open Main, Control Panel, Services and make sure that the Windows NT services for Oracle are running. They will be named beginning with Oracle. SQL*NET V1 will be like OracleNMPListenerXXX or OracleTCPListener. SQL*NET V2 is OracleTNSListener.
3. Make sure you are using the correct connection string.
4. Read the User's Guide to make sure you actually finished the install.

If you still have problems, please include in your next note:

1. What version of Oracle and platform you are using.
2. What SQL*NET products you have installed on the server and client.
3. What connect string you are using. If you are using SQL*NET V2, then you will need to include the information from the TNSNAMES.ORA file.

-- 
Jeffrey S. McFarlane   Oracle DBA     Shell Services Company
http://www.lookup.com/Homepages/71915/home.html
mailto:jeffmc_at_shellus.com