Re: How To Get Developer 6.0 And Oracle DB To Talk To Each Other

[Quoted] I am confused. This is all on the same desktop machine. Do I need the listener to use Developer and Oracle on the SAME machine?

Or what do i use as the machine name?

On Wed, 13 Sep 2000 10:24:33 +0200, "Martin Vonk" <m.w.vonk_at_chello.nl> wrote:

>Hi,3) A TNSNAMES entry needs to be created in the tnsnames.ora file for the
>new
>Oracle 8i installation. You can find the file in:
>d:\orant\net80\admin\tnsnames.ora
>A default entry will look like this:
>alias.world
>(DESCRIPTION
>(ADDRESS_LIST
>(ADDRESS
>(PROTOCOL = TCP)
>(Host = )
>(Port = )
>)
>)
>(CONNECT_DATA = (SID = )
>)
>)
>For example, if you installed on a machine with a HOSTNAME of TEST, a SID
>named ORA8I, on TCP/IP with port 1521, and an alias of NEW, you would create
>the following entry:
>NEW.world
>(DESCRIPTION
>(ADDRESS_LIST
>(ADDRESS
>(PROTOCOL = TCP)
>(Host = TEST)
>(Port = 1521)
>)
>)
>(CONNECT_DATA = (SID = ORA8I)
>)
>)
>
>4) If you manually created the entry, save and close the tnsnames.ora file.
>You can now connect to the local database instance of 8i using the DBSTRING
>as NEW. For example, you can connect as scott/tiger_at_NEW.
>
>HTH
>
>Martin
>
>
>
>
>Spammy Nono <spambust_at_localhost.zz> schreef in berichtnieuws
>PCxv5.8635$Fl2.70904_at_nntpserver.swip.net...
>> "Greg Teets" <gteets_at_rr.cinci.com> wrote in message
>> news:39be31f0.21424186_at_news-server...
>> > I have finally gotten Oracle Developer 6.0 successfully installed on
>> > my machine. In order to accomplish this, The database is in home
>> > ORA81 and Developer is in home Orant. The two cannot talk to each
>> > other now.
>> >
>> > When I try to connect from Oracle Forms, I get the following message:
>> > ORA-12514 TNS could not resolve service name.
>> >
>>
>> Double-check the service name definition in the Orant home
>> (should be in .../net80/admin/tnsnames.ora). I assume Developer 6.0
>> includes net80 software.
>>
>> If you haven't already, read the net8 docs about networking in
>> the realm of Oracle . But, for short, a "service name" , or TNS connect
>> string alias, says how to contact the remote db listener. A db listener
>> listens for connections on behalf of services (like instances) and is
>> configured via the listener.ora file.
>>
>> > Please tell me how to fix this in as much detail as possible. I am
>> > using Windows NT 4.0 workstation. The installer required Oracle and
>> > Developer to be in different home.
>> >
>> > Thanks in advance.
>>
>> Thos darn Installers... ;-)
>>
>> Hope that helps,
>> /Fad
>>
>>
>
>
Received on Wed Sep 13 2000 - 16:03:49 CEST