Re: Configurations on Unix to connect from NT?

From: Kannan Padmanabhan <kpadmana_at_erols.com>
Date: 1997/12/09
Message-ID: <348dcc69.19155951@news.erols.com>#1/1

On Mon, 8 Dec 1997 16:27:47 +0100, "Rene Hauck" <rene.hauck_at_hmi.ch> wrote:
db1.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS=
          (PROTOCOL= IPC)
          (KEY= db1)
        )

    )
(CONNECT_DATA =

	 (SID = DB1)
	( GLOBAL_NAME = db1.world)    => 

 )
)

What does this mean exactly?

=> you were unable to establish a network connection from your nt-client to the unix server. On the nt-client $ORACLE_HOME/network/admin, you should have sqlnet.ora, tnsnames.ora. If you don't have one copy these files from the $ORACLE_HOME/network/sample directory or from the server.

How can I solve all these problems?

=> use the ping utility / try to map a drive from the NT-Client. Install the TCP/SPX Drivers from the installation CD.

How have these files have to look exactly? =>Watch for the paranthesis. Each open paran should close. otherwise you will get tns errors.

Hope this helps.
Good Luck,

Kannan.

>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