We can use SQL * Plus to unlock OE and HR schema come along with Oracle Database later than version 9i as follow;
ALTER USER hr IDENTIFIED BY hr ACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE to hr;
ALTER USER oe IDENTIFIED BY OE ACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE to OE;
Default password for HR is "hr".
