Skip to main content

Posts

Recovering locked accounts or forgotten password accounts in oracle

1. Find the service ID from command line CMD=> type lsnrctl status 2. Find the active instance 3. set oracle_sid = "<SID> " 4. log as sqlplus "/as sysdba" 5. Then connect => conn <user_name>@<sid> 6. Alter user <user_name> ; 7. Alter password identified by <user_name>; simple as that...
Recent posts

Start

It has been a long time am thinking about what is the good stuff for a Computer science student to start his/her carrier.A kind of a big question mark"?".