tnsnames.ora, listener.ora examples

Someone asked for an example of the tnsnames and listener files for a simple network. I use a derivative of the following in my tcp/ip network. Anything that needs to be modified is in lower case (with the exception of the port number if you want to change it).

Mike Marolda

• listener.ora *********************************

yourmachine_listen=(ADDRESS_LIST=

		(ADDRESS=


			(PROTOCOL=TCP)

			(HOST=xxx.xx.xxx.xx)


			(PORT=1544)


		)
	)



SID_LIST_yourmachine_listen=(SID_LIST=
        (SID_DESC=
                (SID_NAME=yoursid)
                (ORACLE_HOME =/your/oracle/home/directory)
        )

• tnsnames.ora *********************************

yourmachine=(DESCRIPTION=

             (ADDRESS=
               (COMMUNITY=just_about_anything_for_simple_networks)
               (PROTOCOL=TCP)
               (HOST=xxx.xx.xxx.xx)
               (PORT=1544)
             )
             (CONNECT_DATA=
               (SID=yoursid)
             )
           )

-- 
mmarolda_at_onramp.net
Bristol Database Resources Inc.
http://bdr.com/ - Providing Integrated Oracle and WWW Solutions