Re: TNSNAMES.ORA

I had a similar problem. It was because I was using the wrong TNSNAMES.ORA. I'm on Windows NT, but my Oracle 8i TNSNAMES.ORA was in the Ora81\network\admin directory, but Webdb was looking in webdb\net80\admin.

Basically, I did a copy/paste into webdb\net80\admin. (Maybe I actually had to create the file too.)

Ould wrote:

> Hi all,
>
> I find the following message when running in my
> browser
> http://quasar.quasar.darea.fr:8080/webdb and
> giving my
> username/password as WEBDB/WEBDB :
>
> "TNS could not resolve service name
> Verify that the TNS name in the connectstring
> entry of the DAD for this
> URL is valid."
>
> In The following my tnsnames.ora and listener.ora
> I after installation
> of WEbDB::
>
> **************************************************
> # Filename: Tnsnames.ora
>
> extproc_connection_data =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY =
> <oracle_sid>))
> (CONNECT_DATA = (SID = extproc))
> )
>
> <oracle_sid> =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host=
> quasar.darea.fr)(Port= 1521))
> (CONNECT_DATA = (SID = <oracle_sid>))
> )
>
> <oracle_sid>_BEQ =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = BEQ)(PROGRAM =
> /u01/app/oracle/product/8.0.5)
> (argv0 = oracle<oracle_sid>)
> (args = '(DESCRIPTION =
> (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
> (envs =
> 'ORACLE_HOME=/u01/app/oracle/product/8.0.5,ORACLE_SID=<oracle_sid>')
> )
> )
> **************************************************
> # Filename: Listener.ora
>
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS= (PROTOCOL= IPC)(KEY=
> <oracle_sid>))
> (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
> (ADDRESS= (PROTOCOL= TCP)(Host=
> quasar.darea.fr)(Port= 1521))
> )
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME= quasar.darea.fr.)
> (ORACLE_HOME= /u01/app/oracle/product/8.0.5)
> (SID_NAME = <oracle_sid>)
> )
> (SID_DESC =
> (SID_NAME = extproc)
> (ORACLE_HOME =
> /u01/app/oracle/product/8.0.5)
> (PROGRAM = extproc)
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = OFF
> *************************************************
>
> Is somebody can help on what I must replace in these
> files ?
> Any other help on other files which must be
> changed eventually should be appreciated.
>
> Thanks
>
> Mohamed
>
> ouldmoh_at_yahoo.com
Received on Mon Oct 11 1999 - 17:18:34 CEST