Skip to Content
0
Jan 17, 2012 at 01:17 PM

Change the password of SYSTEM User in the Standby Server

737 Views

Hello,

1. How to check user status , when database is in MOUNT stage. ? (Locked/Expired)

2. 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?

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.

regards,

Zerandib