Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with Listener

Re: Help with Listener

From: Fred A G <nospam_at_allowed.localhost>
Date: Sat, 17 Feb 2001 19:30:09 +0100
Message-ID: <Ypzj6.2554$hi2.7065@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 - 12:30:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US