Re: Listener.ora Configuration Question

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Fri, 26 Apr 2002 10:20:25 +0200
Message-ID: <3CC90DC9.70700@mytoys.de>

Sybrand Bakker wrote:

> On Thu, 25 Apr 2002 21:01:55 -0400, stinky
> <stankonia_at_stunkitystunk.org> wrote:
>
>

>>I've installed Oracle (8.1.7, Linux, Enterprise Edition) on a computer 
>>at home.  If I want to access the database from work, let's say,  how 
>>should my listener.ora file be configured?
>>
>>
>>I'm hooked to the internet via a DHCP connection to an ADSL provider, if 
>>that has any bearing.
>>
>>
>>The file currently looks like this:
>>
>>LISTENER =
>> (DESCRIPTION_LIST =
>>   (DESCRIPTION =
>>     (ADDRESS_LIST =
>>       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
>>     )
>>     (ADDRESS_LIST =
>>       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
>>     )
>>   )
>> )
>>
>>SID_LIST_LISTENER =
>> (SID_LIST =
>>   (SID_DESC =
>>     (SID_NAME = PLSExtProc)
>>     (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
>>     (PROGRAM = extproc)
>>   )
>>   (SID_DESC =
>>     (GLOBAL_DBNAME = stinky.world)
>>     (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
>>     (SID_NAME = stinky817)
>>   )
>> )
>>

>
>
> Without changing the DHCP IP address in a fixed IP address it is
> probably not going to work at all, because the DHCP address will
> expire, and sqlnet translate the DNS-address in an IP address only
> once, when connecting.
> Evidently you also need to change host=localhost (which is the local
> loopback address 127.0.0.1) into something real, and have that in your
> work hosts file.
> Overall, I don't think it is going to work, and should be advised
> against. From the perspective of your firm it would definitely scare
> the wits out me when I know work is being executed on a outside system
> at someone's home, over which I can exercise no control at all.
> I would immediately stop you doing it when I discover you are doing
> so.

Besides all the important remarks, if you really want to do it, you could register your server at dyndns.org or something similar to have a fixed IP address.

Regards,

Knut Received on Fri Apr 26 2002 - 03:20:25 CDT