ORA-24777: use of non-migratable database link not allowed
SQL> select * from v$version;BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production
两个节点rac aix6.1
数据库迁移以后问题多多呀，昨晚数据库一个实例自动重启了，今天又有程序报错。
在plsql可以执行
SELECT (CASE WHEN TO_CHAR(SYSDATE,'YYYYMMDD') >= TO_CHAR(a.eff_date,'YYYYMMDD')
AND TO_CHAR(SYSDATE,'YYYYMMDD') < TO_CHAR(a.exp_date,'YYYYMMDD') THEN a.sms_content
ELSE a.default_content END)
INTO v_sms_suffix
FROM credit.code_sms_suffix@link_acct1 a
WHERE a.serv_code = '*' AND a.user_type = '*' AND ROWNUM < 2 ;
但是直接在程序上执行，报错ORA-24777: use of non-migratable database link not allowed TRG_LOG_COMM_GSM_CRECIT SQL> select * from v$option;
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Partitioning TRUE
Objects TRUE
Real Application Clusters TRUE
Advanced replication TRUE
Bit-mapped indexes TRUE
Connection multiplexing TRUE
Connection pooling TRUE
Database queuing TRUE
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Parallel backup and recovery TRUE
Parallel execution TRUE
Parallel load TRUE
Point-in-time tablespace recovery TRUE
Fine-grained access control TRUE
Proxy authentication/authorization TRUE
Change Data Capture TRUE
Plan Stability TRUE
Online Index Build TRUE
Coalesce Index TRUE
Managed Standby TRUE
Materialized view rewrite TRUE
Materialized view warehouse refresh TRUE
Database resource manager TRUE
Spatial TRUE
Visual Information Retrieval TRUE
Export transportable tablespaces TRUE
Transparent Application Failover TRUE
Fast-Start Fault Recovery TRUE
Sample Scan TRUE
Duplexed backups TRUE
Java TRUE
OLAP Window Functions TRUE
Block Media Recovery TRUE
Fine-grained Auditing TRUE
Application Role TRUE
Enterprise User Security TRUE
Oracle Data Guard TRUE
Oracle Label Security FALSE
OLAP TRUE
Table compression TRUE
Join index TRUE
Trial Recovery TRUE
Data Mining TRUE
Online Redefinition TRUE
Streams Capture TRUE
File Mapping TRUE
Block Change Tracking TRUE
Flashback Table TRUE
Flashback Database TRUE
Data Mining Scoring Engine FALSE
Transparent Data Encryption TRUE
Backup Encryption TRUE
Unused Block Compression TRUE
Oracle Database Vault FALSE
Real Application Testing TRUE
56 rows selected.
$ oerr ora 24777
24777, 00000, "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. 你如何确定你的PL/SQL 连接的是哪个实例？ liuwenqing 发表于 2014-11-26 11:35 static/image/common/back.gif
你如何确定你的PL/SQL 连接的是哪个实例？
你指的是本地连接的实例还是 db_link远程连接数据库的实例呢 ？
db_link是通过这连接串连接远程数据库实例的：
CCT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.59.x.x)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.59.x.x)(PORT = 1521))
(LOAD_BALANCE = off)
(FAILED_OVER=on)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = acct)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=preconnect)
(RETRIES=5)
(DELAY=10)
)
)
)
页:
[1]