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

I'm sure I tried this before but....

I just typed in oracle.greg as the SID and it worked. Thanks for your help!

Of course, now I'm so tired I have to go to bed. heh, heh

But it does feel good to get it working.

Thanks again.

On Wed, 29 Nov 2000 04:51:05 GMT, gteets_at_rr.cinci.com (Greg Teets) wrote:

>When I try to connect, Forms presents a dialog box asking for
> User - scott
> PW - Tiger
> SID - oracle. I've also tried ORACLE.
>
>Since this is all on the same box, why do i need to involve
>SQLNet or TCP or even use a domain name?
>
>I'm not a networking guy but I should be able to get this working.
>
>Thanks for your help.
>
>
>
>
>On Wed, 29 Nov 2000 00:08:33 +0100, "Sybrand Bakker"
><postbus_at_sybrandb.demon.nl> wrote:
>
>>Could you please post
>>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 - 06:33:36 CET