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

[Quoted] 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 - 05:51:05 CET