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

Same problem here with Oracle 8 Server on a laptop . Not being a newbie, a quick investigation made , resolved the problem. Developer 2.1 doesn't seem to use net8, it uses sqlnet 2.3. The advice of copying tnsnames.ora is correct.
However you need the following entry added oracle.world =
(address = (host = 127.0.0.1) (port=1521) (sid=ORCL))

If you have set up your hosts file correctly localhost instead of the hardcoded IP should also work.
For future requests please submit the exact error message. Other people are willing to help you, but usually can't reproduce your problem.

Hth,

Sybrand Bakker, Oracle DBA

N. Steffens <nsteffens_at_advantage.nl> wrote in message news:7p6iup$6qj$1_at_buty.wanadoo.nl...
> 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 Sun Aug 15 1999 - 10:28:14 CDT