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>
>
> 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.
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 GroupReceived on Thu Sep 07 2006 - 18:54:24 CEST