Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

ORA-01219: database not open: only allowed to query in fixed tables / views

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)06/02 Report--

I haven't logged in to the Oracle server for a long time. I forgot my password.

Sql > conn sys/sys as sysdba

Sql > alter user system identified by *

The result is ORA-01219: the database is not open: only queries in fixed tables / views are allowed-did you encounter an error if you want to change the password?!

Sql > startup

ORA-01081: unable to start ORACLE that is already running-Please close first

Then sql > shutdown immediate

Sql > startup;-- error persists

In the execution: select open_mode from v$database

Display:

OPEN_MODE

-

MOUNTED

-- return mounted to indicate that the database has been mount

-- return read write or read only to indicate that it is open

-- No mount is not returned

After countless web searches, it is finally solved as follows:

SQL > alter database open

Alter database open

*

An error occurred on line 1:

ORA-01157: unable to identify / lock data file 5-see DBWR trace file

ORA-01110: data file 5:'I:\ ORACLE\ ORADATA\ CC\ RMANTS.ORA'

-

SQL > shutdown immediate

ORA-01109: the database is not open

The database has been uninstalled.

The ORACLE routine has been closed.

SQL > startup

The ORACLE routine has been started.

Total System Global Area 293601280 bytes

Fixed Size 1248624 bytes

Variable Size 104858256 bytes

Database Buffers 184549376 bytes

Redo Buffers 2945024 bytes

The database is loaded.

ORA-01157: unable to identify / lock data file 5-see DBWR trace file

ORA-01110: data file 5:'I:\ ORACLE\ ORADATA\ CC\ RMANTS.ORA'

SQL > alter database datafile'i:\ oracle\ oradata\ cc\ rmants.ora' offline drop

The database has changed.

SQL > alter database open

Alter database open

*

An error occurred on line 1:

ORA-01157: unable to identify / lock data file 6-see DBWR trace file

ORA-01110: data file 6:'I:\ ORACLE\ ORADATA\ CC\ RMANSCT.ORA'

SQL > alter database datafile'i:\ oracle\ oradata\ cc\ rmansct.ora' offline drop

The database has changed.

SQL > alter database open

The database has changed.

SQL > conn sys/sys as sysdba

Connected.

SQL > alter user system identified by oracle

The user has changed.

SQL > alter user scott identified by tiger

SQL > conn scott/tiger

Connected.

SQL > select * from tab

TNAME TABTYPE CLUSTERID

DEPT TABLE

EMP TABLE

BONUS TABLE

SALGRADE TABLE

PLAN_TABLE TABLE

DEPT_LOG TABLE

DEPT_NAME VIEW

DEPT_AUDIT TABLE

DEPT_AUDITION TABLE

D_AUDITION TABLE

Ten rows have been selected.

(this article is an excerpt: http://user.qzone.qq.com/123099567)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report