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: generic connectivity: ORA-12541

Re: generic connectivity: ORA-12541

From: kkrause <kkrause.nospam_at_homesourcecapital.com>
Date: Thu, 7 Mar 2002 17:51:43 -0500
Message-ID: <L0Sh8.15741$Yd.602905@e3500-atl1.usenetserver.com>


just a quick sanity check...have you stopped & re-started the listener?

"robert malikian" <robertmalikian_at_hotmail.com> wrote in message news:3c87d228_at_news1.homechoice.co.uk...
> Start=>run=>cmd
> now do a "lsnrctl status" if doesn't look good then do a "lsnrct start".
In
> addition to this check the services see if it is running.
> Robert
> "Srinivas" <pabbathi_at_yahoo.com> wrote in message
> news:ee91da38.0203070803.4ae1f5dd_at_posting.google.com...
> > Oracle Gurus,
> >
> > I am having trouble connecting to a SQL Server 2000 database from
> > Oracle 8.1.7 (on Windows 2000) using generic connectivity.
> >
> > These are my configurations on the 8.1.7 server -
> >
> > tnsnames.ora
> >
> > Entry1 = (Description =
> > (address = (protocol=tcp)(host=entry1)(port=1521))
> > (connect_data=(sid=Entry1))(HS=ok)
> > )
> >
> >
> > listener.ora
> >
> > sid_list_listener=
> > (sid_list =
> > (sid_desc =
> > (program=hsodbc)
> > (sid_name=entry1)
> > (oracle_home=f:\oracle\ora81)
> > )
> >
> > initentry1.ora in $oracle_home\hs\admin\
> >
> > hs_fds_connect_info = entry1
> > hs_fds_trace_level = OFF
> > hs_fds_trace_file_name = NONE
> >
> > I have a DSN called Entry1 pointing to the SQL Server 2000 that I want
> > to connect to.
> >
> > When I "TNSPING ENTRY1"
> >
> > I get the error - TNS-12541: TNS:no listener
> >
> > What did I do wrong to cause this error?
> >
> > srinivas
>
>
Received on Thu Mar 07 2002 - 16:51:43 CST

Original text of this message

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