Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Adding a Net8 client to a 8i client question.

Adding a Net8 client to a 8i client question.

From: Wolfe Stephen S GS-11 6 MDSS/SGSI <Stephen.Wolfe_at_macdill.af.mil>
Date: Fri, 27 Aug 2004 08:24:22 -0500
Message-ID: <9F3E28811297F44CBE71EC2C91712E1AC48B59@amcw2ms512.amc.ds.af.mil>


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



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US