ORA-24777 use of non-migratable database link not allowedCause: The transaction, which needs to be migratable between sessions, tried to access a remote database from a non-multithreaded server process.Action: Perform the work in the local database or open a connection to the remote database from the client. If the multithreaded server option is installed, connect to the Oracle instance through the dispatcher.
CREATE SHARED DATABASE_LINK DB_LINK_NAME CONNECT TO REMOTE_USER_CODE_1 IDENTIFIED BY USER_PASSWORD_1 AUTHENTICATED BY REMOTE_USER_CODE_2 IDENTIFIED BY USER_PASSWORD_2 USING 'TNSNAME1'
CONNECT TO REMOTE_USER_CODE_1 IDENTIFIED BY USER_PASSWORD_1
AUTHENTICATED BY REMOTE_USER_CODE_2 IDENTIFIED BY USER_PASSWORD_2
USING 'TNSNAME1'