manually editing listener.ora
The company I work for has recently purchased a "turn-key solution" that uses Oracle8 as its db. It came preconfigured and partially broken (no functioning sqlplus, netasst, perl), most likely to keep us out of it. I need to connect to the db to sync it with our existing mysql db. I have managed to connect to the db with a simple java program. The problem is, it only listens on localhost and I want the scripts to reside on a different server. I need to be able to make it listen on its public IP. I am assuming I need to change the listener.ora file and possibly tnsnames.ora as well, however if anyone has any better ideas, I would love to hear them. Here is my current listener.ora file. It seems like it would be relatively simple, but I have tried numerous changes but nothing seems to work.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 2481))
)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle1/product/8.1.7)
(PROGRAM = extproc)
)
( SID_DESC=
(GLOBAL_DBNAME = THISDB)
(ORACLE_HOME = /home/oracle1/product/8.1.7)
(SID_NAME = THISDB)
)
)
Thanks in advance.
