Re: Error on Connect Using Developer

This will be a long day but here's the scoop go find your tnsnames.ora  assuming you have got only one version of oracle installed)... your database sid is probably listed there ... look for something that says host = localhost or host = 127.0.0.1 and then use the string at the beginning of this as your host string...
or similary fire up net8 connection and create a tnsnames entry yourself....

tnsnames.ora usually lives under $ORACLE_HOME/network/admin

"Steve Kahn" <spk_at_md.prestige.net> wrote in message news:AOMD5.3417$zx.11996_at_skycache.prestige.net...
> Thanks,
>
> I tried starting the listener process --- still get the same error. Do I
> have to type
> anything in for the Database on the connect login? In SQL*Plus I type in
>
> Username: scott
> Password: tiger
> Host String: (left blank)
>
> On Procedure Builder I type in
>
> Username: scott
> Password: tiger
> Database: (left blank)
>
> SQL*Plus works. Procedure Builder doesn't.
>
> Can you provide any other thoughts? Thanks,
>
>
> SK
>
> Dogan Cibiceli wrote in message ...
> >yep simple go fire up lsnrctl .. this kicks of a listener process so that
 u
> >can connect using forms
> >and say start
> >
> >"Steve Kahn" <spk_at_md.prestige.net> wrote in message
> >news:Xo7D5.75$zx.4637_at_skycache.prestige.net...
> >> Hi,
> >>
> >> I just installed a trial version of Oracle Developer on my PC. I
 already
> >> have the Personal Edition of Oracle Server
> >> installed and have had no problems 'connecting' through SQL*Plus (using
> >> Username: Scott, Password: Tiger).
> >> However, when I try to connect from Procedure Builder (or Forms) in the
> >> Developer Suite, I get the following
> >> message:
> >>
> >> PDE-POC011 ORA-12203: TNS: unable to connect to destination
> >> (Additional error: depoc 4)
> >>
> >>
> >> I have seen several references to this type of error in other postings
 but
> >> have yet to see a solution.
> >> Can anyone lend a helping hand?
> >>
> >>
> >>
> >> SK
> >>
> >>
> >
> >
>
>
Received on Sat Oct 07 2000 - 18:55:12 CDT