Re: Problem connecting to database with Oracle Discoverer 4

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 07 Sep 2006 09:54:24 -0700
Message-ID: <1157648060.687394_at_bubbleator.drizzle.com>


antonyliu2002_at_yahoo.com wrote:
> Marino Ljubic wrote:

[Quoted] [Quoted] >> antonyliu2002_at_yahoo.com wrote:
>>
>>> Yes, I know that you were talking about the file tnsnames.ora, and that
>>> is exactly the file I modified.
>>>
>>> When I mentioned the ODBC connection string, I was talking about the
>>> connection string we use in the connect dialog box as shown in the
>>> picture below:
>>>
>>> http://static.flickr.com/76/228299512_75fca56471_o.gif
>>>
>>> I am not sure if that connection string looks right.  I do use that
>>> connectiong string to connect to the same database in my web
>>> application (in VB or C#).
>>>
>>> You know what I was talking about now?
>>>
>>> Thanks again.
>>
>> In the "Connect" field type only the name of the alias you created in
>> tnsnames.ora, which is MyDBName in your example. The same thing with
>> any other client using Oracle NetClient for connection.

>
> OK, great, that answers my question. But I am still getting the same
> error:
>
> Unable to connect to:myuserid_at_mydb_server.at.my.edu
> Failed to connect to database - ORA-12514: Message 12514 not found;
> product=RDBMS80;facility=ORA
>
> And this is my TNSNAMES.ORA
>
> MyDBName.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)(HOST = mydb_server.at.my.edu)(PORT = 1521)
> )
> )
> (CONNECT_DATA = (SERVICE_NAME = MyDBName)
> )
> )
> extproc_connection_data.world =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = IPC)
> (KEY = EXTPROC0)
> )
> (CONNECT_DATA =
> (SID = PLSExtproc)
> (PRESENTATION = RO)
> )
> )
>
> Any idea about where I am wrong? Thanks.

Please open a command prompt
Go to $ORACLE_HOME/bin
[Quoted] and type: TNSPING MyDBName.world

[Quoted] [Quoted] What value is set for the ORACLE_HOME and ORACLE_SID environment variables?

[Quoted] [Quoted] Personally I'd remove .world from my TNSNAMES and I wonder what is in your SQLNET.ORA file.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Thu Sep 07 2006 - 18:54:24 CEST

Original text of this message