Adding a Net8 client to a 8i client question.

From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" <Stephen.Wolfe@xxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 27 Aug 2004 08:24:22 -0500
This may be a real green/stupid/uninformed (yes, I am all of those
things) question.

I have two 9i database applications working fine out a 8i client
configuration.  I just had to add the appropriate paragraph to the
TNSNAMES.ORA file and the applications worked fine.  One application was
a two tier app using PB as the client and the other was an Oracle Forms
app served off the oracle server itself.  Both applications connected to
different Oracle 91 servers.

I now have to add a third application, however, this third application
is a 8i database using Oracle Forms served off the owning Oracle server.
The TNSNAMES.ORA is in the ...NET80\ADMIN folder and the syntax looks a
little different from the 8i client TNSNAMES.ORS paragraphs.

This is what the Net80 stuff looks like:

# C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration
File:C:\orant\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

TPOCS.WORLD =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D tpocs-macdill)(PORT =3D =
1521))
    (CONNECT_DATA =3D (SID =3D tpocs))
  )

ABSS.WORLD =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D abss.amc.ds.af.mil)(PORT =
=3D 1521))
    (CONNECT_DATA =3D (SID =3D abss))
  )

EXTPROC_CONNECTION_DATA.WORLD =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D IPC)(Key =3D EXTPROC0))
    (CONNECT_DATA =3D (SID =3D extproc))
  )

BEQ-LOCAL.WORLD =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D BEQ)(PROGRAM =3D oracle80)(ARGV0 =3D
oracle80ORCL)(ARGS =3D
'(DESCRIPTION=3D(LOCAL=3DYES)(ADDRESS=3D(PROTOCOL=3DBEQ)))'))
    (CONNECT_DATA =3D (SID =3D ORCL))
  )

TCP-LOOPBACK.WORLD =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 127.0.0.1)(PORT =3D 1521))
    (CONNECT_DATA =3D (SID =3D ORCL))
  )


Note that the abss and tpocs client is running from this configuration.

Here is a TPOCS only configuration running under 8i for P4 clients:

# TNSNAMES.ORA Network Configuration File:
D:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP.AMC.DS.AF.MIL =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D TPOCS-MACDILL)(PORT =3D =
1521))
    )
    (CONNECT_DATA =3D
      (SERVER =3D SHARED)
      (SERVICE_NAME =3D tpocs)
      (PRESENTATION =3D http://admin)
    )
  )

TPOCS.AMC.DS.AF.MIL =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D TPOCS-MACDILL)(PORT =3D =
1521))
    )
    (CONNECT_DATA =3D
      (SERVICE_NAME =3D tpocs)
    )
  )

Here's the question, can I just change the abss.world label to
abss.amc.ds.af.mil and copy the rest of the paragraph as is and the abss
client should work (be able to find and connect to its server)?

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe@xxxxxxxxxxxxxx
(813) 827-9972  DSN 651-9972=20


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Adding a Net8 client to a 8i client question.

Other related posts:
