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 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
USER: terminating instance due to error 29702
Instance terminated by USER, pid = 24142
本文转自 jxwpx 51CTO博客,原文链接:http://blog.51cto.com/jxwpx/211793,如需转载请自行联系原作者