一次oracle RAC的启动故障记录

简介:
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,如需转载请自行联系原作者
目录
相关文章
|
8天前
|
存储 Oracle 关系型数据库
数据库数据恢复—ORACLE常见故障的数据恢复方案
Oracle数据库常见故障表现: 1、ORACLE数据库无法启动或无法正常工作。 2、ORACLE ASM存储破坏。 3、ORACLE数据文件丢失。 4、ORACLE数据文件部分损坏。 5、ORACLE DUMP文件损坏。
41 11
|
2月前
|
存储 Oracle 关系型数据库
数据库数据恢复—Oracle ASM磁盘组故障数据恢复案例
Oracle数据库数据恢复环境&故障: Oracle ASM磁盘组由4块磁盘组成。Oracle ASM磁盘组掉线 ,ASM实例不能mount。 Oracle数据库故障分析&恢复方案: 数据库数据恢复工程师对组成ASM磁盘组的磁盘进行分析。对ASM元数据进行分析发现ASM存储元数据损坏,导致磁盘组无法挂载。
|
4月前
|
运维 Oracle 前端开发
Oracle 11g RAC集群日常运维命令总结
Oracle 11g RAC集群日常运维命令总结
107 2
|
4月前
|
Oracle 关系型数据库
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
|
5月前
|
存储 负载均衡 Oracle
|
5月前
|
Oracle 关系型数据库 数据库
关系型数据库Oracle 故障转移能力
【7月更文挑战第10天】
65 2
|
5月前
|
存储 Oracle 关系型数据库
|
7月前
|
存储 Oracle 关系型数据库
Oracle RAC:数据库集群的舞动乐章
【4月更文挑战第19天】Oracle RAC是Oracle提供的高可用性数据库解决方案,允许多个实例共享同一数据库,确保业务连续性和数据完整性。通过集群件和全局缓存服务实现服务器间的协调和通信。RAC提供高可用性,通过故障转移应对故障,同时提升性能,多个实例并行处理请求。作为数据管理员,理解RAC的架构和管理至关重要,以发挥其在数据管理中的最大价值。
|
存储 SQL Oracle
Oracle 启动与关闭
本文目录 1. 简介 2. 设置Oracle数据库手工启动 3. Oracle数据库服务说明 4. 关闭Oracle数据库
194 0
Oracle 启动与关闭