Database Administration (MOSC)

MOSC Banner

Open Sessions to DB Links in Shared Server mode

edited Dec 21, 2010 5:17AM in Database Administration (MOSC) 4 commentsAnswered
Hello togehter,
we have the following problem related to DB links in shared server mode:

We access our database (Oracle 10.x, I call it local database) via an application Server (JBoss). These database contains different database links to other oracle databases (I call it external database). Because of ORA-24777 (Ora-24777: Use Of Non-Migratable Database Link Not Allowed" Using Oracle XA Datasource When Executing a Select via DBLink [ID 879543.1]), we had to configure the local database in shared server mode, to gain access to the external databases via the DB links.

Now we have the problem, that the external DB has many open database sessions from our local database - they dont get closed!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center