-
sys account expiired how to open it
Hi,
I changed the account status of user sys to expired through oem , Now how to change it back again to the previous status.
Thanks
oracle :9.2.0.7
os :aix 5.2
-
Can you log in as system?
-
Login as any other user with DBA role.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
And ask yourself why you did it!
If I have to choose between two evils, I always like to choose the one I haven't tried yet.
-
Originally Posted by SANJAY_G
Login as any other user with DBA role.
S I can able to login as sys and system too.
aix> sqlplus "/ as sysdba"
logs me into db
aix>i can login as system too
but the aacount_status in dba_users shows me for sys as expired so how to change the status back to open for SYS
Thanks
-
change sys's password, (even if you keep same password) that will reset account_status to open
"expired" status seems to have no meaning for sys - makes total sense (you'd never want sys to expire)
"False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20
-
Exactly. What tomcat said.
Code:
SQL> select username, account_status from dba_users where username = 'SYS';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYS OPEN
SQL> alter user sys password expire;
User altered.
SQL> select username, account_status from dba_users where username = 'SYS';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYS EXPIRED
SQL> alter user sys identified by newpass;
User altered.
SQL> select username, account_status from dba_users where username = 'SYS';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYS OPEN
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|