ORA-01219:database not open:queries allowed on fixed tables/views only
来源:互联网 发布:tgp深度优化原理 编辑:程序博客网 时间:2024/05/02 03:09
“ORA-01219:数据库未打开:仅允许在固定表/视图中查询”的警告窗口!
解决办法:
登录Oracle SQL*Plus
username sys
password sa
String orcl as sysdba
这一段是找出打开数据库的时候报错的地方
SQL> select open_mode from v$database;
OPEN_MODE ---------- MOUNTED
SQL> alter database open; alter database open * ERROR at line 1: ORA-01157: cannot identify/lock data file 4 - see DBWR trace file ORA-01110: data file 4: '/data/app/oradata/ora237/users01.dbf'
这里就是讲'/data/app/oradata/ora237/users01.dbf'这个文件出问题
我们要做的就是删掉这个残留文件
进行下一步:
SQL> alter database datafile '/data/app/oradata/ora237/users01.dbf' offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL>
到此为止,问题解决了
转自:http://www.cnblogs.com/wuxi/archive/2012/12/28/2836958.html
- ORA-01219:database not open:queries allowed on fixed tables/views only
- ORA-01219:database not open:queries allowed on fixed tables/views only
- ORA-01157报错"cannot identify/lock data file" ORA-01219:database not open:queries allowed on fixed
- ORACLE ORA-02030: can only select from fixed tables/views
- ORACLE ORA-02030: can only select from fixed tables/views
- ORACLE ORA-02030: can only select from fixed tables/views
- ORA-02030: can only select from fixed tables/views
- ORACLE ORA-02030: can only select from fixed tables/views
- ORA-02030: can only select from fixed tables/views
- for pooled tables,cluster tables,and projection views,join is not allowed:"KONV"
- Oracle Apps Lookup Tables,Views,Queries,FAQ
- Hibernate批量删除出现sql异常Connection is read-only. Queries leading ... are not allowed
- 解决ssh中Connection is read-only. Queries leading to data modification are not allowed
- Connection is read-only. Queries leading to data modification are not allowed
- java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
- Connection is read-only. Queries leading to data modification are not allowed
- Connection is read-only. Queries leading to data modification are not allowed
- Connection is read-only. Queries leading to data modification are not allowed
- memcache+php扩展模块的安装
- linux下使用蓝牙设备
- 在android收件箱中创建一条短信
- 封装一个类搞定90%安卓客户端与服务器端交互
- VisionMobile:2013年移动开发者经济报告(十):第二章 开发工具图景(下)
- ORA-01219:database not open:queries allowed on fixed tables/views only
- zookeeper的介绍和部署
- 代码自动生成工具MyGeneration之二
- WINDOWS2008R2系统MongoDB环境搭建手册
- Hadoop基于Shell命令与底层Unix操作系统的交互
- ORA-01849: hour must be between 1 and 12
- 解决ORA-27154,ORA-27300,ORA-27301:No space left on device
- 指针数组和数组指针
- 第二次C程序设计上机报告