Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Plus 3.3 vs. SQL Plus 8.0
"vg" <vgalan_at_personal.ro> wrote in message
news:54e5e6b4.0107050042.66ee694c_at_posting.google.com...
> Hello there!
>
> I have an enormous curiosity about what's soooo different about login
> procedure for SQL Plus 3.3 and SQL Plus 8.0. Maybe you could enlighten
> me...
>
> For 3.3 I enter the username and password and then the database alias
> (created from the SQL *Net Easy Configurator application). It works
> perfectly.
>
> For 8.0 I enter the SAME information and I always get 'ORA-12154:
> TNS:could not resolve service name' message error.
>
> I do not change any settings between the 2 connections and the DB is
> the same.
>
> What in the world am i doing wrong???
>
> Please help...
>
>
> Thank you for your time.
>
> VG
sqlplus 3.3 uses net 2.3
sqlplus 8.0 uses net8
the configuration files for sqlnet 2.3
are in %ORACLE_HOME%\network\admin
for net8
in %ORACLE_HOME%\net80\admin
Either you need to setup a variable TNS_ADMIN
pointing to the correct directory
in hkey\localmachine\software\oracle
(the is identical in sqlnet 2.3 and net80)
or you need to copy your sqlnet.ora and tnsnames.ora to ...\net80\admin
Hth,
Sybrand Bakker, Senior Oracle DBA Received on Thu Jul 05 2001 - 17:13:27 CDT