Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3179505
  • 博文数量: 949
  • 博客积分: 10126
  • 博客等级: 上将
  • 技术积分: 12100
  • 用 户 组: 普通用户
  • 注册时间: 2006-06-16 10:57
文章分类

全部博文(949)

文章存档

2013年(1)

2012年(4)

2011年(4)

2010年(12)

2009年(342)

2008年(586)

分类:

2009-03-16 22:22:56

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
虚惊一场


阅读(4329) | 评论(0) | 转发(0) |
0

上一篇:备份

下一篇:20090317tag1

给主人留下些什么吧!~~