Database links remain open until the client session closes them or until the client session exits. You can use: Alter session close database link 'link_name';
You must commit or rollback before closing the link. Otherwise you cannot close it.
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Subbiah, Nagarajan Sent: Wednesday, February 09, 2005 12:29 AM To: 'oracle-l@(protected)' Subject: Remote Sequence is not releasing the connection
We have a synonym in local database for a sequence, which is in remote database. After selecting the nextval from the local database, there is a session opened in the remote database but not closing the session after the 'select' is completed. . We are at HP11.11 and Oracle 9.2.0.5. Over the period of time, it gives the "ORA-01000 (See ORA-01000.ora-code.com) number of open cursors exceeded" error. Open cursors value was increased to triple the value but still the problem persists. Any idea is this a bug or missing any configuration. If the synonym is dropped and actual sequence is created in the local database, then there are no issues. =20 Raja Ph: (212) 210 1461 =20
