Re: generic connectivity: ORA-12541

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 Fri Mar 08 2002 - 15:13:03 CET