Re: oracle on an stand-alone pc

From: Hans Forbrich <hforbric_at_yahoo.net>
Date: Sat, 13 Mar 2004 22:25:41 GMT
Message-ID: <FTL4c.166256$A12.18679@edtnps84>

Daniel Morgan wrote:
> Hans Forbrich wrote:
>

>> So you DO have TCP/IP.  And you have a physical adapter.

>
>
> Just the card that connects me to my DSL modem to the internet.

That's enough to ensure the TCP/IP stack is available. If then you have a fixed IP address (instead of DHCP) you can safely assume that TCP/IP is part of your configuration at all times.

>

>> This thread-fibre started by you challenging my statement about 
>> loopback adapter.  Your challenge:  "Why? Of what value is the 
>> loopback? What is it going to teach someone they can't learn on a 
>> stand-alone?"

>
>
> Maybe it is semantics but I'm was not aware that a PCMCIA card connected
> to a DSL modem was a loopback.
>

It's not.

The Loopback Adapter is a pure software construct that allows TCP/IP connectivity inside of a machine without any physical device (such as PCMCIA/PCI/ISA network card). Setting up the Loopback Adapter became almost second nature for NT machines in corporate environments that discouraged static IP addresses. (eg: Oracle <g>)

>> Thus, I stand behind my statement "you should have at least the 
>> 'loopback' network subsystem in place".

>
>
> I'm not sure that anything is required. The fact that my machine has
> the ability to connect to the web seems to me to be a part of having
> a browser and using it but I'm not convinced it is necessary. Perhaps
> it is but I haven't found that in anything I've read.

The fact that you are getting to the web means you have TCP/IP.

Try going into your control panel > "network and dial-up connections" and open the active connection. You will note that the "Internet Protocol (TCP/IP)" is installed. (Uninstall the Internet Protocol and see what impact it has <g>)

> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch3.htm#1006381
>
>
> Nowhere can I find reference to loopback or TCP/IP.

You are right - I just spent some time looking through Oracle's documentation. Although a lot of documentation implies the TCP connectivity requirement (by specifying the TCP port number), there is no explicit statement requiring TCP.

OTOH, Apache's documentation for version 1.3 (http://httpd.apache.com) states that the TCP/IP stack IS required.

I wonder whether Oracle now assumes everyone has TCP/IP or whether they've modified Apache so much that it's not required.

>
> Either way ... if the OP could post to a usenet group ... the OP has
> whatever I have and nothing more should be required.
>

Not necesarily true. You assume that the OP is communicating with us using the same machine as to be used for testing/learning.

A standalone machine is not connected to a network, possibly because there is no network card. (By your admission, your machine is not standalone - it is connected to the web.)

My Windows 2000 laptop has built-in ethernet connectivity. The TCP/IP stack is not loaded if there is no cable plugged in to the network port

   AND I want to use DHCP to provide the address. I ended up switching to static IP address for other reasons and now the TCP/IP subsystem stays loaded.

All the above is causing a big hmmmmm. And, except for confirming whether Oracle assumes the existance of TCP/IP, is not likely worth pursuing.

/Hans Received on Sat Mar 13 2004 - 16:25:41 CST