Re: How to talk to LISTENER

See below ...

Agron wrote:
> Great, thank you Jim.
>
> I did not know Oracle lets you download their products for free for
> development purposes. This is great. Actually fantastic. Documentation
> is there too!
>
> I/m downloading in B/G, I hope the installation won't ask me for some
> product key off some CD, is it?
>
> Well anyway, I'll do as you say with tnsping and network sniffer. But do
> you have to be so picky about how we call the servers?
>
> When you say sql server, every one knows that your talking about a
> server that gives you data in exchange for sql expressions. Now all
> servers, in computer terminology, serve data. Be it a file server, web
> server, ICQ server, real media server.

Wrong. The term "SQL Server" implies MS SQL Server (the product). No one thinks in such esoteric terms as "a server that gives data in exchange for sql". What about SQL statements that do not return data (i.e. DDL type statements)?

>
> And I don't agree to call only MS SQL Server a 'SQL server' (despite its
> name) and all other RDBMS by their individual product name.
> MS SQL Server is not the only SQL Server. And hence the component I am
> working on.

You may not agree on it, but no one will understand what you are talking about. Jargon, especially in this field, is an important part of communication.

>
> In the latest MS Platform SDK, MS has added an API function to find
> only MICROSOFT SQL Servers. A great idea. Something we wanted for a long
> time. But I think it is incomplete. I think it should list all sql
> servers or RDBMS that can receive SQL, not those RDBMS that receive
> specialized DBF type of commands.

How would they do this? MySQL is different than PostgreSQL is different than Ingres, etc.

--
Ron Reidy
Oracle DBA



> 

> 

> Thank you Jim

> Agron.

> 

> 

> Jim Kennedy wrote:

> 

>> Lets get the terminology correct.
>> SQLServer is a product of Microsoft Corporation.
>> ORACLE is a product of the Oracle Corporation.
>> Both products are Relational Database Management Systems -> RDBMS.
>> So both vendors would cringe at the phrase "oracle sql servers ".
>>
>> They don't serve up sql they use SQL - Structured Query Language - to
>> manipulate data.
>>
>> You could read the docs at otn.oracle.com.  Sign up, its free. And go to
>> documentation.  Or use tnsping and a network sniffer to see what it is
>> doing.
>> Jim
>>
>>
>> "Agron" <agron_ng_at_7kosova.com> wrote in message
>> news:3E9CCF76.2060702_at_7kosova.com...
>>
>>> I wrote an non-linux component to scan the local network for one of the
>>> non-oracle sql servers. What I want is to include oracle sql servers in
>>> that list too. Now I don't have an oracle server or documentation about
>>> it. So I need someone from your community to help me with the following.
>>>
>>> So far I found out that oracle sql server has an Intelligent Agent that
>>> listens to the ports 1521 and /or 1526.
>>>
>>> I need to know what do I need to send there and what response can I get.
>>>
>>> I am mostly interested to get some version and instance information.
>>>
>>> Any help is appreciated.
>>> Thank you.
>>> Agron.
>>>
>>
>>
>>


>