且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

一次oracle RAC的启动故障记录

更新时间:2022-09-26 09:30:41

Tue Oct 13 13:43:19 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Tue Oct 13 13:43:19 2009
Errors in file /u01/app/oracle/product/10.2.0/db_1/rdbms/log/racdb1_ora_24142.trc:
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:skgxnqtsz failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: SKGXN not av
clsssinit ret = 21
interconnect information is not available from OCR
  WARNING: No cluster interconnect has been specified. Depending on
           the communication driver configured Oracle cluster traffic 
           may be directed to the public interface of this machine.
           Oracle recommends that RAC clustered databases be configured
           with a private interconnect for enhanced security and
           performance.
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 300
  sessions                 = 335
  __shared_pool_size       = 318767104
  __large_pool_size        = 16777216
  __java_pool_size         = 16777216
  __streams_pool_size      = 0
  spfile                   = /u01/app/oracle/oradata/RACDB/spfileracdb.ora
  sga_target               = 1241513984
  control_files            = /u01/app/oracle/oradata/RACDB/controlfile/o1_mf_5f5osr3z_.ctl, /u01/app/oracle/flash_recovery_area/RACDB/controlfile/o1_mf_5f5osrg2_.ctl
  db_block_size            = 8192
  __db_cache_size          = 872415232
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  cluster_database         = TRUE
  cluster_database_instances= 2
  db_create_file_dest      = /u01/app/oracle/oradata
  db_recovery_file_dest    = /u01/app/oracle/flash_recovery_area
  db_recovery_file_dest_size= 21474836480
  thread                   = 1
  instance_number          = 1
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=racdbXDB)
  remote_listener          = LISTENERS_RACDB
  job_queue_processes      = 10
  background_dump_dest     = /u01/app/oracle/admin/racdb/bdump
  user_dump_dest           = /u01/app/oracle/admin/racdb/udump
  core_dump_dest           = /u01/app/oracle/admin/racdb/cdump
  audit_file_dest          = /u01/app/oracle/admin/racdb/adump
  db_name                  = racdb
  open_cursors             = 300
  pga_aggregate_target     = 413138944
Cluster communication is configured to use the following interface(s) for this instance
  192.168.1.146
Tue Oct 13 13:43:20 2009
cluster interconnect IPC version:Oracle UDP/IP
IPC Vendor 1 proto 2
PMON started with pid=2, OS id=24244
DIAG started with pid=3, OS id=24246
PSP0 started with pid=4, OS id=24248
LMON started with pid=5, OS id=24250
LMD0 started with pid=6, OS id=24252
LMS0 started with pid=7, OS id=24254
LMS1 started with pid=8, OS id=24264
MMAN started with pid=9, OS id=24274
DBW0 started with pid=10, OS id=24276
LGWR started with pid=11, OS id=24278
CKPT started with pid=12, OS id=24280
SMON started with pid=13, OS id=24282
RECO started with pid=14, OS id=24284
CJQ0 started with pid=15, OS id=24286
MMON started with pid=16, OS id=24288
MMNL started with pid=17, OS id=24290Tue Oct 13 13:43:20 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
USER: terminating instance due to error 29702
Instance terminated by USER, pid = 24142









本文转自 jxwpx 51CTO博客,原文链接:http://blog.51cto.com/jxwpx/211793,如需转载请自行联系原作者