ERROR:
ORA-28000: the account is locked
Steps:
Step 1:
Check if you have ORACLE_HOME in your environment, run next command.
echo $ORACLE_HOME
Result:
Step 2:
-If you have ORACLE_HOME past step 3.
If you don't have ORACLE_HOME in your environment.
Check if you have ORACLE_HOME in your environment, run next command.
echo $ORACLE_HOME
Result:
Step 2:
-If you have ORACLE_HOME past step 3.
If you don't have ORACLE_HOME in your environment.
2.1 -> Find the directory oracle, where you were install.
2.2 -> export ORACLE_HOME=your_path_oracle
Example: export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
2.3 -> export PATH=your_path_oracle_bin:$PATH
Example: export PATH=/u01/app/oracle/product/11.2.0/xe/bin:$PATH
2.4 -> cd ~/
2.5 -> vim .bash_profile
2.6 -> Add next lines in the end file.
ORACLE_SID=XE
export ORACLE_SID
ORACLE_HOME=your_path_oracle
export ORACLE_SID
ORACLE_HOME=your_path_oracle
#ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH
export PATH
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH
export PATH
2.7 -> Save and exit.
:wq
Check again if you have ORACLE_HOME in your environment.
Step 4: Run next command:
alter user YOUR_USER account unlock;
Please check again your connection with your user unlock.
References:
http://techxploration.blogspot.com/2012/01/resolving-sp2-0750-you-may-need-to-set.html