Re: Problem connecting to database with Oracle Discoverer 4

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.

>

>

>

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))
  ) Received on Thu Sep 07 2006 - 21:24:06 CEST