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

Re: generic connectivity: ORA-12541

From: Andre van Winssen \(andrew\) <andrew-no-spam-svp_at_info.nl>
Date: Tue, 12 Mar 2002 09:24:17 +0100
Message-ID: <3c8dbb31$0$7479$4d4ebb8e@news.nl.uu.net>


Srinivas,

note the following 2:

tns listener is running, not the sqlserver database

The only thing that should point to sqlserver is the ODBC DSN "entry1" in

the line hs_fds_connect_info = entry1 in %oracle_home%\hs\admin\initentry1.ora

The rest of the sqlnet setup has to do with getting hsodbc to use this entry.

CREATE DATABASE LINK entry1

CONNECT TO sa IDENTIFIED BY <password> USING

'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<your TNS listener host>)

(PORT=1521))(CONNECT_DATA=(SID=entry1))(HS=))'

/

This will work if "lsnrctl services" shows that the TNS listener knows about the "entry1" service.

If it fails send me a mail directly, maybe we can debug this further.

I've used it a hundred times succesfully.

Best regards,

Andre van Winssen

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:a6b4gf$b3k$1_at_lust.ihug.co.nz...
> I'm not sure it will help, but on my site, under Tips, Administration,
> Advanced Stuff, there's a paper on setting up a database link. You may
find
> it of some use in determining precisely what is going wrong in your
specific
> case.
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Srinivas" <pabbathi_at_yahoo.com> wrote in message
> news:ee91da38.0203080613.1cde8ef2_at_posting.google.com...
> > Ok...now the "TNSping Entry1 " says OK.
> >
> > Then, I created database link as -
> >
> > create database link entry1 connect to sa identified by password using
> > 'entry1'
> >
> > Note that the 'entry1' matches with the tnsnames.
> > sid in tnsnames matches with listener sid which matches with
> > init'sid'.ora file name in oracle_home\hs\admin.
> > initentry1.ora has entry for dsn called entry1 which has default
> > database as DBName
> >
> > But, when I query - select * from tablename_at_Entry1
> >
> > or
> >
> > select * from tablename_at_Entry1.dbname
> >
> > I get the error 12514 "TNS could not resolve service name in the
> > connect descriptor"
> >
> > Where is the error? I am baffled.
> >
> > srinivas
> >
> > "kkrause" <kkrause.nospam_at_homesourcecapital.com> wrote in message
> news:<L0Sh8.15741$Yd.602905_at_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 Tue Mar 12 2002 - 02:24:17 CST

Original text of this message

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