Re: Configurations on Unix to connect from NT?

From: Jean-Sébastien CHILLET <Jean-Sebastien.Chillet.LMI_at_renault.fr>
Date: 1997/12/09
Message-ID: <66k18b$rif@kitten.pdj.renault.fr>#1/1

Hi Rene,

   try this in your listener.ora :
LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL= IPC)

          (KEY= DB1)

        )
        (ADDRESS=


          (COMMUNITY= TCP.world)

          (Host = your_host_name_or_host_IP)

          (PROTOCOL= TCP)

          (Port= 1521)

        )

  )
  and in your NT client tnsnames.ora :
DB1.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = your_host_name_or_host_IP)

          (Port = 1521)

        )

    )
    (CONNECT_DATA = (SID = DB1)
    )
  )
N.B : "your_host_name_or_host_IP" means that you MUST fill in those places with your host (server) name or host IP address. Also note that DB1.world is an alias, it's an external name that you will use to connect to DB1 DB : remember the "host string" field in the connection panel of SQL*Plus ? Fill it with that alias you specified.   The error you get says that as you didn't specify any transport protocol (IPC is an Oracle internal one), SQL*Net couldn't resolve the connection with the poor information you gave it to reach your DB.   As shown above, you must specify on either sides that you're willing to use TCP/IP.
  On your client side you must have been provided with some applications amongst which you should find "SQL*Net easy configuration" : it can guide you through some steps to provide full tnsnames.ora configuration (i.e: it will make the file for you! How great!).   Anyway, have a look at Oracle's documentation, you surely would make profit of it.

Regards.

Rene Hauck a écrit dans le message <66h3i0$fqq$1_at_news.eunet.ch>...

>How do I have to configure the file listener.ora on an unix-server, so that
>I can connect to the database on this unix-server from a nt-client?
>And how does the file tnsnames.ora on the nt-client have to look like to
>connect to this database on the unix-server?
>
>Thank you very much for helping me!
>
>Rene Hauck, hmi, Switzerland
>
>
>PS:
>
>I can start the listener only with an adress_list of listener.ora on the
>unix-server like the following:
>
>  (ADDRESS_LIST =
>        (ADDRESS=
>          (PROTOCOL= IPC)
>          (KEY= db1)
>        )
>
>I receive the error TNS-12560 TNS: protocol adapter error, when I configure
>the file tnsnames.ora like that:
>
>db1.world =
>  (DESCRIPTION =
>    (ADDRESS_LIST =
>        (ADDRESS=
>          (PROTOCOL= IPC)
>          (KEY= db1)
>        )
>    )
>    (CONNECT_DATA = (SID = DB1)
>    )
>  )
>
>What does this mean exactly?
>How can I solve all these problems?
>How have these files have to look exactly?
>
>

Received on Tue Dec 09 1997 - 00:00:00 CST