CICS与ORACLE连接问题！

tzg

确认：
1、XAD的类型不是NO_XA
2、ORACLE的NET8是DEDICATED SERVER
3、CICS程序规范是程序员所编写，没问题

tzg

步骤：
1、select a.program,b.spid from v$session a,v$process b where a.paddr=b.addr and osuser='cics'
        PROGRAM                        SPID
cicsas@sfhc2 (TNS V1-V3)        127066
cicsas@sfhc2 (TNS V1-V3)        32160
cicsas@sfhc2 (TNS V1-V3)        19540
cicsas@sfhc2 (TNS V1-V3)        112270
cicsas@sfhc2 (TNS V1-V3)        64434
cicsas@sfhc2 (TNS V1-V3)        28024
cicsas@sfhc2 (TNS V1-V3)        100458
cicsas@sfhc2 (TNS V1-V3)        42798
cicsas@sfhc2 (TNS V1-V3)        122914

2、ps -ef|grep cicsas
    cics  56448  47166   0 09:30:21      -  0:00 cicsas cicssfhc 50987025 104 a0000000 b0000000

3、ps -ef|grep 127066
  oracle 127066      1   0 09:36:10      -  0:01 oraclesfhc (LOCAL=NO)
   ps -ef|grep 32160
  oracle  32160      1   0 09:36:13      -  0:00 oraclesfhc (LOCAL=NO)
   ps -ef|grep 19540
  oracle  19540      1   0 09:36:15      -  0:00 oraclesfhc (LOCAL=NO)
  其余的几个ORACLE SESSION都一样：所有的父进程都是1

tzg

CICS的版本是4.2，补丁号为9即为4.2.0.9
ORACLE的版本号为8.1.5.0.0

改了XAD的描述为：
XAOpen="Oracle_XA+Acc=P/sfhc@sfhc/insysf1we9+SesTm=10+LogDir=/tmp/xa+DbgFl=15"

但没有改ORACLE的参数DISTRIBUTED_TRANSACTIONS（系统使用中）

可是没有产生XA LOG，真是奇怪！

tzg

init.ora

compatible = "8.1.0"

db_name = sfhc
instance_name = sfhc
service_names = sfhc
control_files = ("/soft/oracle/oradata/OraCtl1.ctl","/soft/oracle/oradata/OraCtl2.ctl","/soft/oracle/oradata/OraCtl3.ctl"
db_files = 1000
db_block_size = 8192
db_file_multiblock_read_count =8 #2003/7/16 modify by tjg
db_block_buffers = 204800  
shared_pool_size = 524288000            
shared_pool_reserved_size = 125829120   
processes = 1500
sessions  =1000     
log_buffer = 1048576           
rollback_segments=(r01,r02,r03,r04)
background_dump_dest = /soft/oracle/admin/sfhc/bdump
core_dump_dest = /soft/oracle/admin/sfhc/cdump
user_dump_dest = /soft/oracle/admin/sfhc/udump
remote_login_passwordfile = exclusive
os_authent_prefix = ""
pre_page_sga = yes
optimizer_features_enable = 8.1.5
optimizer_mode = choose
optimizer_percent_parallel = 50
optimizer_index_caching = 30
disk_asynch_io = true
tape_asynch_io = true
large_pool_size = 52428800 #2003/12/08 add by tzg
resource_limit = true
gc_releasable_locks = 89600  #db_block_buffers
enqueue_resources = 6000
open_cursors = 300
session_cached_cursors = 30
sort_area_size =  4194304         
sort_area_retained_size = 1048576     
sort_multiblock_read_count = 8
hash_join_enabled = true
hash_area_size    = 16777216
hash_multiblock_io_count = 8
bitmap_merge_area_size =  4194304   
create_bitmap_area_size = 12582912  
star_transformation_enabled = true
query_rewrite_enabled = true
_push_join_predicate = true
log_checkpoint_interval = 9999999
log_checkpoint_timeout  = 0
log_checkpoints_to_alert = true
log_archive_start = true
log_archive_dest_1 = "location=/oracle_arch reopen=10"
log_archive_format = %t_%s.dbf
nls_language = "simplified chinese"
nls_territory = "china"
nls_date_format = "YYYY-MM-DD"
job_queue_processes=1     
job_queue_interval=60

tzg

listener.ora

# LISTENER.ORA Configuration File:/soft/oracle/product/8.1.5/network/admin/listener.ora
# Generated by Oracle Net8 Assistant

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = sfhc)
      (ORACLE_HOME = /soft/oracle/product/8.1.5)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.210)(PORT = 1521))

      )
    )
  )

tzg

tnsnames.ora

sfhc=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.210)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = sfhc)
    )
  )
was =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.9)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = was )
    )
  )

sfhc1=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.212)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = sfhc)
    )
  )

sfhc2=
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.213)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = sfhc)
    )
  )

rman=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 128.1.1.182)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = rman)
    )
  )

tzg

无sqlnet.ora

修改XAD后冷启动了CICS