Re: ORA-3121 NO INTERFACE DRIVER CONNECTED

In fact the problem that you have is the configuration of the services (Net * client and the listener)
If you installed the default database try to connect uing scott\tiger_at_beq-local or scott\tiger_at_tcp-local otherwise
do the following

Open the Net8 config program, go to the listener section open the listener and get rid of all the databases entries expect of tcpip ones, change the SID to ORCL(see below) and beq. Configure tcpip to listen on ports 1521, 1527, give the host name the name of your machine or 127.0.0.1. save your work.
Now go to services and get rid of all the services and then create one that uses tcpip give the name of the database (if you had installed the default database the sid is orcl. Save the file, exit Net8, open the services (control panel - services) start the listener (oracle-listener) or go to the orant\bin directory and run the listener8 (or something like that) and once you have the prompt "Listener> " type start and verify that everithing has starded properly.

More questions? Just post you message
Al

Rüdiger J. Schulz wrote:

> seems like a problem in your tnsnames.ora - file.
> check if the listener-name, you want connect to, is in this file!
>
> greetings
>
> Rüdiger J. Schulz
> email: r.schulz_at_berlin.de
>
> Abdul Nasar schrieb:
>
> > I installed FORMS 4.5 on NT running oracle 8. Trying to access the practice
> > database tables like emp, dept gives me the error
> > "ORA - 03121 no interface driver connected - function not performed". Can
> > anybody help me to get rid off the problem. I am new to orace and
> > developer2000;
> >
> > regards
> > nasar
Received on Fri Apr 16 1999 - 16:35:32 CDT