Re: Personal oracle 8 and developer 2000

First of all, Developer will look at the tnsnames.ora file in $ORACLE_HOME/network/admin, and NOT $ORACLE_HOME/net80/admin. So make sure you've added the name to the right place.

Second, I'm pretty sure you've got to use a tcp connection in tnsnames, and the host is localhost, or 127.0.0.1.

(These are from memory, but I'm probably close....)

Last, you've got to start the listener for the database (lsnrctl80 start), and fiddle some with the settings in listener.ora.

Hope this helps,

Yosi Greenfield

Phoebe Ho Wing Sze wrote:

> Dear all,
>
> i have downloaded and installed the personal oracle 8 and
> developer 2000 from www.oracle.com. Personal oracle 8 works properly.
> HOwever, when i use developer 2000 to connect to the datbase, it gives
> error : ORA12154: TNS: counld not resvolve the servive name
> I added the alias of the service name of the database. ANd I connect to
> the databse by:
> user name: system
> password : manager
> database : temp
> Can any one tell me what is the problem ?????
> Thank you very much.
Received on Fri Jul 30 1999 - 17:55:07 CEST