Re: Still Trouble tnsnames.ora with Developer and Oracle 8i

In article <3a242cab.19004446_at_news-server>,   gteets_at_rr.cinci.com (Greg Teets) wrote:
> 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))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (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.

1. Are you sure listener is running?
2. Check if tcp/ip works for you: ping greg.
3. I'm not sure you have correct description on client. You have ORACLE_SID=ORACLE in listener.ora, but service_name=oracle.greg on client. I think they should be the same on listener and client. Try to put ORACLE_SID=ORACLE instead of service_name
4. Check if Net8 is working: tnsping oracle.
   >
   

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 29 2000 - 19:22:15 CET