Re: Net8

Apart from the direcory structure, V7 tools use SQL*Net V2(.3), and 8i has Oracle Net8. And, to add to the confusion, some (default) keywords used for 8i network config do not work for V2.3...

Please post your 8i listener.ora and 7 tnsnames.ora

Arthur wrote:

> Hi,
>
> I have 8i PE installed - was using that to learn PL/SQL.
> Now I am learning forms and report and have installed Oracle
> Developer 6.0. (that is what's coming up on my start - program
> bar).
> I have got the listener running and when I test the database
> connection with Net8 Assistance - Net service name - it connects
> into as Scott / Tiger and it works.
> However, when I try to connect via Oracle for Win95 - SQL*PLUS
> and log in as Scott/Tiger .. I still get the same TNS 12154 error.
> I have tried logging in as Internal/Oracle/Orcl and also
> Intenal/Oracle/Orcl and both give me the same error.
>
> I also went thru my directories and copy the TNSNAMES.ORA from
> Oracle8i\.. to Orawin95\.. - nothing seems to change. Do I need to
> run something or rather to get it to be recognised ?
>
> My two main concern is that
> 1 : I have NO idea what the host string should be
> 2: Namesctl does not work - although the listener fires up and works,
> Namesctl doesn't. =o(
>
> Please help.
>
> Arthur
>
> >Authur,
> >
> >You said in an earlier post that you have Oracle8i PE
> >installed, now you say you are using Oracle for Windows
> >95 sql plus tool. Does that not come with personal Oracle 7 ?
> >If so you have Two Oracle products installed and thus probably
> >have two Oracle Homes and thus two Oracle directory structures.
> >You need to copy the tnsnames.ora file from C:\oracle8i\network\admin
> >to C:\orawin\net80\admin for personal oracle 7 tools to work against
> >Oracle8i.
> >
> >
> >
> >
> >> WOW - I just tested it and something else interesting happened.
> >> When I go tot oracle net service name and 'tested' the connection
> >> it WORKED!!! Which means the listener is listening on the right
> >> port and all and it logs into the database.
> >> BUT - when I tried to access the database with the listener running
> >> and log in thru Oracle for Window 95 - SQL*Plus and I put in
> >> Scott/tiger - Host as : Oracle and it comes up with
> >> TNS 12154- Can not resolve service name.
> >>
> >> I have looked into my TNSNAMES.ORA and the SID is
> >> ORCL yet it won't take it. Geeze, I am SO CLOSE - I think.
> >> Mind you, I still don't know my default service name and thus
> >> I am unable to test it with Namesctl.
> >>
> >> Hmm - help ? Anyone got any idea ???
> >>
> >
> >
Received on Fri Sep 29 2000 - 14:05:36 CDT