- 论坛徽章:
- 1
|
错误信息如下:
请输入用户名: sys as sysdba
输入口令:
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ERROR:
ORA-01219: ??????: ???????/?????
SP2-0611: 启用 EXPLAIN 报告时出错
搜集统计信息时出错 ORA-1219
SP2-0611: 启用 STATISTICS 报告时出错
SQL>
SQL> startup
ORA-01031: ????
SQL> shutdown
ORA-01031: ????
SQL>
SQL>
SQL>
SQL>
SQL> select open_mode from v$database;
select open_mode from v$database
*
第 1 行出现错误:
ORA-01507: ??????
我是sys用户登录的,怎么没权限?之前做过什么了,修改了控制文件的路劲。
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
control_file_record_keep_time integer 7
control_files string F:\APP
control_management_pack_access string DIAGNOSTIC+TUNING
这是修改该后的路劲。导致无法启动。
我想改回来但是没权限:求大侠指导下,谢谢!
SQL> alter system set control_files='F:\app\Administrator\oradata\orcl\CONTROL01.CTL','F:\app\Administrator\flash_recovery_area\orcl\CONTROL02.CTL' scope=spfile;
alter system set control_files='F:\app\Administrator\oradata\orcl\CONTROL01.CTL','F:\app\Administrator\flash_recovery_area\orcl\CONTROL02.CTL' scope=spfile
*
第 1 行出现错误:
ORA-01031: ????
已用时间: 00: 00: 00.00
|
|