Re: Connect SQL-plus 3.3 to Oracle 8 on Win NT ('ORA-03121: no interface driver connected - function  not performed'. )

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/01/22
Message-ID: <34cdaae1.2111305@192.86.155.100>#1/1

On Wed, 21 Jan 1998 22:13:59 +0100, "Eric Bosten" <bostene_at_tip.nl> wrote:

>Hi everybody,
>
>I installed Orace 8.0.3 Enterprise edition on Win NT 4.0
>I can connect with SQL-Plus 8.0 to the database.
>I cannot connect with SQL-Plus 3.3, I get the error-message
>'ORA-03121: no interface driver connected - function not performed'.
>This SQL-Plus is a part of the Designer 2.0 Beta. I cannot connect with
>Forms 5.0 or Reports 3.0 either.
>With Designer 2.0 Beta comes SQL-Net 2.3 but Oracle 8 has got SQL-Net 8.0
>
>My server and my client are ONE machine, what do I need at client and or at
>server-side ?
>
>There is:
>SQL-Net 2.3 Server
>SQL-Net 2.3 Client
>SQL-Net 8.0 Server
>SQL-Net 8.0 Client
>TNS Listener 8.0
>
>I've almost tried every combination of above, what am i doing wrong?
>
>I've got a TNSNAMES.ORA in $ORACLE_HOME\NET80\ADMIN and
>in $ORACLE_HOME\NETWORK\ADMIN
>
>Thanks in advance
>

You need to run the Net80 listener and use sqlnet 2.x to connect to the database. The steps would be:

1. create your \orant\net80\admin\listener.ora file, for example, on a standalone machine it might look like:

LISTENER =
  (ADDRESS_LIST=
    (ADDRESS=

        (PROTOCOL=IPC)
        (key=extproc)

    )
    (ADDRESS=

        (PROTOCOL=TCP)
        (Host=localhost)
        (Port= 1521)

    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (ORACLE_HOME= c:\orant)
      (SID_NAME = ORC1)

    )
    (SID_DESC =

      (SID_NAME = extproc)
      (ORACLE_HOME = c:\orant)
      (PROGRAM = extproc)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = off

----------------- eof ----------------------

Now you can run lsnrctl80 start to start the net80 listener.

2) create a tnsnames.ora file in \orant\network\admin\tnsnames.ora (note: network\admin NOT net80\admin as above). It might look like:

localhost.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )

    )
    (CONNECT_DATA = (SID = ORC1)
    )
  )

3) test with plus33 scott/tiger_at_localhost.world

It should work now. All tools that use sqlnet 2.0 or are otherwise linked with 7.x support files (such as plus33) need to use sqlnet to connect to the database.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Jan 22 1998 - 00:00:00 CST