- 论坛徽章:
- 0
|
ORACLE 92 RAC ON AIX 一个服务器上启动正常;
但另一台服务启动后HACMP.out中正常,使用SQLPLUS登陆报ORA-01033错;
但是如果先shutdown;提示ORA-01507: database not mounted;在startup报错ORA-03113: ORA-03113: end-of-file on communication channel
错误现象如下:
# su - oracle
% sqlplus
SQL*Plus: Release 9.2.0.5.0 - Production on Sun May 15 08
Copyright (c) 1982, 2002, Oracle Corporation. All rights
Enter user-name: test
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
SQL>; conn /as sysdba
Connected.
SQL>; shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL>; startup
ORACLE instance started.
Total System Global Area 2618790648 bytes
Fixed Size 746232 bytes
Variable Size 1560281088 bytes
Database Buffers 1056964608 bytes
Redo Buffers 798720 bytes
ORA-03113: end-of-file on communication channel
SQL>;
ALERT_XXXX.log如下:
Sun May 15 08:37:52 2005
cluster interconnect IPC version:Oracle UDP/IP
IPC Vendor 1 proto 2 Version 1.0
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1
Sun May 15 08:37:52 2005
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun May 15 08:42:30 2005
Starting ORACLE instance (normal)
Sun May 15 08:42:30 2005
Global Enqueue Service Resources = 4086, pool = 4
Sun May 15 08:42:30 2005
Global Enqueue Service Enqueues = 5947
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
GES IPC: Receivers 3 Senders 3
GES IPC: Buffers Receive 1000 Send 530 Reserve 300
GES IPC: Msg Size Regular 440 Batch 2048
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 1157627904
large_pool_size = 16777216
java_pool_size = 318767104
spfile = /dev/rlvora9_spfile
control_files = /dev/rlvcontrol1_150, /dev/rlvcontrol2_150, /dev/rlvcontrol3_150
db_block_size = 8192
db_cache_size = 1056964608
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = LOCATION=/ora91log
log_archive_format = %t_%s.dbf
db_file_multiblock_read_count= 16
cluster_database = TRUE
cluster_database_instances= 2
thread = 1
fast_start_mttr_target = 300
instance_number = 1
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora91
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/ora9/bdump
user_dump_dest = /opt/oracle/admin/ora9/udump
core_dump_dest = /opt/oracle/admin/ora9/cdump
sort_area_size = 524288
db_name = ora9
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 52428800
Sun May 15 08:42:31 2005
Errors in file /opt/oracle/admin/ora9/udump/ora91_ora_17384.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:socket failed with status: 68
ORA-27301: OS failure message: Can't assign requested address
ORA-27302: failure occurred at: sskgxpcre1
Sun May 15 08:50:24 2005
cluster interconnect IPC version:Oracle UDP/IP
IPC Vendor 1 proto 2 Version 1.0 |
|