Re: Oracle DBA's should know this problem... HELP!!!!!!!!

We had similar problems when we tried to use Developer/2000 with Oracle 8.x.

For some reason (known to Oracle only) Developer/2000 uses sqlnet 2.3 where as Oracle
8.x uses Net8 as the standard mechanism to connect to database.

Resolve this as follows.

1. copy "TNSNAMES.ORA" file to orawin95\network\admin\ directory.
2. Configure listener process of Net 8 by specifying the configuration information in orawin95\net8\admin\listener.ora file.
3. Start listener program by executing tnslsnr80.

Now you should be able to connect to the Database if your tnsnames.ora file specifies
the correct connect-string, protocol, and Database SID.

"N. Steffens" wrote:

> I sure hope someone can help me (and some
> others for I have seen that more (newbe's) have the same problem.
>
> I have: Personal Oracle 8 & Developer 2.1 installed.... It all installs
> great without any problem.
>
> PLSQL works great with standard SCOTT/TIGER uid.
> But when I tried to start up Forms builder it just doesn't connect to my
> standard Oracle DB.
>
> I have copied my TNSNAMES from orawin95\net80\admin to
> orawin95\network\admin (at advice from someone) but that still doesn't help.
>
> I tried TNSPING to BEQ-LOCAL but it also gives an error while TNSPING80
> BEQ-LOCAL works great.
>
> Can U please help me?
> I've tried it on both WIN 98 and WIN 95..
>
> thanks in advance,
>
> Niels Steffens.
Received on Mon Aug 16 1999 - 14:12:26 CDT