Oracle 备忘录

1. Oracle with XA Recovery 

When you come across recovery error with Oracle database, make sure the Oracle user does have proper permissions. You run below script to set up proper permissions for Oracle User.

 

SQL> @d:/ora921/rdbms/admin/xaview.sql

 

SQL> grant FORCE ANY TRANSACTION to someuser ;

SQL> grant select on v$xatrans$ to someuser ;

SQL> grant select on pending_trans$ to someuser;

SQL> grant select on dba_2pc_pending to someuser;

SQL> grant select on dba_pending_transactions to someuser;

SQL> grant execute on dbms_system to someuser;

 

2. Oracle varchar2 problem with ZHS16GBK character set

When character set of Oracle 92i is ZHS16GBK, the Oracle 92i driver has a bug. The problem is that the SQL type of a column is varchar2(4000), we are not able to insert 2001 english characters into the column. Using Oralce 10.1.0.4 driver to solve the problem.