ora-00205错误

aixcq

                db1@root[/>]su - oracle
db1@root[/oracle>]sqlplus '/as sysdba'
SQL*Plus: Release 9.2.0.6.0 - Production on Mon Mar 16 22:02:17 2009
                        HACMP Event Summary
Event: network_down_complete -1 net_rs232_01
Start time: Mon Mar 16 22:01:21 2009
End time: Mon Mar 16 22:01:21 2009
Action:         Resource:                       Script Name:
----------------------------------------------------------------------------
No resources changed as a result of this event
----------------------------------------------------------------------------
lsnrctl is running
stty: tcgetattr: A specified file does not support the ioctl system call.
SQL*Plus: Release 9.2.0.6.0 - Production on Mon Mar 16 22:01:21 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 3826752000 bytes
Fixed Size                   748032 bytes
Variable Size             671088640 bytes
Database Buffers         3154116608 bytes
Redo Buffers                 798720 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
SQL> Disconnected from 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
Database "pz" warm started.
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to:
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
SQL> connect internal
Enter password:
ERROR:
ORA-01005: null password given; logon denied
Warning: You are no longer connected to ORACLE.
SQL> quit
zjdb1@root[/oracle>]sqlplus system
SQL*Plus: Release 9.2.0.6.0 - Production on Mon Mar 16 22:02:41 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Enter user-name:
crw-rw----   1 root     system       10, 15 Aug 11 2005  rtsm
crw-rw----   1 root     system      168,  1 Mar 16 20:19 rpzcontrol1
crw-rw----   1 root     system      168,  2 Mar 16 20:19 rpzcontrol2
crw-rw----   1 root     system      168,  3 Mar 16 20:19 rpzcontrol3
ALTER DATABASE   MOUNT
Mon Mar 16 22:01:22 2009
ORA-00202: controlfile: '/dev/rpzcontrol1'
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 11
Mon Mar 16 22:01:22 2009
ORA-205 signalled during: ALTER DATABASE   MOUNT...
问题原因:
在做VG export/import后,系统自动改为root:system ,必须手工去更改文件属主为oracle:dba
虚惊一场
               
               
               
               
               

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/12487/showart_1865318.html