Re: How To Get Developer 6.0 And Oracle DB To Talk To Each Other ORA-12514 ??

Could you please post
[Quoted] the *exact* connect string you are using. The contents of your sqlnet.ora.
By virtue of the use of 'oracle.greg' your database domain now is 'greg', which you might not use when connecting.

Hth,

Sybrand Bakker, Oracle DBA

"Greg Teets" <gteets_at_rr.cinci.com> wrote in message news:3a243275.20486477_at_news-server...
> 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.
>
>
> On Tue, 12 Sep 2000 18:23:11 +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
> >
> >
> >Greg Teets <gteets_at_rr.cinci.com> schreef in berichtnieuws
> >39be4321.25826616_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.
> >>
> >> 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.
> >
> >
>
Received on Wed Nov 29 2000 - 00:08:33 CET