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

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