环境:
使用bcv同步数据过程中发现shutdown immediate时,一直挂起
由于分布事务中使用dblink连接,但是由于tnsname无法连接,无法进行回滚或提交
于是将分布事务删除
Mon Aug 1 10:19:18 2011
Shutting down instance (immediate)
License high water mark = 42
Mon Aug 1 10:20:34 2011
Errors in file /oracle/admin/zhyz/bdump/zhyz2_reco_888898.trc:
ORA-12154: TNS:could not resolve service name
Mon Aug 1 10:24:17 2011
Active call for process 168892 user 'oracle' program 'oracle@acctdb (J000)'
SHUTDOWN: waiting for active calls to complete.
/oracle/admin/zhyz/bdump/zhyz2_reco_888898.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /oracle/product/9.2.0
System name: AIX
Node name: acctdb
Release: 3
Version: 5
Machine: 00CB0DF04C00
Instance name: zhyz2
Redo thread mounted by this instance: 2
Oracle process number: 14
Unix process pid: 888898, image: oracle@acctdb (RECO)
*** SESSION ID:(13.1) 2011-08-01 10:20:34.298
*** 2011-08-01 10:20:34.298
ERROR, tran=26.10.7479973, session#=1, ose=0:
ORA-12154: TNS:could not resolve service name
SQL> desc dba_2pc_pending
Name Null? Type
------------------- --------- ------------------
LOCAL_TRAN_ID NOT NULL VARCHAR2(22)
GLOBAL_TRAN_ID VARCHAR2(169)
STATE NOT NULL VARCHAR2(16)
MIXED VARCHAR2(3)
ADVICE VARCHAR2(1)
TRAN_COMMENT VARCHAR2(255)
FAIL_TIME NOT NULL DATE
FORCE_TIME DATE
RETRY_TIME NOT NULL DATE
OS_USER VARCHAR2(64)
OS_TERMINAL VARCHAR2(255)
HOST VARCHAR2(128)
DB_USER VARCHAR2(30)
COMMIT# VARCHAR2(16)
select * from dba_2pc_pending;
LOCAL_TRAN_ID GLOBAL_TRA STATE MIX A TRAN_COMMENT FAIL_TIME FORCE_TIME RETRY_TIME
---------------------- ---------- ---------------- --- - -------------------- ----------------- ----------------- -----------------
OS_USER OS_TERMINA HOST DB_USER COMMIT#
---------------------------------------------------------------- ---------- -------------------- ------------------------------ ----------------
26.10.7479973 ZHYZ.c8a76 committed no 20110801 10:15:08 20110801 10:20:34
496.26.10.
7479973
acct acctapp ACCT 12320284759265
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('26.10.7479973');
SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('26.10.7479973');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3400509056 bytes
Fixed Size 751232 bytes
Variable Size 1325400064 bytes
Database Buffers 2063597568 bytes
Redo Buffers 10760192 bytes
Database mounted.
SQL>
SQL> alter database open read only;
Database altered.
$ lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 01-AUG-2011 11:25:30
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Starting /oracle/product/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
System parameter file is /oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.133.200.9)(PORT=1526)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.133.200.9)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
Start Date 01-AUG-2011 11:25:30
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/product/9.2.0/network/admin/listener.ora
Listener Log File /oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.133.200.9)(PORT=1526)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "zhyz2" has 1 instance(s).
Instance "zhyz2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ ONLY
回家继续研究...
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26078027/viewspace-1053290/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26078027/viewspace-1053290/