In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.