Re: Newbie: Forms Installation/Configuration problem

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 22 Apr 2004 22:54:40 -0700
Message-ID: <1082699671.486442_at_yasure>


Alfie wrote:

> Could you expand, pehaps with the code? I'm sorry if I need spoon feeding
> but I'm not confident
> about what changes to make.
> I copied the database version of tnsnames.ora to overwrite the forms version
> but I still get the same 12560 error.
>
> Thanks
>
>
>
>
>
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1082645329.527167_at_yasure...
>

>>Alfie wrote:
>>
>>
>>>Hi,
>>>
>>>I can successfully build a test form - it links to the database fine, so

>
> I
>
>>>can create a single base table default form under scott/tiger.
>>>It compiles succesfully. However, when I try to run I get:
>>>
>>>TNS-12560: TNS:protocol adapter error
>>>
>>># TNSNAMES.ORA Network Configuration File:
>>>c:\Oracle\OraDS10g_home1\network\admin\tnsnames.ora
>>># Generated by Oracle configuration tools.
>>>
>>>EXTPROC_CONNECTION_DATA =
>>>  (DESCRIPTION =
>>>    (ADDRESS_LIST =
>>>      (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
>>>    )
>>>    (CONNECT_DATA =
>>>      (SID = PLSExtProc)
>>>    )
>>>  )
>>>
>>
>>Nowhere in this TNSNAMES is there a pointer to your database.
>>
>>-- 
>>Daniel Morgan
>>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
>>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
>>damorgan_at_x.washington.edu
>>(replace 'x' with a 'u' to reply)

The above TNSNAMES points to EXTPROC ... with SID PLSExtProc. That is not the connection alias or the SID for your database. So fire up the Net Configuration Assistant and fix it.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Apr 23 2004 - 07:54:40 CEST

Original text of this message