Listener.ora Configuration Question

From: stinky <stankonia_at_stunkitystunk.org>
Date: Thu, 25 Apr 2002 21:01:55 -0400
Message-ID: <3CC8A703.1080300@stunkitystunk.org>

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)

    )
  ) Received on Thu Apr 25 2002 - 20:01:55 CDT