Still Trouble tnsnames.ora with Developer and Oracle 8i

[Quoted] I still get the error "Cannot resolve service name. Please tell me what is wrong with following:

I have Oracle 8i in home D:\ora8i. I have Forms 6i in home D:\orant.

From installing Oracle 8i I have the following information:

     Global Database Name       oracle.greg
     SID                                               oracle

Following are the contents of tnsnames.ora which is in both D:\ora81\network\Admin and D:\orant\Net80\Admin.

# D:\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:D:\ora81\network\admin\tnsnames.ora # Generated by Oracle Net8 Assistant

EXTPROC_CONNECTION_DATA.CINCI.RR.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

ORACLE.GREG =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = greg)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = oracle.greg)

    )
  )

Following are the contents of listener.ora which is in d:\ora81\network\admin.
# D:\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:D:\ora81\network\admin\listener.ora # Generated by Oracle Net8 Assistant

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =


        (ADDRESS = (PROTOCOL = TCP)(HOST = greg)(PORT = 1521))
      )

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = greg)(PORT = 2481))

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\ora81)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = oracle.greg)
(ORACLE_HOME = D:\ora81)
(SID_NAME = ORACLE)

    )
  )

The idea is to get Oracle 8i and Forms to talk to each other. Since they are on the same box, I am somewhat mystified by the TCP and host info.

Please tell me how to configure this so that Forms can interface to the database.

Thanks for your help. Received on Tue Nov 28 2000 - 23:27:14 CET