Change user password , when DB is in mount state
ZerandibJan 17 2012 — edited Jan 17 2012Hello,
1. How to check user status , when database is in MOUNT stage. ? (Locked/Expired)
2. Is it possible to change the password of the user SYSTEM , while database is in mount state.?
If DB is open , we can query DBA_USERS table and can get the details of users (username, account_status,lock_date,expiry_date, etc...)
But , is it possible to query these data, when the DB is in MOUNT state.
3. Im having SYS authority. I want to change the password of SYSTEM user, and make SYSTEM unlock in the Standby Database. (Which is in mount state).
How can i do this?
regards,
Zerandib