stopping the listener..what effect would it have?
BugsJun 22 2006 — edited Jun 26 2006Hi,
Please find my listener.ora below:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XYZ)(PORT = abcd))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME =hsmsql1)
(ORACLE_HOME = c:\Oracle\ora92)
(PROGRAM = hsodbc)
)
)
SID-hsmsql1 is the one for heterogenous servicing for an MS access database.
I've created a dabase link which points to the MS access database and I'm executing my queries on the MS access table on an SQLplus session.
Now,If I configure the listener.ora for another MS access database,and If I restart the listener,Would I be able to do the transactions in the existing SQLplus session when the listener is stopped?ie, I would like to know if stopping the listener would've any effect in my SQLplus session.(Would I be able to access the existing MS access tables if the listener is stopped?).
Thanks,
Sheeba Benita.