Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-24777 : use of non -migratable database link not allowed

vishal patelDec 14 2007 — edited Oct 21 2009
Hi
All,

ORA-24777 : use of non -migratable database link not allowed.

Anybody have idea to resolve this.

Thanks,
Vishal

Comments

damorgan
Depends on whether you are at MDU Resources. <g>

First ...
What product or tool?
What version (3+ decimal places)
What were you doing (specific DDL statement) that generated the error

Most likely the issue relates to the fact that one machine is set up with Shared Server (MTS) and the other is not. If this is the case you need to connect through the dispatcher not the link.
Girish Sharma
ORA-24777: use of non-migratable database link not allowed
Cause: The transaction, which needs to be migratable between sessions, tried to access a remote database from a non-multi threaded server process.
Action: Perform the work in the local database or open a connection to the remote database from the client. If multi threaded server option is installed, connect to the Oracle instance through the dispatcher.
vishal patel
Error coming from application side. the application team said that they are getting an error when they trying to access one database (OFROI) to other database (PICS).

I notice that dblink from OFROI to PICS is working fine. and OFROI is in shared mode.

But on the other machine where PICS database is not in shared mode.
What product or tool? --> ORACLE
What version (3+ decimal places) --> 9.2.0.6
What were you doing (specific DDL statement) that generated the error
can you provide more focus on how to check it's MTS or not?
please provide focus on this.

Thanks,
Vishal

Message was edited by:
vishal patel

Message was edited by:
vishal patel
vishal patel
Finally i got solution that dispatcher was set correctly.
when issue lsnrctl status it showed that status is unknown for the instance and when i issue lsnrctl services it was not showing dispatcher.
when i issue show parameter mts; the parameter mts_dispatcher was set to
(PROTOCOL=TCP) (DISPATCHERS=2). so oracle said that add HOST to it. then we add HOST in that parameter. restart the database. so now it's working fine.

Thanks for your help

vishal

Message was edited by:
vishal patel
247514
Check this old thread of similar topic,

2270981

OH wait, it was started by you too. Why start a new one while not continuing on the old one.

Message was edited by:
yingkuan
vishal patel
ya that's true because each thread containg the different information.

Vishal
726188
Dear expect,
According to the solution above, it needs add HOST to it. May I know which database server? Source or target? For example, when i create a dblink from source to target, shall the host added in the source database server or target database server? Please kindly advice!
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 18 2009
Added on Dec 14 2007
#general-database-discussions
7 comments
21,679 views