Tuesday, June 12, 2018

ERROR: ORA-28000: the account is locked (CentOS Linux 7)

I share solution the next error:

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.

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
#ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
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 3: Run next command:

sqlplus sys/"YOUR_PASSWORD"@xe as sysdba


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



Creating REST APIs with OpenAPI, Spring Boot 3.3.3, Java 21, and Jakarta

 Introduction In today's software landscape, designing robust and scalable REST APIs is a crucial aspect of application development. Wit...