oracle 10g alter
hello,
it's too odd to ask a question about 10g, we have plan to upgrade this database to 12.2 in next month..
but before that i got some error like this. Does anyone come across this situation. can we do something without database shutdown ?
I reset my password to 'temp123' for my id: ramya1
SQL> show user
USER is "SYS"
SQL> select version from v$instance;
VERSION
-----------------
10.2.0.3.0
SQL> alter user ramya1 identified by temp123tom;
User altered.
SQL> connect ramya1/ temp123tom
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.