-
编辑 删除
运行 create database脚本出现control file的问题
SQL> shutdown immediateORA-00210: cannot open the specified control fileORA-00202: control file: '/u01/app/oracle/oradata/enmo/ora_control2.ctl'ORA-27041: unable to open fileLinux-x86_64 Error: 13: Permission deniedAdditional information: 3解决办法：修改/u01/app/oracle/oradata/enmo的属主...
-
编辑 删除
手工建库时启动到nomount状态时错误ORA-09925，ORA-01017
配置好pfile和口令文件后启动数据库到nomount状态下出现错误：[oracle@localhost ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 1 19:23:55 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.ERROR:ORA-09925: Unable to create audit trail fileLinux-x86_64 Er...
-
编辑 删除
ORA-01012:not logged on的解决办法
1.shutdown abort;2.SQL> exitDisconnected[oracle@localhost ~]$ ps -ef|grep ora_dbw0_$ORACLE_SIDoracle 15085 14549 0 18:05 pts/3 00:00:00 grep ora_dbw0_ENMOEDU3.[oracle@localhost ~]$ kill -9 14549
