Re: Net8

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 - 00:35:37 CDT