Oracle Database
--
Questions
--
Followers
Top Experts
ORA-02054 and other messages on Prod DB
Although the database is still up, I am getting these messages (see code box).
I think it has to do with a shell I run to shutdown the dbs every night.
Please see messages below.
I do not nderstand either the DISTRIB TRAN messages because we are not doing replication or something like that. I suspect the application is trying to work as if we had replicated dbs.
Thanks a lot.
I think it has to do with a shell I run to shutdown the dbs every night.
Please see messages below.
I do not nderstand either the DISTRIB TRAN messages because we are not doing replication or something like that. I suspect the application is trying to work as if we had replicated dbs.
Thanks a lot.
SHUTDOWN: Active sessions prevent database close operation
Wed Feb 25 05:00:01 2009
Starting ORACLE instance (normal)
Wed Feb 25 08:05:56 2009
Error 1089 trapped in 2PC on transaction 19.34.962. Cleaning up.
Error stack returned to user:
ORA-02054: transaction 19.34.962 in-doubt
ORA-01089: immediate shutdown in progress - no operations are permitted
Wed Feb 25 08:05:56 2009
DISTRIB TRAN XE.bf7f9569.135.86.1217
is local tran 19.34.962 (hex=13.22.3c2)
insert pending prepared tran, scn=6635350991626 (hex=608.e9bd230a)
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Hi,
Are you using a database link ?
Are you using a database link ?
Yes, we are using a db link to pass information between two databases.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Oracle Database
--
Questions
--
Followers
Top Experts
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.