将数据库和中间件应用都启动在DB2上，
启动数据库就报了下面的错误
Total System Global Area 5185708448 bytes
Fixed Size 749984 bytes
Variable Size 989855744 bytes
Database Buffers 4194304000 bytes
ORA-00205: error in identifying control file, check alert log for more info
去把控制文件的属主由root system改为oracle:dba
这个错误解决
又遇到下面的错误
Total System Global Area 5185708448 bytes
Fixed Size 749984 bytes
Variable Size 989855744 bytes
Database Buffers 4194304000 bytes
Redo Buffers 798720 bytes
Database mounted.
ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: '/dev/ryzsystem01'
查查资料挺吓人的，主要是坏的是system
查看日志也没进展
db2@root[/oracle/app/oracle/admin/yz/bdump>]more yz_lgwr_1478808.trc
/oracle/app/oracle/admin/yz/bdump/yz_lgwr_1478808.trc
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
ORACLE_HOME = /oracle/app/oracle/product/9.2.0.6
System name: AIX
Node name: db2
Release: 2
Version: 5
Machine: 00CXXXXX4C00
Instance name: yz
Redo thread mounted by this instance: 1
Oracle process number: 4
Unix process pid: 1478808, image: oracle@db2 (LGWR)
*** 2008-06-13 22:22:05.762
*** SESSION ID:(3.1) 2008-06-13 22:22:05.752
Checking if LNS processes need to be shutdown..
最后把这个VG export了一次，再重新import，之后记住修改/dev下裸设备的属主
db2@root[/dev>]chown oracle:dba ryz*
db2@root[/dev>]chown oracle:dba rcon*
chown: rcon*: A file or directory in the path name does not exist.
zjdb2@root[/dev>]ls -l ryzcon*
crw-rw---- 1 oracle dba 49, 1 Jun 13 22:30 ryzcontrol1
crw-rw---- 1 oracle dba 49, 2 Jun 13 22:30 ryzcontrol2
crw-rw---- 1 oracle dba 49, 3 Jun 13 22:30 ryzcontrol3
zjdb2@root[/dev>]chown oracle:dba rper*
再次启动数据库
db2@root[/oracle>]lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production on 13-JUN-2008 22:32:08
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /oracle/app/oracle/product/9.2.0.6/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
System parameter file is /oracle/app/oracle/product/9.2.0.6/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/9.2.0.6/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.18.10.42)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zjdb2pr)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
Start Date 13-JUN-2008 22:32:08
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/9.2.0.6/network/admin/listener.ora
Listener Log File /oracle/app/oracle/product/9.2.0.6/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.18.10.42)(PORT=1521)))
The listener supports no services
The command completed successfully
db2@root[/oracle>]sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Fri Jun 13 22:32:19 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 5185708448 bytes
Fixed Size 749984 bytes
Variable Size 989855744 bytes
Database Buffers 4194304000 bytes
Redo Buffers 798720 bytes
Database mounted.
ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: '/dev/ryzsystem01'
报错依旧啊
修改为ONLINE
SQL> alter database datafile '/dev/ryzsystem01' online;
Database altered.
打开数据库到OPEN
SQL> alter database open;
Database altered.
正常关闭
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
再次启动
SQL> startup
ORACLE instance started.
Total System Global Area 5185708448 bytes
Fixed Size 749984 bytes
Variable Size 989855744 bytes
Database Buffers 4194304000 bytes
Redo Buffers 798720 bytes
Database mounted.
Database opened.
SQL>
正常了
阅读(1898) | 评论(0) | 转发(0) |
