Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Adding a Net8 client to a 8i client question.
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_at_macdill.af.mil
(813) 827-9972 DSN 651-9972=20
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Aug 27 2004 - 08:54:46 CDT
![]() |
![]() |