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'这个文件出问题 我们要做的就是删掉...
ORA-01219:database not open:queries allowed on fixed tables/views only “ORA-01219:数据库未打开:仅允许在固定表/视图中查询”的警告窗口! 解决办法: 登录Oracle SQL*Plus username TIDY password TIDY PL/SQL打开Tables etc 这一段是找出打开数据库的时候报错的地方 (1)SQL> select open_mode from v$data...
ORA-01219:database not open:queries allowed on fixed tables/views only “ORA-01219:数据库未打开：仅允许在固定表/视图中查询”的警告窗口！解决办法：登录Oracle SQL*Plus username sys password sa 这一段是找出打开数据库的时候报错的地方 SQL> select open_mode from v$database;OPEN_MOD...
> SELECT name, open_mode FROM v$pdbs ORDER BY name; NAME OPEN_MODE --- ORCLPDB MOUNTED Change the status to OPEN if it is not (like MOUNTED for example) ALTER PLUGGABLE DATABASE orclpdb OPEN READ WRITE; Share Improve this answer Follow answered Feb 24, 2021 at 11:...
the installation with connection information below: The connection was successful and when I tried to open the Tables, it showed an error OCA-01219: I've found this solution: ORA-01219: database not open: queries allowed on fixed tables/views only that trying to make the...
ORA-01219 :数据库未打开：仅允许在固定表/视图中查询 解决！\x0d\x0aORA-01219:database not open:queries allowed on fixed tables/views only\x0d\x0a\x0d\x0a“ORA-01219:数据库未打开：仅允许在固定表/视图中查询”的警告窗口！ \x0d\x0a\x0d\x0a解决办法：\x0d\x0a\x...
Describe the bug I am trying to query Oracle standby database which is in mount mode (not opened). And when querying the database I am getting DatabaseError: (cx_Oracle.DatabaseError) ORA-01219: database not open: queries allowed on fixe...
数据库还没有打开
解决ORA-01219:database not open:queries allowed on fixed tables/views only 需要几步? 答: 4步 第一步:打开 SQL Plus 连接数据库; 第二步:尝试执行: alterdatabaseopen; 肯定没这么简单,查看报错,拷贝报错文件地址。 第三步:干掉这个文件(其实你可能没有这个文件): ...