Re: Personal Oracle 8 & Developer 2000

From: Jeremy Russell <jrinusa_at_gte.net>
Date: Sat, 27 Jun 1998 12:29:27 GMT
Message-ID: <6n2ojh$qj8$1@news-1.news.gte.net>

I have the following entries in these files:

$ORACLE_HOME\network\admin\tnsnames.ora

 Beq-Net2.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (PROTOCOL = BEQ)


          (PROGRAM = oracle80)


          (ARGV0 = oracle80ORCL)


          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

and $ORACLE_HOME\NET80\admin\tnsnames.ora

 Beq-Net8.world =
  (DESCRIPTION =
    (ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

Using Oracle Net8 Easy Config, I can test the service Beq-Net8 successfully. However, running the Forms Designer, pressing Ctrl-N to display the connect dialog and entering system/manager/Beq-Net8 displays the message "ORA-12154: could not resolve service name", leading me to believe that the NET80 file is not used by D/2000 forms.

When I try to connect using the alias "Beq-Net2", I get the message "Unable to connect to destination" as mentioned by the original poster.

I cannot test this connection using the "SQL Net Easy Configuration", because I can't seem to create an entry using the Bequeath protocol - it says that this is not installed on my system - and if I modify an entry manually (by copying an entry into the "network\admin" version of the tnsnames.ora file, SQL Net Easy Config insists on reverting to an old version of the file.

Are there any further suggestions or pointers that anyone can make to help me get this to work??

TIA Jeremy Russell Received on Sat Jun 27 1998 - 07:29:27 CDT