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

Home -> Community -> Usenet -> c.d.o.misc -> Re: error 12541 - strange error on TNS: no listener

Re: error 12541 - strange error on TNS: no listener

From: Luciano Belotto <luciano_at_nospam.com>
Date: 17 Jun 2002 20:38:24 GMT
Message-ID: <aelhc0$bbr@dispatch.concentric.net>


sorry forgot to mention. I'm on Oracle 9i client, servers are both 9i and 8.0.5. Platform is only Win NT 4 and Win 2000.

--
Luciano Belotto
replace spam with traxsoftware for e-mail

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3D0E3911.2F5E261D_at_exesolutions.com...

> Luciano Belotto wrote:
>
> > been getting a strange error here,
> >
> > I have my Tnsnames.ora file all setup, and I can connect to all the
> > databases on my server fine using SQL Plus, Enterprise Manager, SQL Plus
> > Worksheet and by "testing" the connection inside of Net Manager.
However,
> > once i try doing an import or export (using exp/imp commands) I get a
> > EXP-00056: ORACLE error 12541 encountered
> > ORA-12541: TNS:no listener
> > EXP-00000: Export terminated unsuccessfully
> >
> > It even gets stranger.. Using an application developed in
Powerbuilder....
> > When running off of source code, it can connect to the database fine.
> > However, if I compile the code into exe and run off of there, i get the
No
> > Listener error. They both connect using the Oracle native driver and
read
> > how to connect off of the same ini file.
> >
> > No-one else in my office has this problem. What could be wrong with my
> > setup? Any help appreciated
> >
> > --
> > Luciano Belotto
> > replace spam with traxsoftware for e-mail
>
> My suspicion is that you are on UNIX platform and that the .profiles are
> different. The one you are using for EXP does not have oracle_sid, etc.
>
> Daniel Morgan
>
Received on Mon Jun 17 2002 - 15:38:24 CDT

Original text of this message

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