Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

stopping the listener..what effect would it have?

BugsJun 22 2006 — edited Jun 26 2006
Hi,
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2006
Added on Jun 22 2006
9 comments
4,064 views