Re: Problem connecting to database with Oracle Discoverer 4

DA Morgan wrote:
> zhaojk_at_gmail.com wrote:
> > DA Morgan wrote:
> >> 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))
> > )

>

I just tried, it did not work.

I tried both mydb_server.at.my.edu and MyDBName.at.my.edu as the connection string respectively. Neither worked. Received on Thu Sep 07 2006 - 21:41:11 CEST