Oracle ORA-01110 简单解决.docVIP

Oracle ORA-01110 简单解决 时间:2012-08-31 08:11来源:未知 作者:admin 点击: 205次 NAME -------------------------------------------------------------------------------- STATUS ------- /u01/app/oracle/oradata/orcl/users01.dbf ONLINE /u01/app/oracle/oradata/orcl/users02.dbf RECOVER SQLshutdownimmediate ORA-01031:insufficie NAME -------------------------------------------------------------------------------- STATUS ------- /u01/app/oracle/oradata/orcl/users01.dbf ONLINE ? /u01/app/oracle/oradata/orcl/users02.dbf RECOVER ? ? SQL?shutdown?immediate ORA-01031:?insufficient?privileges SQL?conn?/?as?sysdba Connected. SQL?shutdown?immediate Database?closed. Database?dismounted. ORACLE?instance?shut?down. SQL?startup ORACLE?instance?started. ? Total?System?Global?Area??304807936?bytes Fixed?Size??????????????????2212856?bytes Variable?Size?????????????192941064?bytes Database?Buffers??????????104857600?bytes Redo?Buffers????????????????4796416?bytes Database?mounted. Database?opened. SQL? SQL? SQL?shutdown?immediate Database?closed. Database?dismounted. ORACLE?instance?shut?down. SQL?startup?mount ORACLE?instance?started. ? Total?System?Global?Area??304807936?bytes Fixed?Size??????????????????2212856?bytes Variable?Size?????????????192941064?bytes Database?Buffers??????????104857600?bytes Redo?Buffers????????????????4796416?bytes Database?mounted. SQL?select?file#,name?from?v$datafile; ? ?????FILE# ---------- NAME -------------------------------------------------------------------------------- ?????????1 /u01/app/oracle/oradata/orcl/system01.dbf ? ?????????2 /u01/app/oracle/oradata/orcl/sysaux01.dbf ? ?????????3 /u01/app/oracle/oradata/orcl/undotbs01.dbf ? ? ?????FILE# ---------- NAME -------------------------------------------------------------------------------- ?????????4 /u01/app/oracle/oradata/orcl/users01.dbf ? ?????????5 /u01/app/oracle/oradata/orcl/users02.dbf ? ? SQL?alter?database?datafile?5?offline; ? Database?altered. ? SQL?alter?database?datafile?5?offline?drop; ? Database?altered