共享一个oracle账号ORA-10997:another startup/shutdown operation of this instance in progress解决方法

ORA-10997:another startup/shutdown operation of this instance in progress解决方法

 

今晚想学习一下oracle,开库:

        SQL> startup

        ORA-10997: another startup/shutdown operation of this instance inprogress

        ORA-09967: unable to create or open lock file

        Linux Error: 13: Permission denied

  www.2cto.com  

    百度、谷歌了好久,网上的方法试了很多,都打水漂了,就差重新dbca。

    然、天无绝人之路,终于在OTN上看到了一种方法:

    root@think-V30SA:~# chown -R oracle:dba /u01/app/oracle/

[sql] 

<span xmlns="https://www.w3.org/1999/xhtml" style="">oracle@think-V30SA:~$ sqlplus /nolog  

  

SQL*Plus: Release 10.2.0.1.0 – Production on Wed Oct 17 19:28:51 2012  

  

Copyright (c) 1982, 2005, Oracle.  All rights reserved.  

  

SQL> conn / as sysdba  

Connected to an idle instance.  

SQL> startup  

ORACLE instance started.  

  

Total System Global Area  599785472 bytes  

Fixed Size          1220772 bytes  

Variable Size         205524828 bytes  

Database Buffers      385875968 bytes  

Redo Buffers           &nbsporacle账号;7163904 bytes  

Database mounted.  

Database opened.  

</span>  

    我艹,终于成功了,罪魁祸首原来是权限搞得。唉…..

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。