Re: Help with Listener

After you follow Fred's suggestions, see if you have multiple tnsnames.ora files on your machine and if they are all configured.

Van

"Fred A G" <nospam_at_allowed.localhost> wrote in message news:Ypzj6.2554$hi2.7065_at_nntpserver.swip.net...
>
> "Arthur" <mechhunter_at_rocketmail.com> wrote in message
> news:3a8eb07b.1499522_at_news.iinet.net.au...
> > Hi,
> >
> > I am running Oracle developer 6.0 on a win98 platform. I am
> > trying to connect Form Builder onto a Database that is running on the
> > same machine - a local database. I have gotten this to work before
> > with Listener and such from the help of this NG. However, I took a
> > break from form and report learning and did a few weeks of SQL.
> >
> > Now, I am trying to get back into form and it does not work
> > anymore. I have check the TNSNAMES.ORA, LISTENER.ORA, SQLNET.ORA and
> > NAME.ORA and they are identitical on both the D:\ORAWIN95\NET80\ADMIN
> > and the D:\Oracle\Ora81\NETWORK\ADMIN.
> >
> > When I try to connect via Form builder, it is coming up with
> > this error: ORA-12154: TNS:could not resolve service name
> >
>
> What service name do you use to connect? (Notice that your sqlnet.ora
> has default domain name 'Oracle8' not 'Oracle'.)
>
> Have you tried without using the Names server?
>
> >
> > (if I am on the internet)
> > When I test the connection via Net8 Assistance Connection
> > Test, I get this error: ORA-12541:TNS:no listener
> >
>
> Sounds like a IP routing problem.
>
> Regards
> /Fad
>
>
Received on Sat Feb 17 2001 - 16:00:15 CST