Re: SQLnet - Setting up TNSNAMES and LISTENER

From: QuestionExchange <USENET_at_questionexchange.com>
Date: 13 Dec 1999 15:54:50 GMT
Message-ID: <3021qx@questionexchange.com>

yes and no and really it depends. HOST is the string you can use to ping the box. so if from the machine the listener is on ping host6.world actually works then ok. Generally this is just the node name of the box so I'd expect it to be just host6. Same issue for the tnsnames.
>
> --------------3AAFAF3B956F06A166C54E03
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> I want to set up SQLnet 2.0 so that TCP/IP is used.
Currently, DECnet
> is used as the transport.
>
> Are the changes made to the TNSNAMES and LISTENER files
(defined below )
> correct so that
> TCP/IP is used instead of DECnet ?
>
> The configurations for the Server and Client are as follows.
>
> Server:
>
> AS8400 (Nodname = HOST6)
> Oracle 7.1 Database (DB name = DB1)
> OpenVMS 6.2
> Oracle Listener
>
> ################
> # Filename......: listener.ora
> # Name..........: host6.world
> # Date..........:
> ################
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY= HOST6_DB1.WORLD)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY= DB1)
> )
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = HOST6.WORLD)
> (PORT = 1521)
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = OFF
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = DB1)
> (PROGRAM = orasrv_net2.com)
> (TIMEOUT = 0)
> )
> )
>
>
> Client:
>
> VAX7610
> Oracle 7.1
> OpenVMS 6.2
>
>
> ################
> # Filename......: tnsnames.ora
> # Name..........: nodename.world
> # Date..........:
> ################
> HOST6_db1.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = world)
> (PROTOCOL = TCP)
> (Host = HOST6)
> (Port = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = DB1)
> )
> )
>
>
>
>
> --------------3AAFAF3B956F06A166C54E03
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <!doctype html public "-//w3c//dtd html 4.0
transitional//en">
> <html>
> I want to set up
SQLnet 2.0
> so that TCP/IP is used. Currently, DECnet is used as the
transport.
> Are the changes
made to the
> TNSNAMES and LISTENER files (defined below ) correct so
that
> TCP/IP is used
instead of
> DECnet ?<font
size=-1>
> The
configurations for the
> Server and Client are as follows.<font
face="Arial,Helvetica">
> Server:
> AS8400
(Nodname = HOST6)
> Oracle 7.1
Database (DB
> name = DB1)
> OpenVMS
6.2
> Oracle
Listener
> <font size=-

1>################</font></font>


> <br><font face="Arial,Helvetica"><font size=-1>#

Filename......: listener.ora
> #
Name..........: host6.world
> #
Date..........:
> <font size=-

1>################</font></font>

> LISTENER
=
> 
(ADDRESS_LIST =
> 
> (ADDRESS=
> 
> (PROTOCOL=IPC)
> 
> (KEY= HOST6_DB1.WORLD)
> 
> )
> 
> (ADDRESS=
> 
> (PROTOCOL=IPC)
> 
> (KEY= DB1)
> 
> )
> 
> (ADDRESS =
> 
> (PROTOCOL = TCP)
> 
> (HOST = HOST6.WORLD)
> 
> (PORT = 1521)
> 
> )
> 
)
> STARTUP_WAIT_TIME_LISTENER
> = 0
> CONNECT_TIMEOUT_LISTENER
> = 10
> <font size=-

1>TRACE_LEVEL_LISTENER = OFF</font></font>


> <br><font face="Arial,Helvetica"><font size=-


1>SID_LIST_LISTENER =</font></font>

> (SID_LIST
=
> (SID_DESC
> =
> 
> (SID_NAME = DB1)
> 
> (PROGRAM = orasrv_net2.com)
> 
> (TIMEOUT = 0)
> 
)
> 
)
> <font size=-

1></font></font> <font face="Arial,Helvetica"><font size=-
1></font></font>

> Client:
> VAX7610
> Oracle
7.1
> OpenVMS
6.2
> <font size=-

1></font></font> <font face="Arial,Helvetica"><font size=-
1></font></font>

> <font size=-

1>################</font></font>


> <br><font face="Arial,Helvetica"><font size=-1>#

Filename......: tnsnames.ora
> #
Name..........: nodename.world
> #
Date..........:
> <font size=-

1>################</font></font>

> HOST6_db1.world =
> (DESCRIPTION
=
> 
(ADDRESS_LIST
> =
> 
> (ADDRESS =
> 
> (COMMUNITY = world)
> 
> (PROTOCOL = TCP)
> 
> (Host = HOST6)
> 
> (Port = 1521)
> 
> )
> 
)
> 
(CONNECT_DATA
> =
> 
> (SID = DB1)
> 
)
> 
)
> <font size=-

1></font></font> 


> <br><font face="Arial,Helvetica"><font size=-


1></font></font>

> </html>
>
> --------------3AAFAF3B956F06A166C54E03--
>
>
>

--
This answer is courtesy of QuestionExchange.com http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=8664&cus_id=USENET&qtn_id=7976 Received on Mon Dec 13 1999 - 09:54:50 CST