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
虚惊一场
阅读(4388) | 评论(0) | 转发(0) |
