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
Got it! Thanks a lot!
(You've got to love Oracle for these little things that eat you up a whole day... :-/ )
Thank you for your time.
VG
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<994371077.19216.0.pluto.d4ee154e_at_news.demon.nl>...
> "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 Fri Jul 06 2001 - 03:19:40 CDT