Re: Problem connecting to database with Oracle Discoverer 4

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 07 Sep 2006 12:33:06 -0700
Message-ID: <1157657582.338342_at_bubbleator.drizzle.com>


zhaojk_at_gmail.com wrote:
> DA Morgan wrote:

[Quoted] >> antonyliu2002_at_yahoo.com wrote:
>>> Marino Ljubic wrote:
>>>> 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
>> and type: TNSPING MyDBName.world
>>
>> What value is set for the ORACLE_HOME and ORACLE_SID
>> environment variables?
>>
>> 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

>
> Thanks, Dan.
>
> Now here is the output. It looks like that neither ORACLE_HOME nor
> ORACLE_SID has been set.
>
> C:\oracle\product\10.1.0\MyDBServer\BIN>set ORACLE_HOME
> Environment variable ORACLE_HOME not defined
>
> C:\oracle\product\10.1.0\MyDBServer\BIN>set ORACLE_SID
> Environment variable ORACLE_SID not defined
>
> C:\oracle\product\10.1.0\MyDBServer\BIN>tnsping MyDBName
>
> TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on
> 07-SEP-2
> 006 14:14:37
>
> Copyright (c) 1997, 2003, Oracle. All rights reserved.
>
> Used parameter files:
> C:\oracle\product\10.1.0\MyDBServer\network\admin\sqlnet.ora
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = mydb_server.at.my.edu)(PORT = 1521))) (CONNECT_DATA = (SERVER =
> DEDIC
> ATED) (SERVICE_NAME = MyDBName.at.my.edu)))
> OK (30 msec)
>
> C:\oracle\product\10.1.0\MyDBServer\BIN>
>
> And here is the content of the SQLNET.ORA file on the server.
>
> # sqlnet.ora Network Configuration File:
> C:\oracle\product\10.1.0\MyDBServer\NETWORK\ADMIN\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> SQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS, NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP)
>
> SQLNET.CRYPTO_SEED = 4fhfhuweotcadswdsdfjkdsfqp5fs01p45mxswdlfdasf
>
> NAMES.PREFERRED_SERVERS =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = mydb_server.at.my.edu)(PORT =
> 7774))
> )

[Quoted] Your connection string (host in SQL*Plus) is whatever worked with TNSPING.

-- 
Puget Sound Oracle Users Group
Received on Thu Sep 07 2006 - 21:33:06 CEST

Original text of this message