Re: tnsnames.ora

Eric Fang wrote:
>
> I have a wierd problem to access the database today.
> If I use the following
> sqlplusw system/manager_at_orcl.world, it is ok to
> connect to the database. But if I use
> sqlplusw system/manager_at_orcl
> I have the ORA-12154: TNS:could not resolve service
> name error.

Hello,

This is because your default names domain is set in $ORACLE_HOME/network/admin/sqlnet.ora.

Cheers,

g

-- 
guy ruth hammond <grh_at_agency.com> | Happiness is a loaded weapon, and
Technology / Synergy / Consulting |   a short cut is better by far.
07879607148 http://www.agency.com |     -- The Sisters of Mercy