SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance
求大侠急救
alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance
求大侠急救
Connected to an idle instance.
SQL> startup
ORACLE instance started.Total System Global Area 5771362304 bytes
Fixed Size 1986976 bytes
Variable Size 1006636640 bytes
Database Buffers 4747952128 bytes
Redo Buffers 14786560 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance 一着急弄错了!启动时候报的错。其实数据库是没有启动的。
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug 22 10:26:57 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn sys/uwaysoft as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup force
ORACLE instance started.Total System Global Area 5771362304 bytes
Fixed Size 1986976 bytes
Variable Size 1006636640 bytes
Database Buffers 4747952128 bytes
Redo Buffers 14786560 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
SQL>
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
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 = 150
__shared_pool_size = 973078528
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 0
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 5771362304
control_files = /oracle/oracle/oradata/CNOAP/control01.ctl, /oracle/oracle/oradata/CNOAP/control02.ctl, /oracle/oracle/oradata/CNOAP/control03.ctl
db_block_size = 16384
__db_cache_size = 4747952128
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /oracle/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=CNOAPXDB)
local_listener = (ADDRESS_LIST=(Address=(Protocol=tcp) (Host=test)(Port=1521)))
job_queue_processes = 10
background_dump_dest = /oracle/oracle/admin/CNOAP/bdump
user_dump_dest = /oracle/oracle/admin/CNOAP/udump
core_dump_dest = /oracle/oracle/admin/CNOAP/cdump
audit_file_dest = /oracle/oracle/admin/CNOAP/adump
db_name = CNOAP
open_cursors = 300
pga_aggregate_target = 1922039808
PMON started with pid=2, OS id=25439
PSP0 started with pid=3, OS id=25441
MMAN started with pid=4, OS id=25443
DBW0 started with pid=5, OS id=25445
LGWR started with pid=6, OS id=25447
CKPT started with pid=7, OS id=25449
SMON started with pid=8, OS id=25451
RECO started with pid=9, OS id=25453
CJQ0 started with pid=10, OS id=25455
MMON started with pid=11, OS id=25457
MMNL started with pid=12, OS id=25459
Sat Aug 22 10:51:59 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Aug 22 10:51:59 2009
ALTER DATABASE MOUNT
Sat Aug 22 10:52:03 2009
Setting recovery target incarnation to 1
Sat Aug 22 10:52:03 2009
Successful mount of redo thread 1, with mount id 1242437711
Sat Aug 22 10:52:03 2009
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sat Aug 22 10:52:03 2009
ALTER DATABASE OPEN
Sat Aug 22 10:52:04 2009
Beginning crash recovery of 1 threads
Sat Aug 22 10:52:04 2009
Started redo scan
Sat Aug 22 10:52:04 2009
Completed redo scan
0 redo blocks read, 0 data blocks need recovery
Sat Aug 22 10:52:05 2009
Started redo application at
Thread 1: logseq 243, block 108, scn 11535356
Sat Aug 22 10:52:05 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 243 Reading mem 0
Mem# 0 errs 0: /oracle/oracle/oradata/CNOAP/redo3.log
Sat Aug 22 10:52:05 2009
Completed redo application
Sat Aug 22 10:52:05 2009
Completed crash recovery at
Thread 1: logseq 243, block 108, scn 11555357
0 data blocks read, 0 data blocks written, 0 redo blocks read
Sat Aug 22 10:52:06 2009
Thread 1 advanced to log sequence 244
Thread 1 opened at log sequence 244
Current log# 2 seq# 244 mem# 0: /oracle/oracle/oradata/CNOAP/redo2.log
Successful open of redo thread 1
Sat Aug 22 10:52:06 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Aug 22 10:52:06 2009
SMON: enabling cache recovery
Sat Aug 22 10:52:07 2009
Successfully onlined Undo Tablespace 1.
Sat Aug 22 10:52:07 2009
SMON: enabling tx recovery
Sat Aug 22 10:52:07 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=25474
Sat Aug 22 10:52:08 2009
Errors in file /oracle/oracle/admin/CNOAP/udump/cnoap_ora_25465.trc:
ORA-07445: exception encountered: core dump [par4f2()+680] [SIGBUS] [Invalid address alignment] [0xFFFFFFFF6EC119FF] [] []上面是我一个启动的alert.log
这种错误出现的原因有很多
谁到metalink,看看,有没有以前有这种问题的