Re: Listener.ora Configuration Question

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.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Apr 26 2002 - 00:06:04 CDT